inserting data to mysql using python QT and mysql database

Question

I'm struggling to insert or retrive data from database I tried and I watched many tutorials but every time it stops in cur.execute(). i found problem is in the value like self.FirstNmae.text() funtion stop here

def SignupFunction(self):
    try:
        
        connection = pymysql.connect(host=cr.host, user=cr.user, password=cr.password, database=cr.database)
        
        cur = connection.cursor()
        
        cur.execute("insert into users (FirstNmae , LastName, Email,Password , Confirm_Paswword ,Answer) value( %s, %s, %s, %s, %s, %s)",
            (
                self.FirstNmae.text(),
                self.LastName.text(),
                self.Email.text(),
                self.Password.text(),
                self.Confirm_Paswword.text(),
                self.Answer.text()
            ))
        
        connection.commit()
        
        connection.close()
        self.labelResult.setText("Data Inserted ")
    except Exception as e:
        self.labelResult.setText("Error Inserting Data")

Answer 1

hello friend i'm not able to comment so i will post as answer from your code you are a new developer , your function is good there are no problem in it i think that the problem is in you database look at the database if you are missed something or you mess write attributes like FirstNmae