Python Forum
Error :unable to detect undefined names created in spyder ide error at line 2
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error :unable to detect undefined names created in spyder ide error at line 2
#1
import pymysql
from tkinter import *
from tkinter import messagebox
def search():
    try:
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')
        cur=con.cursor()
        sql="select * from student where rollnoo='%s'"%rollno.get()
        cur.execute(sql)
        result=cur.fetchone()
        name.set(result[1])
        age.set(result[2])
        e1.configure(state='disabled')
        con.close()
    except:
        messagebox.showinfo('No data avl')
        clear()
def clear():
    rollno.set('')
    name.set('')
    age.set('')
    e1.configure(state='normal')
def add():
    try:
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')
        cur=con.cursor()
        sql="insert into student values('%s','%s','%s')"%(rollno.get(),name.get(),age.get())
        cur.execute(sql)
        con.commit()
        con.close()
        messagebox.showinfo('success','Record save...')
    except:
        messagebox.showinfo('Error', 'Error in dataentry')
    finally:
        clear()
def update():
    try:
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')
        cur=con.cursor()
        sql="update student set name = '%s',age='%s' where rollno='%s'" %(name.get(),age.get(),rollno.get())
        cur.execute(sql)
        con.commit()
        con.close()
        messagebox.showinfo('success','Record updated...')
    except:
        messagebox.showinfo('Error', 'Error in dataentry')
    finally:
        clear()
def delete():
    try:
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')
        cur=con.cursor()
        sql="delete from student where rollno='%s'" %(rollno.get())
        cur.execute(sql)
        con.commit()
        con.close()
        messagebox.showinfo('success','Record deleted...')
    except:
        messagebox.showinfo('Error', 'Error in dataentry')
    finally:
        clear()
w1=Tk()
w1.title('My App')
w1.geometry('500x200')

ptitle=Label(w1,text='''Program to add, modify, delete the records from student table''')

ptitle.grid(row=0,column=0,columnspan=2)

rollno=StringVar()
name=StringVar()
age=StringVar()

l1=Label(w1,text=' RollNo ')
e1=Entry(w1, textvariable=rollno)
l2=Label(w1,text=' Name ')
e2=Entry(w1, textvariable=name)
l3=Label(w1,text=' Age ')
e3=Entry(w1, textvariable=age)

b1=Button(w1,text=' search ', command=search)
b2=Button(w1,text=' Add    ', command=add)
b3=Button(w1,text=' Update ', command=update)
b4=Button(w1,text=' Delete ', command=delete)
b5=Button(w1,text=' clear  ', command=clear)

l1.grid(row=1,column=0)
e1.grid(row=1,column=1)
b1.grid(row=1,column=2)

l2.grid(row=2,column=0)
e2.grid(row=2,column=1)

l3.grid(row=3,column=0)
e3.grid(row=3,column=1)

b2.grid(row=4,column=0)
b3.grid(row=4,column=1)
b4.grid(row=5,column=0)
b5.grid(row=5,column=1)
w1.mainloop()
Error:
Error :unable to detect undefined names created in spyder ide error at line 2 Error : Tk may be undefined or defined from star imports : tkinter
Reply
#2
Don't use star imports
https://python-forum.io/Thread-Namespace...th-imports
Reply
#3
<p>
<br />
import pymysql<br />
from tkinter import messagebox<br />
def search():<br />
    try:<br />
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')<br />
        cur=con.cursor()<br />
        sql="select * from student where rollnoo='%s'"%rollno.get()<br />
        cur.execute(sql)<br />
        result=cur.fetchone()<br />
        name.set(result[1])<br />
        age.set(result[2])<br />
        e1.configure(state='disabled')<br />
        con.close()<br />
    except:<br />
        messagebox.showinfo('No data avl')<br />
        clear()<br />
def clear():<br />
    rollno.set('')<br />
    name.set('')<br />
    age.set('')<br />
    e1.configure(state='normal')<br />
def add():<br />
    try:<br />
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')<br />
        cur=con.cursor()<br />
        sql="insert into student values('%s','%s','%s')"%(rollno.get(),name.get(),age.get())<br />
        cur.execute(sql)<br />
        con.commit()<br />
        con.close()<br />
        messagebox.showinfo('success','Record save...')<br />
    except:<br />
        messagebox.showinfo('Error', 'Error in dataentry')<br />
    finally:<br />
        clear()<br />
def update():<br />
    try:<br />
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')<br />
        cur=con.cursor()<br />
        sql="update student set name = '%s',age='%s' where rollno='%s'" %(name.get(),age.get(),rollno.get())<br />
        cur.execute(sql)<br />
        con.commit()<br />
        con.close()<br />
        messagebox.showinfo('success','Record updated...')<br />
    except:<br />
        messagebox.showinfo('Error', 'Error in dataentry')<br />
    finally:<br />
        clear()<br />
def delete():<br />
    try:<br />
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')<br />
        cur=con.cursor()<br />
        sql="delete from student where rollno='%s'" %(rollno.get())<br />
        cur.execute(sql)<br />
        con.commit()<br />
        con.close()<br />
        messagebox.showinfo('success','Record deleted...')<br />
    except:<br />
        messagebox.showinfo('Error', 'Error in dataentry')<br />
    finally:<br />
        clear()<br />
w1=Tk()<br />
w1.title('My App')<br />
w1.geometry('500x200')</p>

<p>ptitle=Label(w1,text='''Program to add, modify, delete the records from student table''')</p>

<p>ptitle.grid(row=0,column=0,columnspan=2)</p>

<p>rollno=StringVar()<br />
name=StringVar()<br />
age=StringVar()</p>

<p>l1=Label(w1,text=' RollNo ')<br />
e1=Entry(w1, textvariable=rollno)<br />
l2=Label(w1,text=' Name ')<br />
e2=Entry(w1, textvariable=name)<br />
l3=Label(w1,text=' Age ')<br />
e3=Entry(w1, textvariable=age)</p>

<p>b1=Button(w1,text=' search ', command=search)<br />
b2=Button(w1,text=' Add    ', command=add)<br />
b3=Button(w1,text=' Update ', command=update)<br />
b4=Button(w1,text=' Delete ', command=delete)<br />
b5=Button(w1,text=' clear  ', command=clear)</p>

<p>l1.grid(row=1,column=0)<br />
e1.grid(row=1,column=1)<br />
b1.grid(row=1,column=2)</p>

<p>l2.grid(row=2,column=0)<br />
e2.grid(row=2,column=1)</p>

<p>l3.grid(row=3,column=0)<br />
e3.grid(row=3,column=1)</p>

<p>b2.grid(row=4,column=0)<br />
b3.grid(row=4,column=1)<br />
b4.grid(row=5,column=0)<br />
b5.grid(row=5,column=1)<br />
w1.mainloop()        <br />
            <br />
<br />
Error:
<br /> runfile('D:/PYTHON/menu2.py', wdir='D:/PYTHON')<br /> Traceback (most recent call last):</p> <p>File "<ipython-input-4-f724e182f82d>", line 1, in <module><br /> runfile('D:/PYTHON/menu2.py', wdir='D:/PYTHON')</p> <p>File "C:UsersUserAnaconda3libsite-packagesspyder_kernelscustomizespydercustomize.py", line 786, in runfile<br /> execfile(filename, namespace)</p> <p>File "C:UsersUserAnaconda3libsite-packagesspyder_kernelscustomizespydercustomize.py", line 110, in execfile<br /> exec(compile(f.read(), filename, 'exec'), namespace)</p> <p>File "D:/PYTHON/menu2.py", line 61, in <module><br /> w1=Tk()</p> <p>NameError: name 'Tk' is not defined<br />
</p>
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Unable to understand the meaning of the line of code. jahuja73 0 270 Jan-23-2024, 05:09 AM
Last Post: jahuja73
  File "<string>", line 19, in <module> error is related to what? Frankduc 9 12,391 Mar-09-2023, 07:22 AM
Last Post: LocklearSusan
  undefined function error JonWayn 5 1,399 Sep-11-2022, 03:38 AM
Last Post: JonWayn
  Undefined Led_Zeppelin 4 1,367 Aug-02-2022, 11:57 AM
Last Post: buran
  Pandas - error when running Pycharm, but works on cmd line zxcv101 1 1,321 Jun-18-2022, 01:09 PM
Last Post: snippsat
  Line 42 syntax error..Help!!1 patpython 4 2,607 Sep-01-2021, 03:22 PM
Last Post: deanhystad
  pandas.errors.ParserError: Error tokenizing data. C error: Expected 9 fields in line Anldra12 9 15,084 Jun-15-2021, 08:16 AM
Last Post: Anldra12
  Error on open of file created with tempfile.TemporaryDirectory() Brian177 4 6,145 Apr-05-2021, 07:12 PM
Last Post: Brian177
  Syntax error on line 29 manwithjeans 3 2,771 Feb-27-2021, 08:28 AM
Last Post: perfringo
  ImportError: /home/pybind11_example.cpython-37m-x86_64-linux-gnu.so: undefined symbol chaitra 2 5,026 Feb-03-2021, 05:14 AM
Last Post: chaitra

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020