this is my code: def CreateTab(self):
uname = self.UnamelineEdit.text()
email = self.MaillineEdit.text()
pword = self.PwordlineEdit.text()
con = sqlite3.connect("databasename")
con.execute("INSERT INTO USER(USERNAME,EMAIL,PASSWORD) VALUES(?,?,?)", (uname, email, pword))
if UnameLineEdit.text == "":
print("invalid")
else:
print("data inserted")
con.commit()
con.close()
msg = QMessageBox()
msg.setWindowTitle("Confirmation")
msg.setText("Registeration successful!")
msg.setIcon(QMessageBox.Information)
msg.setStandardButtons(QMessageBox.Retry | QMessageBox.Ignore | QMessageBox.Cancel)
msg.setDefaultButton(QMessageBox.Ignore)
x = msg.exec_()