Connection' object has no attribute 'execute' pymysql

Question

Every time I try to create an account I get this error message: Connection' object has no attribute 'execute' Thank you for helping me.

I am working on an absence management form. I am in the account creation phase. I have set up a MySQL database in order to be able to save the connection information in it.

I attach a part of my code and the libraries:

from tkinter import *
from tkinter import ttk, messagebox
from tkcalendar import *
import pymysql
import pymysql.cursors
import os


                con = pymysql.connect(host="localhost",port=3306, user="root", password="",  database="database")
                cur=  con.cursor()
                con.execute("select * from compte where var=%s", self.var.get())
                row = cur.fetchone()
            
                con.comit()
                con.close

You want `cur.execute()`, not `con.execute()`. – John Gordon Nov 26 '22 at 16:29 — John Gordon, Nov 26 '22 at 16:29

score 0 · Answer 1 · answered Nov 26 '22 at 16:26

I think it should be cur.execute() not con.execute(). Note: Apart from that you have a couple of typos on commit() and close(), See Ref

from tkinter import *
from tkinter import ttk, messagebox
from tkcalendar import *
import pymysql
import pymysql.cursors
import os


con = pymysql.connect(host="localhost",port=3306, user="root", password="",  database="database")
cur= con.cursor()
cur.execute("select * from compte where var=%s", self.var.get())
row = cur.fetchone()   
con.commit()
con.close()

Connection' object has no attribute 'execute' pymysql

1 Answers1