Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /// finaluri python fibonachi kompiqsebi
- def fibn(n):
- a, b = 0, 1
- for i in range(n):
- a, b = b, a+b
- return str(a)
- for i in range(1,10):
- print(fibn(i))
- ////////
- /////////////////////finaluri PYTHON
- # THIS IS PYTHONN !!!
- import mysql.connector
- from tkinter import *
- try:
- conn=mysql.connector.connect(user="root",password="",
- host="localhost",database="pythonTest")
- except Exception as ex:
- print(ex)
- else:
- root=Tk()
- root.title("my app")
- root.geometry("500x500")
- label_one=Label(root,text="saxeli: ")
- label_one.place(x="100",y="100")
- label_two=Label(root,text="gvari: ")
- label_two.place(x="100",y="120")
- label_three=Label(root,text="pm: ")
- label_three.place(x="100",y="140")
- label_four = Label(root, text="fetch: ",wraplength=255)
- label_four.place(x="20", y="280")
- input_one=Entry(root)
- input_one.place(x="150",y="100")
- input_two=Entry(root)
- input_two.place(x="150",y="120")
- input_three=Entry(root)
- input_three.place(x="150",y="140")
- def insert_records():
- mycursor=conn.cursor()
- sql="INSERT INTO python_user(fname,lname,pm)values(%s,%s,%s)"
- val=(input_one.get(),input_two.get(),input_three.get())
- mycursor.execute(sql,val)
- conn.commit()
- input_one.delete(0,'end')
- input_two.delete(0,'end')
- input_three.delete(0,'end')
- def fetch_records():
- mycursor1 = conn.cursor()
- mycursor1.execute("SELECT * FROM python_user")
- result = mycursor1.fetchall()
- for x in result :
- newText = (label_four.cget("text")+str(x)+" ")
- label_four.configure(text=newText)
- #insert_records()
- btn1=Button(root,text="shenaxva")
- btn1.place(x="180",y="180")
- btn1.bind("<Button-1>",lambda event:insert_records())
- #fetch_records()
- btn2 = Button(root,text="gamotana",fg="red",bg="white",activebackground="white",activeforeground="red")
- btn2.place(x="180", y="240")
- btn2.bind("<Button-1>", lambda event: fetch_records())
- root.mainloop()
- finally:
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement