def adda_data(self):
conn=mysql.connector.connect(host="localhost", username="root", password="Test@123", database="Mydata")
my_cursor=conn.cursor()
my_cursor.execute("insert into library values(%s, %s, %s, %s, %s, %s %s, %s, %s, %s, %s,%s,, %s, %s %s, %s, %s, %s,)",
(self.member_var.get(),
self.prn_var.get(),
self.id_var.get(),
self.firstname_var.get(),
self.lastname_var.get(),
self.address1_var.get(),
self.address2_var.get(),
self.postcode_var.get(),
self.mobile_var.get(),
self.bookid_var.get(),
self.booktitle_var.get(),
self.auther_var.get(),
self.dateborrowed_var.get(),
self.datedue_var.get(),
self.daysonbook.get(),
self.lateratefine_var.get(),
self.dateoverdue.get(),
self.finallprice.get()))
conn.commit()
conn.close()
Mohammad Sarfraj 