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
