PYTHON & SQLITE3 & TKINTER SEASON 3

 

#users (name, age

import tkinter as tk

import sqlite3 as lite

def data_entry():

  sql = "INSERT INTO users (name,age)VALUES(?,?)"

  args = (name.get(),age.get())

  print(sql, args)

  cur.execute(sql, args)         

  dbms.commit()

  sql = "SELECT * FROM users"

  cur.execute(sql)

  rs = cur.fetchall()

  for i in rs:

     print(i)

  #cur.close()

  #dbms.close()

  

 

tk.X=tk.Tk()

name = tk.StringVar()

age = tk.StringVar()

dbms = lite.connect('example.db')

cur = dbms.cursor()

#sql = "CREATE TABLE IF NOT EXISTS users (customer_id INTEGER PRIMARY KEY,  customer TEXT, code TEXT);"

#cur.execute(sql)

tk.Entry(tk.X,textvariable=name).pack()

tk.Entry(tk.X,textvariable=age).pack()

tk.Button(tk.X, text="Save", command=data_entry).pack()

tk.X.mainloop()