Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Extracting data from mysql
#1
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"))
Quote
#2
I will be doing something very simular...are there no replies to the original messag?
Quote
#3
I have not received any answer, I am always looking for an answer to this problem. Did you find any information in this topic ??
Quote

Top Page

Forum Jump:


Users browsing this thread: 1 Guest(s)