Python Forum
Extracting data from mysql - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: GUI (https://python-forum.io/forum-10.html)
+--- Thread: Extracting data from mysql (/thread-10067.html)

Extracting data from mysql - xgrzeniu - May-11-2018

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"))


RE: Extracting data from mysql - Bonzadog - May-16-2018

I will be doing something very simular...are there no replies to the original messag?

RE: Extracting data from mysql - xgrzeniu - May-18-2018

I have not received any answer, I am always looking for an answer to this problem. Did you find any information in this topic ??