Dec-21-2019, 02:36 PM
Hello,
I'm trying to make a User registration program for work.
I've got my form an created a database.I have written a program like when click the save button it should insert the data into mysql database and popup a message congrats.
When i run the program the form window is open and i click the save button after giving input the window is closed with put any error message.
If someone could help me that'll be awesome.
Thank you in advance!
Aravinth
I'm trying to make a User registration program for work.
I've got my form an created a database.I have written a program like when click the save button it should insert the data into mysql database and popup a message congrats.
When i run the program the form window is open and i click the save button after giving input the window is closed with put any error message.
If someone could help me that'll be awesome.
Thank you in advance!
# -*- coding: utf-8 -*- # Form implementation generated from reading ui file 'AddUser.ui' # # Created by: PyQt5 UI code generator 5.13.2 # # WARNING! All changes made in this file will be lost! from PyQt5 import QtCore, QtGui, QtWidgets import pymysql class Ui_MainWindow(object): def messagebox(self,title,message): mess=QtWidgets.QMessageBox() mess.setWindowTiltle(title) mess.setStandardButtons(QtWidgets.QmessageBox.Ok) mess.exec_() def save(self): FirstName=self.lineEdit.text() LastName=self.lineEdit_2.text() UserName=self.lineEdit_3.text() Password=self.lineEdit_4.text() Role=self.lineEdit_5.text() Designation=self.lineEdit_6.text() Email=self.lineEdit_7.text() conn=pymysql.connect(host="localhost",password="",db="dat") cur=conn.cursor() query=("insert into user(First Name,Last Name,User Name,Password,Role,Designation,Email)Value(%s,%s,%s,%s,%s,%s,%s)") data=cur.execute(query(FirstName,LastName,UserName,Password,Role,Designation,Email)) if(data): self.messagebox("Congrats","Data Saved") def setupUi(self, MainWindow): MainWindow.setObjectName("MainWindow") MainWindow.resize(800, 600) self.centralwidget = QtWidgets.QWidget(MainWindow) self.centralwidget.setObjectName("centralwidget") self.label = QtWidgets.QLabel(self.centralwidget) self.label.setGeometry(QtCore.QRect(160, 120, 131, 21)) font = QtGui.QFont() font.setFamily("Arial Narrow") font.setPointSize(14) self.label.setFont(font) self.label.setObjectName("label") self.label_2 = QtWidgets.QLabel(self.centralwidget) self.label_2.setGeometry(QtCore.QRect(160, 170, 131, 21)) font = QtGui.QFont() font.setFamily("Arial Narrow") font.setPointSize(14) self.label_2.setFont(font) self.label_2.setObjectName("label_2") self.label_3 = QtWidgets.QLabel(self.centralwidget) self.label_3.setGeometry(QtCore.QRect(160, 220, 131, 21)) font = QtGui.QFont() font.setFamily("Arial Narrow") font.setPointSize(14) self.label_3.setFont(font) self.label_3.setObjectName("label_3") self.label_4 = QtWidgets.QLabel(self.centralwidget) self.label_4.setGeometry(QtCore.QRect(160, 270, 131, 21)) font = QtGui.QFont() font.setFamily("Arial Narrow") font.setPointSize(14) self.label_4.setFont(font) self.label_4.setObjectName("label_4") self.label_5 = QtWidgets.QLabel(self.centralwidget) self.label_5.setGeometry(QtCore.QRect(160, 310, 131, 21)) font = QtGui.QFont() font.setFamily("Arial Narrow") font.setPointSize(14) self.label_5.setFont(font) self.label_5.setObjectName("label_5") self.label_6 = QtWidgets.QLabel(self.centralwidget) self.label_6.setGeometry(QtCore.QRect(160, 350, 131, 21)) font = QtGui.QFont() font.setFamily("Arial Narrow") font.setPointSize(14) self.label_6.setFont(font) self.label_6.setObjectName("label_6") self.label_7 = QtWidgets.QLabel(self.centralwidget) self.label_7.setGeometry(QtCore.QRect(160, 390, 131, 21)) font = QtGui.QFont() font.setFamily("Arial Narrow") font.setPointSize(14) self.label_7.setFont(font) self.label_7.setObjectName("label_7") self.lineEdit = QtWidgets.QLineEdit(self.centralwidget) self.lineEdit.setGeometry(QtCore.QRect(370, 120, 261, 21)) font = QtGui.QFont() font.setFamily("Arial") font.setPointSize(12) self.lineEdit.setFont(font) self.lineEdit.setObjectName("lineEdit") self.lineEdit_2 = QtWidgets.QLineEdit(self.centralwidget) self.lineEdit_2.setGeometry(QtCore.QRect(370, 170, 261, 21)) font = QtGui.QFont() font.setFamily("Arial") font.setPointSize(12) self.lineEdit_2.setFont(font) self.lineEdit_2.setObjectName("lineEdit_2") self.lineEdit_3 = QtWidgets.QLineEdit(self.centralwidget) self.lineEdit_3.setGeometry(QtCore.QRect(370, 220, 261, 21)) font = QtGui.QFont() font.setFamily("Arial") font.setPointSize(12) self.lineEdit_3.setFont(font) self.lineEdit_3.setObjectName("lineEdit_3") self.lineEdit_4 = QtWidgets.QLineEdit(self.centralwidget) self.lineEdit_4.setGeometry(QtCore.QRect(370, 270, 261, 21)) font = QtGui.QFont() font.setFamily("Arial") font.setPointSize(12) self.lineEdit_4.setFont(font) self.lineEdit_4.setInputMethodHints(QtCore.Qt.ImhHiddenText) self.lineEdit_4.setObjectName("lineEdit_4") self.lineEdit_5 = QtWidgets.QLineEdit(self.centralwidget) self.lineEdit_5.setGeometry(QtCore.QRect(370, 310, 261, 21)) font = QtGui.QFont() font.setFamily("Arial") font.setPointSize(12) self.lineEdit_5.setFont(font) self.lineEdit_5.setObjectName("lineEdit_5") self.lineEdit_6 = QtWidgets.QLineEdit(self.centralwidget) self.lineEdit_6.setGeometry(QtCore.QRect(370, 350, 261, 21)) font = QtGui.QFont() font.setFamily("Arial") font.setPointSize(12) self.lineEdit_6.setFont(font) self.lineEdit_6.setObjectName("lineEdit_6") self.lineEdit_7 = QtWidgets.QLineEdit(self.centralwidget) self.lineEdit_7.setGeometry(QtCore.QRect(370, 390, 261, 21)) font = QtGui.QFont() font.setFamily("Arial") font.setPointSize(12) self.lineEdit_7.setFont(font) self.lineEdit_7.setObjectName("lineEdit_7") self.pushButton = QtWidgets.QPushButton(self.centralwidget) self.pushButton.setGeometry(QtCore.QRect(350, 460, 75, 23)) self.pushButton.clicked.connect(self.save) font = QtGui.QFont() font.setFamily("Arial") font.setPointSize(14) font.setBold(False) font.setItalic(False) font.setWeight(9) self.pushButton.setFont(font) self.pushButton.setStyleSheet("background-color: rgb(85, 255, 0);\n" "font: 75 14pt \"Arial\";\n" "border-color: qlineargradient(spread:pad, x1:0, y1:0, x2:1, y2:0, stop:0 rgba(255, 178, 102, 255), stop:0.55 rgba(235, 148, 61, 255), stop:0.98 rgba(0, 0, 0, 255), stop:1 rgba(0, 0, 0, 0));") self.pushButton.setObjectName("pushButton") MainWindow.setCentralWidget(self.centralwidget) self.menubar = QtWidgets.QMenuBar(MainWindow) self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 21)) self.menubar.setObjectName("menubar") MainWindow.setMenuBar(self.menubar) self.statusbar = QtWidgets.QStatusBar(MainWindow) self.statusbar.setObjectName("statusbar") MainWindow.setStatusBar(self.statusbar) self.retranslateUi(MainWindow) QtCore.QMetaObject.connectSlotsByName(MainWindow) def retranslateUi(self, MainWindow): _translate = QtCore.QCoreApplication.translate MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow")) self.label.setText(_translate("MainWindow", "First Name")) self.label_2.setText(_translate("MainWindow", "Last Name")) self.label_3.setText(_translate("MainWindow", "User Name")) self.label_4.setText(_translate("MainWindow", "Password")) self.label_5.setText(_translate("MainWindow", "Role")) self.label_6.setText(_translate("MainWindow", "Designation")) self.label_7.setText(_translate("MainWindow", "Email")) self.pushButton.setText(_translate("MainWindow", "Save")) if __name__ == "__main__": import sys app = QtWidgets.QApplication(sys.argv) MainWindow = QtWidgets.QMainWindow() ui = Ui_MainWindow() ui.setupUi(MainWindow) MainWindow.show() sys.exit(app.exec_())Kind regards,
Aravinth