May-11-2018, 09:32 AM
hi, I have three objects in my program. Two QlinEdit: tpn1; tpn2 and one Qpush Button how to set a value after typing in QlineEdit tpn2 and pressing QpushButton searched the database and the possible result introduced in Qline Edit tpn1 ??? I have such a code, it works correctly but I do not know how to set the search value in the database to incur from QlineEdit tpn2 ?? Can you help ????
class Ui_MainWindow(object): def LoadData(self): conn = pymysql.connect(host="106.90.5.2",user="admin",password="admin123",db="pyqt5") with conn: myCursor=conn.cursor() cur = conn.cursor() cur.execute("select* from data where name like \"fg\"") for i in range(cur.rowcount): result=cur.fetchall() for row in result: self.cursor=QTextCursor(self.artykul1.document()) self.cursor.insertText(str(row[1]+"\n"))