Final MIT ADT mini project.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "import tkinter as tk\n",
    "from tkinter.ttk import *\n",
    "from tkinter import *\n",
    "import time\n",
    "import os\n",
    "from PIL import ImageTk, Image\n",
    "import random\n",
    "from datetime import date\n",
    "import datetime\n",
    "import smtplib\n",
    "from tkinter import messagebox\n",
    "import mysql.connector\n",
    "conn = mysql.connector.connect(user='root', password='rishabh@', host='127.0.0.1', database='mydatabase')\n",
    "cursor = conn.cursor()\n",
    "\n",
    "window = tk.Tk()\n",
    "window.state('zoomed')\n",
    "window.rowconfigure(0,weight=1)\n",
    "window.columnconfigure(0,weight=1)\n",
    "\n",
    "frame1 = tk.Frame(window)\n",
    "frame2 = tk.Frame(window)\n",
    "frame3 = tk.Frame(window)\n",
    "frame4 = tk.Frame(window)\n",
    "frame5 = tk.Frame(window)\n",
    "frame6 = tk.Frame(window)\n",
    "frame7 = tk.Frame(window)\n",
    "frame8 = tk.Frame(window)\n",
    "frame9 = tk.Frame(window)\n",
    "frame10 =tk.Frame(window)\n",
    "frame11=tk.Frame(window)\n",
    "frame12=tk.Frame(window)\n",
    "frame13=tk.Frame(window)\n",
    "frame14=tk.Frame(window)\n",
    "frame15=tk.Frame(window)\n",
    "frame16=tk.Frame(window)\n",
    "frame17=tk.Frame(window)\n",
    "frame18=tk.Frame(window)\n",
    "frame19=tk.Frame(window)\n",
    "frame20=tk.Frame(window)\n",
    "name_var=tk.StringVar() \n",
    "passw_var=tk.StringVar()\n",
    "newpass=tk.StringVar()\n",
    "rnewpass=tk.StringVar()\n",
    "otp=tk.StringVar()\n",
    "userid=tk.StringVar()\n",
    "bookid=tk.StringVar()\n",
    "for frame in (frame1,frame2,frame3,frame4,frame5,frame6,frame7,frame8,frame9,frame10,frame11,frame12,frame13,frame14,frame15,frame16,frame17,frame18,frame19,frame20):\n",
    "    frame.grid(row=0,column=0,sticky=\"nsew\")\n",
    "\n",
    "def payself():\n",
    "        name=name_var.get()\n",
    "        add1=0\n",
    "        add2=0\n",
    "        no=frame192_entry.get()\n",
    "        for i in range(0,16,2):\n",
    "            c1=int(no[i])*2\n",
    "            if c1>=10:\n",
    "                c1=c1-9\n",
    "            add1=add1+c1\n",
    "        for i in range(1,16,2):\n",
    "            add2=add2+int(no[i])\n",
    "        if (add1+add2)%10==0:\n",
    "            Update3=\"Update user set payfine='%s' where USER_ID='%s' \" %(0,name)\n",
    "            cursor.execute(Update3)\n",
    "            conn.commit()\n",
    "            messagebox.askokcancel(\"Information\",\"NO DUE\")\n",
    "        else:\n",
    "            messagebox.askokcancel(\"Information\",\"CARD NO WRONG\")\n",
    "        \n",
    "image19=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame5.jpg\")\n",
    "image19=image19.resize((1530,800),Image.ANTIALIAS)\n",
    "img19 = ImageTk.PhotoImage(image19)\n",
    "panel19 = tk.Label(frame19, image = img19)\n",
    "panel19.place(relx=0,rely=0)\n",
    "frame191_label=tk.Label(frame19,text=\"ENTER YOUR CARD NO\",width=20,height=2,bg=\"pink\")\n",
    "frame191_label.place(relx=0.5,rely=0.3)\n",
    "frame192_entry=tk.Entry(frame19,width=30,borderwidth=8)\n",
    "frame192_entry.place(relx=0.6,rely=0.3)\n",
    "frame193_button=tk.Button(frame19,text=\"CHECK AND PAY\",width=15,height=2,command=payself).place(relx=0.4,rely=0.5)\n",
    "back_button19=tk.Button(frame19,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame17))\n",
    "back_button19.place(relx=0.5,rely=0.5)\n",
    "\n",
    "def logout():\n",
    "    name_var.set(\"\")\n",
    "    passw_var.set(\"\")\n",
    "    show_frame(frame1)\n",
    "    \n",
    "    \n",
    "def pay():\n",
    "        user=frame162_entry.get()\n",
    "        Update3=\"Update user set payfine='%s' where USER_ID='%s' \" %(0,user)\n",
    "        cursor.execute(Update3)\n",
    "        conn.commit()\n",
    "        messagebox.askokcancel(\"Information\",\"no due\")\n",
    "def payfine():\n",
    "    user=frame162_entry.get()\n",
    "    cursor.execute(\"SELECT * from user WHERE USER_ID = '%s' \"%(user))\n",
    "    t=(cursor.fetchall())\n",
    "    if t==[]:\n",
    "        messagebox.askokcancel(\"Information\",\"No Record exists\")\n",
    "    else:\n",
    "        frame11_button=tk.Button(frame16,text=\"PAY\",width=10,height=2,command=pay).place(relx=0.45,rely=0.4)\n",
    "        frame111_label=tk.Label(frame16,text=\"DUE AMOUNT\",width=20,height=2,bg=\"pink\").place(relx=0.45,rely=0.2)\n",
    "        frame115_label=tk.Label(frame16,text=t[0][13],width=20,height=2,bg=\"pink\").place(relx=0.45,rely=0.3)\n",
    "        \n",
    "\n",
    "        \n",
    "image16=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame5.jpg\")\n",
    "image16=image16.resize((1530,800),Image.ANTIALIAS)\n",
    "img16 = ImageTk.PhotoImage(image16)\n",
    "panel16 = tk.Label(frame16, image = img16)\n",
    "panel16.place(relx=0,rely=0)\n",
    "frame161_label=tk.Label(frame16,text=\"USER_ID\",width=20,height=2,bg=\"pink\").place(relx=0.25,rely=0.2)\n",
    "frame162_entry=tk.Entry(frame16,width=20,borderwidth=10)\n",
    "frame162_entry.place(relx=0.25,rely=0.3)\n",
    "frame163_button=tk.Button(frame16,text=\"SHOW DUES\",width=10,height=2,command=payfine).place(relx=0.25,rely=0.4)\n",
    "back_button16=tk.Button(frame16,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button16.place(relx=0.5,rely=0.5)\n",
    "\n",
    "def renew():\n",
    "    today = date.today()\n",
    "    returndate = today + datetime.timedelta(days = 15)\n",
    "    book=bookid.get()\n",
    "    cursor.execute(\"SELECT * from user WHERE BOOK1 = '%s' \"%(book))\n",
    "    t=(cursor.fetchall())\n",
    "    if  t==[]:\n",
    "        cursor.execute(\"SELECT * from user WHERE BOOK2 = '%s' \"%(book))\n",
    "        t=(cursor.fetchall())\n",
    "        diff=(today-t[0][12]).days\n",
    "        if diff>0:\n",
    "            Update3=\"Update user set DOI2='%s', DOR2='%s',payfine='%s' where BOOK2='%s' \" %(today,returndate,t[0][13]+diff*5,book)\n",
    "            cursor.execute(Update3)\n",
    "            conn.commit()\n",
    "            messagebox.askokcancel(\"Information\",\"you have reissued 2nd book\")\n",
    "    else:\n",
    "        diff=(today-t[0][9]).days\n",
    "        if diff>0:\n",
    "            Update3=\"Update user set DOI1='%s', DOR1='%s',payfine='%s' where BOOK1='%s' \" %(today,returndate,t[0][13]+diff*5,book)\n",
    "            cursor.execute(Update3)\n",
    "            conn.commit()\n",
    "            messagebox.askokcancel(\"Information\",\"you have reissued 1st book\")\n",
    "\n",
    "image15=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame3.jpg\")\n",
    "image15=image15.resize((1530,800),Image.ANTIALIAS)\n",
    "img15 = ImageTk.PhotoImage(image15)\n",
    "panel15 = tk.Label(frame15, image = img15)\n",
    "panel15.place(relx=0,rely=0)\n",
    "frame151_label=tk.Label(frame15,text=\"BOOK_ID\").place(relx=0.25,rely=0.2)\n",
    "frame152_entry=tk.Entry(frame15,textvariable=bookid).place(relx=0.45,rely=0.2)\n",
    "\n",
    "frame153_buttom=tk.Button(frame15,text=\"RENEW\",command=renew).place(relx=0.35,rely=0.3)\n",
    "back_button15=tk.Button(frame15,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button15.place(relx=0.5,rely=0.5)\n",
    "\n",
    "def returnbook():\n",
    "    today = date.today()\n",
    "    book=bookid.get()\n",
    "    cursor.execute(\"SELECT * from book_details WHERE BOOK_ID = '%s' \"%(book))\n",
    "    v=(cursor.fetchall())\n",
    "    if v==[]:\n",
    "        frame144_label.config(text=\"Wrong BOOK_ID\")\n",
    "    else:\n",
    "        if v[0][6]==bool(1):\n",
    "            Update=\"Update book_details set STATUS='%s' where BOOK_ID='%s'\" %(0,book)\n",
    "            cursor.execute(Update)\n",
    "            conn.commit()\n",
    "            cursor.execute(\"SELECT * from user WHERE BOOK1 = '%s' \"%(book))\n",
    "            t=(cursor.fetchall())\n",
    "            \n",
    "            if t==[]:\n",
    "                cursor.execute(\"SELECT * from user WHERE BOOK2 = '%s' \"%(book))\n",
    "                t=(cursor.fetchall())\n",
    "                diff=(today-t[0][12]).days\n",
    "                Update2=\"Update user set BOOK2='%s',no_all_book='%s' where USER_ID='%s'\" %('0000',t[0][14]-1,t[0][0])\n",
    "                cursor.execute(Update2)\n",
    "                conn.commit()\n",
    "                messagebox.showinfo(\"Information\",\"FIRST BOOK RETURNED\")\n",
    "                if diff>0:\n",
    "                    Update3=\"Update user set payfine='%s' where USER_ID='%s' \" %(t[0][13]+diff*5,t[0][0])\n",
    "                    cursor.execute(Update3)\n",
    "                    conn.commit()\n",
    "                    messagebox.showinfo(\"Information\",\"FIRST BOOK RETURNED\")\n",
    "                    \n",
    "                \n",
    "            else:\n",
    "                diff=(today-t[0][9]).days\n",
    "                Update2=\"Update user set BOOK1='%s',no_all_book='%s' where USER_ID='%s'\" %('0000',t[0][14]-1,t[0][0])\n",
    "                cursor.execute(Update2)\n",
    "                conn.commit()\n",
    "                messagebox.showinfo(\"Information\",\"SECOND BOOK RETURNED\")\n",
    "                if diff>0:\n",
    "                    Update3=\"Update user set payfine='%s' where USER_ID='%s' \" %(t[0][13]+diff*5,t[0][0])\n",
    "                    cursor.execute(Update3)\n",
    "                    conn.commit()\n",
    "                    messagebox.showinfo(\"Information\",\"SECOND BOOK RETURNED\")\n",
    "                \n",
    "                \n",
    "\n",
    "                \n",
    "image14=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame3.jpg\")\n",
    "image14=image14.resize((1530,800),Image.ANTIALIAS)\n",
    "img14 = ImageTk.PhotoImage(image14)\n",
    "panel14 = tk.Label(frame14, image = img14)\n",
    "panel14.place(relx=0,rely=0)\n",
    "frame141_label=tk.Label(frame14,text=\"BOOK_ID\").place(relx=0.25,rely=0.2)\n",
    "frame142_entry=tk.Entry(frame14,textvariable=bookid).place(relx=0.45,rely=0.2)\n",
    "frame143_button=tk.Button(frame14,text=\"RETURN\",command=returnbook).place(relx=0.35,rely=0.3)\n",
    "frame144_label=tk.Label(frame14,text=\"\")\n",
    "frame144_label.place(relx=0.55,rely=0.4)\n",
    "back_button145=tk.Button(frame14,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button145.place(relx=0.5,rely=0.5)\n",
    "\n",
    "def data():\n",
    "    name=name_var.get()\n",
    "    show_frame(frame20)\n",
    "    cursor.execute(\"SELECT * from user WHERE USER_ID = '%s' \"%(name))\n",
    "    t=(cursor.fetchall())\n",
    "    frame20name_label.config(text=t[0][2])\n",
    "    frame20user_label.config(text=t[0][0])\n",
    "    frame20status_label.config(text=t[0][5])\n",
    "    frame20email_label.config(text=t[0][4])\n",
    "    frame20mob_label.config(text=t[0][1])\n",
    "    frame20due_label.config(text=t[0][13])\n",
    "    if t[0][7]== '0000':\n",
    "        frame20book1_label.config(text=\"None\\t\\t\\tNone\\t\\t\\tNone\\t\\tnone\")\n",
    "    else:\n",
    "        cursor.execute(\"SELECT * from book_details WHERE BOOK_ID = '%s' \"%(t[0][7]))\n",
    "        v=(cursor.fetchall())\n",
    "        frame20book1_label.config(text=str(t[0][7])+\"\\t\\t\\t \"+v[0][1]+'\\t\\t\\t  '+str(t[0][8])+'\\t\\t'+str(t[0][9]))\n",
    "    if t[0][10]== '0000':\n",
    "        frame20book2_label.config(text=\"None\\t\\t\\tNone\\t\\t\\tNone\\t\\tnone\")\n",
    "    else:\n",
    "        cursor.execute(\"SELECT * from book_details WHERE BOOK_ID = '%s' \"%(t[0][10]))\n",
    "        v=(cursor.fetchall())\n",
    "        frame20book2_label.config(text=str(t[0][10])+'\\t\\t\\t'+v[0][1]+'\\t\\t\\t  '+str(t[0][11])+'\\t\\t'+str(t[0][12]))\n",
    "\n",
    "\n",
    "\n",
    "def issue(): \n",
    "    user=userid.get() \n",
    "    book=bookid.get()\n",
    "    cursor.execute(\"SELECT * from user WHERE USER_ID = '%s' \"%(user))\n",
    "    t=(cursor.fetchall())\n",
    "    cursor.execute(\"SELECT * from book_details WHERE BOOK_ID = '%s' \"%(book))\n",
    "    v=(cursor.fetchall())\n",
    "    if t[0][14]<2:\n",
    "        if v[0][6]==bool(0):\n",
    "            Update=\"Update book_details set STATUS='%s' where BOOK_ID='%s'\" %(1,book)\n",
    "            cursor.execute(Update)\n",
    "            conn.commit()\n",
    "            today = date.today()\n",
    "            returndate = today + datetime.timedelta(days = 15)\n",
    "            if  t[0][7]==\"0000\":\n",
    "                update2=\"Update user set BOOK1='%s',DOI1='%s',DOR1='%s',no_all_book='%s' where USER_ID='%s'\" %(book,str(today),(returndate),1,user)\n",
    "            elif t[0][10]==\"0000\":\n",
    "                update2=\"Update user set BOOK2='%s',DOI2='%s',DOR2='%s',no_all_book='%s' where USER_ID='%s'\" %(book,str(today),str(returndate),2,user)\n",
    "            cursor.execute(update2)\n",
    "            conn.commit()\n",
    "            frame135_label.config(text=\"Book Issued\")\n",
    "        else:\n",
    "            messagebox.askokcancel(\"Information\",\"This book is already issued to someone! \")\n",
    "            \n",
    "    else:\n",
    "        messagebox.askokcancel(\"Information\",\"sorry already 2 book issued\")\n",
    "\n",
    "        \n",
    "        \n",
    "image13=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame5.jpg\")\n",
    "image13=image13.resize((1530,800),Image.ANTIALIAS)\n",
    "img13 = ImageTk.PhotoImage(image13)\n",
    "panel13 = tk.Label(frame13, image = img13)\n",
    "panel13.place(relx=0,rely=0)\n",
    "frame131_label=tk.Label(frame13,text=\"USER_ID\").place(relx=0.35,rely=0.1)\n",
    "frame132_label=tk.Label(frame13,text=\"BOOK_ID\").place(relx=0.35,rely=0.2)\n",
    "frame133_entry=tk.Entry(frame13,textvariable=userid).place(relx=0.55,rely=0.1)\n",
    "frame134_entry=tk.Entry(frame13,textvariable=bookid).place(relx=0.55,rely=0.2)\n",
    "frame135_label=tk.Label(frame13,text=\"\")\n",
    "frame135_label.place(relx=0.4,rely=0.4)\n",
    "frame136_buttom=tk.Button(frame13,text=\"ISSUE\",command=issue).place(relx=0.45,rely=0.3)\n",
    "back_button137=tk.Button(frame13,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button137.place(relx=0.5,rely=0.5)\n",
    "\n",
    "def ShowRecord():\n",
    "    frame111_label=tk.Label(frame11,text=\"TITLE\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.3)\n",
    "    frame112_label=tk.Label(frame11,text=\"AUTHOR\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.4)\n",
    "    frame113_label=tk.Label(frame11,text=\"EDITION\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.5)\n",
    "    frame114_label=tk.Label(frame11,text=\"PRICE\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.6)\n",
    "    \n",
    "\n",
    "    BOOK_ID=frame111_entry.get()\n",
    "    dbBOOK_ID=\"\"\n",
    "    Select=\"select BOOK_ID from book_details where BOOK_ID='%s'\" %(BOOK_ID)\n",
    "    cursor.execute(Select)\n",
    "    result1=cursor.fetchall()\n",
    "    for i in result1:\n",
    "        dbBOOK_ID=i[0]\n",
    "    Select1=\"select TITLE,AUTHOR,EDITION,PRICE from book_details where BOOK_ID='%s'\" %(BOOK_ID)\n",
    "    cursor.execute(Select1)\n",
    "    result2=cursor.fetchall()\n",
    "    TITLE=\"\"\n",
    "    AUTHOR=\"\"\n",
    "    EDITION=\"\"\n",
    "    PRICE=\"\"\n",
    "    if(int(BOOK_ID) == dbBOOK_ID):\n",
    "        for i in result2:\n",
    "            TITLE=i[0]\n",
    "            AUTHOR=i[1]\n",
    "            EDITION=i[2]\n",
    "            PRICE=i[3]\n",
    "        frame115_label=tk.Label(frame11,text=TITLE,width=20,height=2,bg=\"pink\").place(relx=0.46,rely=0.3)\n",
    "        frame117_label=tk.Label(frame11,text=AUTHOR,width=20,height=2,bg=\"pink\").place(relx=0.46,rely=0.4)\n",
    "        frame118_label=tk.Label(frame11,text=EDITION,width=20,height=2,bg=\"pink\").place(relx=0.46,rely=0.5)\n",
    "        frame119_label=tk.Label(frame11,text=PRICE,width=20,height=2,bg=\"pink\").place(relx=0.46,rely=0.6)\n",
    "        \n",
    "        \n",
    "    else:\n",
    "        messagebox.askokcancel(\"Information\",\"No Record exists\")\n",
    "\n",
    "def Updatel():\n",
    "    frame121_label=tk.Label(frame12,text=\"BOOK_ID\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.2)\n",
    "    frame122_label=tk.Label(frame12,text=\"TITLE\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.3)\n",
    "    frame123_label=tk.Label(frame12,text=\"AUTHOR\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.4)\n",
    "    frame124_label=tk.Label(frame12,text=\"EDITION\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.5)\n",
    "    frame125_label=tk.Label(frame12,text=\"PRICE\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.6)\n",
    "    BOOK_ID=frame128_entry.get()\n",
    "    TITLE=frame129_entry.get()\n",
    "    AUTHOR=frame1210_entry.get()\n",
    "    EDITION=frame1211_entry.get()\n",
    "    PRICE=frame1212_entry.get()\n",
    "    Update=\"Update book_details set TITLE='%s', AUTHOR='%s', EDITION='%s', PRICE='%s' where BOOK_ID='%s'\" %(TITLE,AUTHOR,EDITION,PRICE,BOOK_ID)\n",
    "    cursor.execute(Update)\n",
    "    conn.commit()\n",
    "    messagebox.showinfo(\"Info\",\"RECORD UPDATED\")\n",
    "\n",
    "\n",
    "image12=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame4.jpg\")\n",
    "image12=image12.resize((1530,800),Image.ANTIALIAS)\n",
    "img12 = ImageTk.PhotoImage(image12)\n",
    "panel12 = tk.Label(frame12, image = img12)\n",
    "panel12.place(relx=0,rely=0)\n",
    "frame121_label=tk.Label(frame12,text=\"BOOK_ID\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.2)\n",
    "frame122_label=tk.Label(frame12,text=\"TITLE\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.3)\n",
    "frame123_label=tk.Label(frame12,text=\"AUTHOR\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.4)\n",
    "frame124_label=tk.Label(frame12,text=\"EDITION\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.5)\n",
    "frame125_label=tk.Label(frame12,text=\"PRICE\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.6)\n",
    "frame128_entry=tk.Entry(frame12,width=30,borderwidth=8)\n",
    "frame128_entry.place(relx=0.55,rely=0.2)\n",
    "frame129_entry=tk.Entry(frame12,width=30,borderwidth=8)\n",
    "frame129_entry.place(relx=0.55,rely=0.3)\n",
    "frame1210_entry=tk.Entry(frame12,width=30,borderwidth=8)\n",
    "frame1210_entry.place(relx=0.55,rely=0.4)\n",
    "frame1211_entry=tk.Entry(frame12,width=30,borderwidth=8)\n",
    "frame1211_entry.place(relx=0.55,rely=0.5)\n",
    "frame1212_entry=tk.Entry(frame12,width=30,borderwidth=8)\n",
    "frame1212_entry.place(relx=0.55,rely=0.6)\n",
    "frame1214_button=tk.Button(frame12,text=\"UPDATE\",width=10,height=2,command=Updatel).place(relx=0.47,rely=0.7)\n",
    "   \n",
    "back_button1241=tk.Button(frame12,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame11))\n",
    "back_button1241.place(relx=0.48,rely=0.8)\n",
    "\n",
    "\n",
    "image11=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame3.jpg\")\n",
    "image11=image11.resize((1530,800),Image.ANTIALIAS)\n",
    "img11 = ImageTk.PhotoImage(image11)\n",
    "panel11 = tk.Label(frame11, image = img11)\n",
    "panel11.place(relx=0,rely=0)\n",
    "frame1110_label=tk.Label(frame11,text=\"BOOK_ID\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.2)\n",
    "frame111_entry=tk.Entry(frame11,width=30,borderwidth=20)\n",
    "frame111_entry.place(relx=0.45,rely=0.2)\n",
    "frame1111_button=tk.Button(frame11,text=\"SHOW\",width=10,height=2,command=ShowRecord).place(relx=0.7,rely=0.25)\n",
    "frmae1112_button=tk.Button(frame11,text=\"EDIT BOOK\",width=10,height=2,command=lambda:show_frame(frame12)).place(relx=0.7,rely=0.35)\n",
    "back_button1141=tk.Button(frame11,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button1141.place(relx=0.6,rely=0.6)\n",
    "\n",
    "def Showlist():\n",
    "    frame111_label=tk.Label(frame18,text=\"TITLE\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.3)\n",
    "    frame112_label=tk.Label(frame18,text=\"AUTHOR\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.4)\n",
    "    frame113_label=tk.Label(frame18,text=\"EDITION\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.5)\n",
    "    frame114_label=tk.Label(frame18,text=\"PRICE\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.6)\n",
    "    \n",
    "\n",
    "    BOOK_ID=frame181_entry.get()\n",
    "    dbBOOK_ID=\"\"\n",
    "    Select=\"select BOOK_ID from book_details where BOOK_ID='%s'\" %(BOOK_ID)\n",
    "    cursor.execute(Select)\n",
    "    result1=cursor.fetchall()\n",
    "    for i in result1:\n",
    "        dbBOOK_ID=i[0]\n",
    "    Select1=\"select TITLE,AUTHOR,EDITION,PRICE from book_details where BOOK_ID='%s'\" %(BOOK_ID)\n",
    "    cursor.execute(Select1)\n",
    "    result2=cursor.fetchall()\n",
    "    TITLE=\"\"\n",
    "    AUTHOR=\"\"\n",
    "    EDITION=\"\"\n",
    "    PRICE=\"\"\n",
    "    if(int(BOOK_ID) == dbBOOK_ID):\n",
    "        for i in result2:\n",
    "            TITLE=i[0]\n",
    "            AUTHOR=i[1]\n",
    "            EDITION=i[2]\n",
    "            PRICE=i[3]\n",
    "        frame115_label=tk.Label(frame18,text=TITLE,width=20,height=2,bg=\"pink\").place(relx=0.46,rely=0.3)\n",
    "        frame117_label=tk.Label(frame18,text=AUTHOR,width=20,height=2,bg=\"pink\").place(relx=0.46,rely=0.4)\n",
    "        frame118_label=tk.Label(frame18,text=EDITION,width=20,height=2,bg=\"pink\").place(relx=0.46,rely=0.5)\n",
    "        frame119_label=tk.Label(frame18,text=PRICE,width=20,height=2,bg=\"pink\").place(relx=0.46,rely=0.6)\n",
    "        \n",
    "        \n",
    "    else:\n",
    "        messagebox.askokcancel(\"Information\",\"No Record exists\")\n",
    "        \n",
    "image18=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame3.jpg\")\n",
    "image18=image18.resize((1530,800),Image.ANTIALIAS)\n",
    "img18 = ImageTk.PhotoImage(image18)\n",
    "panel18 = tk.Label(frame18, image = img18)\n",
    "panel18.place(relx=0,rely=0)\n",
    "frame1810_label=tk.Label(frame18,text=\"BOOK_ID\",width=15,height=2,bg=\"pink\").place(relx=0.31,rely=0.2)\n",
    "frame181_entry=tk.Entry(frame18,width=30,borderwidth=20)\n",
    "frame181_entry.place(relx=0.45,rely=0.2)\n",
    "frame1811_button=tk.Button(frame18,text=\"SHOW\",width=10,height=2,command=Showlist).place(relx=0.7,rely=0.25)\n",
    "back_button1841=tk.Button(frame18,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame17))\n",
    "back_button1841.place(relx=0.6,rely=0.6)\n",
    "\n",
    "def forgot(): \n",
    "    username=name_var.get()  \n",
    "    cursor.execute(\"SELECT * from user WHERE USER_ID = '%s' \"%(username))\n",
    "    t=(cursor.fetchall())\n",
    "    try:\n",
    "        if t[0][0]!='\\0':\n",
    "            OTP = random.randint(100000,999999)\n",
    "            s=smtplib.SMTP('smtp.gmail.com',587)\n",
    "            s.starttls()\n",
    "            s.login(\"rishabhluharuka@gmail.com\",\"Monster@95\")\n",
    "            s.sendmail(\"rishabhluharuka@gmail.com\",t[0][4],str(OTP))\n",
    "            s.quit()\n",
    "            Update=\"Update user set OTP='%d' where USER_ID='%s'\" %(OTP,username)\n",
    "            cursor.execute(Update)\n",
    "            conn.commit()\n",
    "            frame13_label.config(text=\"USERNAME found\")\n",
    "            show_frame(frame9)\n",
    "    except IndexError:\n",
    "        frame13_label.config(text=\"USERNAME not found\")\n",
    "\n",
    "def otp_verification():\n",
    "    username=name_var.get()\n",
    "    OTP=otp.get()\n",
    "    \n",
    "    cursor.execute(\"SELECT * from user WHERE USER_ID = '%s' \"%(username))\n",
    "    t=(cursor.fetchall())\n",
    "    if t[0][6]==int(OTP):\n",
    "        show_frame(frame10)\n",
    "    else:\n",
    "        frame93_label.config(text=\"OTP wrong\")\n",
    "        \n",
    "\n",
    "image9=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame5.jpg\")\n",
    "image9=image9.resize((1530,800),Image.ANTIALIAS)\n",
    "img9 = ImageTk.PhotoImage(image9)\n",
    "panel9 = tk.Label(frame9, image = img9)\n",
    "panel9.place(relx=0,rely=0)\n",
    "frame9_title=tk.Label(frame9,text='LIBRARY MANAGEMENT SYSTEM',bg='red',font=20)\n",
    "frame9_title.pack(fill='x')\n",
    "frame9_upper_title=tk.Label(frame9,text=\"OTP is sent to your email\").place(relx=0.3,rely=0.1)\n",
    "frame91_label=tk.Label(frame9,text=\"OTP\",font=20)\n",
    "frame91_label.place(relx=0.3,rely=0.2)\n",
    "frame91_entry=tk.Entry(frame9,textvariable=otp)\n",
    "frame91_entry.place(relx=0.5,rely=0.2)\n",
    "frame93_label=tk.Label(frame9,text=\"\",font=20)\n",
    "frame93_label.place(relx=0.45,rely=0.7)\n",
    "frame91_btn1 = tk.Button(frame9,text='SUBMIT',command=otp_verification)\n",
    "frame91_btn1.place(relx=0.5,rely=0.5)\n",
    "frame92_btn2=tk.Button(frame9,text='BACK',command=lambda:show_frame(frame1))\n",
    "\n",
    "def replace_password():\n",
    "    username=name_var.get()\n",
    "    new=newpass.get()\n",
    "    rnew=rnewpass.get()\n",
    "    if new==rnew:\n",
    "        Update=\"Update user set PASSWORD='%s' where USER_ID='%s'\" %(new,username)\n",
    "        cursor.execute(Update)\n",
    "        conn.commit()\n",
    "        frame103_label.config(text=\"PASSWORD reset successfully\")\n",
    "    else:\n",
    "        frame103_label.config(text='Please enter same password')\n",
    "\n",
    "\n",
    "        \n",
    "image10=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame4.jpg\")\n",
    "image10=image10.resize((1530,800),Image.ANTIALIAS)\n",
    "img10 = ImageTk.PhotoImage(image10)\n",
    "panel10 = tk.Label(frame10, image = img10)\n",
    "panel10.place(relx=0,rely=0)        \n",
    "frame10_title=tk.Label(frame10,text='LIBRARY MANAGEMENT SYSTEM',bg='red',font=20)\n",
    "frame10_title.pack(fill='x')\n",
    "frame101_label=tk.Label(frame10,text=\"NEW PASSWORD\",font=20)\n",
    "frame101_label.place(relx=0.3,rely=0.2)\n",
    "\n",
    "frame102_label=tk.Label(frame10,text=\"RE-ENTER NEW PASSWORD\",font=20)\n",
    "frame102_label.place(relx=0.3,rely=0.3)\n",
    "\n",
    "frame101_entry=tk.Entry(frame10,textvariable=newpass,show='*')\n",
    "frame101_entry.place(relx=0.5,rely=0.2)\n",
    "\n",
    "frame102_entry=tk.Entry(frame10,textvariable=rnewpass,show='*')\n",
    "frame102_entry.place(relx=0.5,rely=0.3)\n",
    "\n",
    "frame103_label=tk.Label(frame10,text=\"\",font=20)\n",
    "frame103_label.place(relx=0.45,rely=0.5)\n",
    "frame101_btn1 = tk.Button(frame10,text='SAVE',command=replace_password)\n",
    "frame101_btn1.place(relx=0.5,rely=0.4)\n",
    "frame104_btn2=tk.Button(frame10,text='EXIT',command=lambda:show_frame(frame1)).place(relx=0.5,rely=0.6)\n",
    "\n",
    "\n",
    "image7=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame4.jpg\")\n",
    "image7=image7.resize((1530,800),Image.ANTIALIAS)\n",
    "img7 = ImageTk.PhotoImage(image7)\n",
    "panel7 = tk.Label(frame7, image = img7)\n",
    "panel7.place(relx=0,rely=0)\n",
    "frame71_label=tk.Label(frame7,text=\"BOOK_ID\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.2)\n",
    "frame72_label=tk.Label(frame7,text=\"TITLE\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.3)\n",
    "frame73_label=tk.Label(frame7,text=\"AUTHOR\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.4)\n",
    "frame74_label=tk.Label(frame7,text=\"EDITION\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.5)\n",
    "frame75_label=tk.Label(frame7,text=\"PRICE\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.6)\n",
    "frame76_label=tk.Label(frame7,text=\"PIECES\",width=20,height=2,bg=\"pink\").place(relx=0.35,rely=0.7)\n",
    "\n",
    "\n",
    "frame78_entry=tk.Entry(frame7,width=30,borderwidth=8)\n",
    "frame78_entry.place(relx=0.55,rely=0.2)\n",
    "frame79_entry=tk.Entry(frame7,width=30,borderwidth=8)\n",
    "frame79_entry.place(relx=0.55,rely=0.3)\n",
    "frame710_entry=tk.Entry(frame7,width=30,borderwidth=8)\n",
    "frame710_entry.place(relx=0.55,rely=0.4)\n",
    "frame711_entry=tk.Entry(frame7,width=30,borderwidth=8)\n",
    "frame711_entry.place(relx=0.55,rely=0.5)\n",
    "frame712_entry=tk.Entry(frame7,width=30,borderwidth=8)\n",
    "frame712_entry.place(relx=0.55,rely=0.6)\n",
    "frame713_entry=tk.Entry(frame7,width=30,borderwidth=8)\n",
    "frame713_entry.place(relx=0.55,rely=0.7)\n",
    "\n",
    "def Update():\n",
    "    BOOK_ID=frame78_entry.get()\n",
    "    TITLE=frame79_entry.get()\n",
    "    AUTHOR=frame710_entry.get()\n",
    "    EDITION=frame711_entry.get()\n",
    "    PRICE=frame712_entry.get()\n",
    "    PIECES=frame713_entry.get()\n",
    "    Update=\"Update book_details set TITLE='%s', AUTHOR='%s', EDITION='%s', PRICE='%s', PIECES='%s' where BOOK_ID='%s'\" %(TITLE,AUTHOR,EDITION,PRICE,PIECES,BOOK_ID)\n",
    "    cursor.execute(Update)\n",
    "    conn.commit()\n",
    "    messagebox.showinfo(\"Info\",\"Record Update\")\n",
    "\n",
    "frame714_button=tk.Button(frame7,text=\"UPDATE\",width=10,height=2,command=Update).place(relx=0.5,rely=0.8)\n",
    "back_button71=tk.Button(frame7,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button71.place(relx=0.51,rely=0.9)\n",
    "\n",
    "def Showall():\n",
    "    class A(Frame):\n",
    "        def __init__(self, parent):\n",
    "            Frame.__init__(self, parent)\n",
    "            self.CreateUI()\n",
    "            self.LoadTable()\n",
    "            self.grid(sticky=(N, S, W, E))\n",
    "            parent.grid_rowconfigure(0, weight=1)\n",
    "            parent.grid_columnconfigure(0, weight=1)\n",
    "        def CreateUI(self):\n",
    "            tv= Treeview(self)\n",
    "            tv['columns']=('BOOK_ID', 'TITLE', 'AUTHOR', 'EDITION', 'PRICE', 'PIECES','STATUS')\n",
    "            tv.heading('#0',text='BOOK_ID',anchor='center')\n",
    "            tv.column('#0',anchor='center')\n",
    "            tv.heading('#1', text='TITLE', anchor='center')\n",
    "            tv.column('#1', anchor='center')\n",
    "            tv.heading('#2', text='AUTHOR', anchor='center')\n",
    "            tv.column('#2', anchor='center')\n",
    "            tv.heading('#3', text='EDITION', anchor='center')\n",
    "            tv.column('#3', anchor='center')\n",
    "            tv.heading('#4', text='PRICE', anchor='center')\n",
    "            tv.column('#4', anchor='center')\n",
    "            tv.heading('#5', text='PIECES', anchor='center')\n",
    "            tv.column('#5', anchor='center')\n",
    "            tv.heading('#6', text='ISSUED', anchor='center')\n",
    "            tv.column('#6', anchor='center')\n",
    "            tv.grid(sticky=(N,S,W,E))\n",
    "            self.treeview = tv\n",
    "            self.grid_rowconfigure(0,weight=1)\n",
    "            self.grid_columnconfigure(0,weight=1)\n",
    "        def LoadTable(self):\n",
    "            Select=\"Select * from book_details\"\n",
    "            cursor.execute(Select)\n",
    "            result=cursor.fetchall()\n",
    "            BOOK_ID=\"\"\n",
    "            TITLE=\"\"\n",
    "            AUTHOR=\"\"\n",
    "            EDITION=\"\"\n",
    "            PRICE=\"\"\n",
    "            PIECES=\"\"\n",
    "            STATUS=\"\"\n",
    "            for i in result:\n",
    "                BOOK_ID=i[0]\n",
    "                TITLE=i[1]\n",
    "                AUTHOR=i[2]\n",
    "                EDITION=i[3]\n",
    "                PRICE=i[4]\n",
    "                PIECES=i[5]\n",
    "                STATUS=i[6]\n",
    "                self.treeview.insert(\"\",'end',text=BOOK_ID,values=(TITLE,AUTHOR,EDITION,PRICE,PIECES,STATUS))\n",
    "    frame6=Tk()\n",
    "    frame6.title(\"Overview Page\")\n",
    "    A(frame6)\n",
    "\n",
    "frame61_button5=Button(frame6,text=\"BOOK RECORD\",width=10,height=2,command=Showall).grid(row=7,column=7)\n",
    "back_button61=tk.Button(frame6,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button61.place(relx=0.5,rely=0.5)\n",
    "\n",
    "def Delete():\n",
    "    BOOK_ID=frame51_entry.get()\n",
    "    Delete=\"delete from book_details where BOOK_ID='%s'\" %(BOOK_ID)\n",
    "    cursor.execute(Delete)\n",
    "    conn.commit()\n",
    "    messagebox.showinfo(\"Information\",\"Record Deleted\")\n",
    "    frame51_entry.delete(0,END)\n",
    "\n",
    "def Register():\n",
    "    BOOK_ID=frame41_entry.get()\n",
    "    Select=\"select BOOK_ID from book_details where BOOK_ID='%s'\" %(BOOK_ID)\n",
    "    cursor.execute(Select)\n",
    "    result=cursor.fetchall()\n",
    "    if result!=[]:\n",
    "        messagebox.askokcancel(\"Information\",\"Record Already exists\")\n",
    "    else:\n",
    "        Insert=\"Insert into book_details(BOOK_ID,TITLE,AUTHOR,EDITION,PRICE,STATUS) values(%s,%s,%s,%s,%s,0)\"\n",
    "        TITLE=frame42_entry.get()\n",
    "        AUTHOR=frame43_entry.get()\n",
    "        EDITION=frame44_entry.get()\n",
    "        PRICE=frame45_entry.get()\n",
    "        \n",
    "        if(TITLE !=\"\" and AUTHOR !=\"\" and EDITION !=\"\" and PRICE !=\"\" ):\n",
    "            Value=(BOOK_ID,TITLE,AUTHOR,EDITION,PRICE)\n",
    "            cursor.execute(Insert,Value)\n",
    "            conn.commit()\n",
    "            messagebox.askokcancel(\"Information\",\"Record inserted\")\n",
    "            frame41_entry.delete(0, END)\n",
    "            frame42_entry.delete(0, END)\n",
    "            frame43_entry.delete(0, END)\n",
    "            frame44_entry.delete(0, END)\n",
    "            frame45_entry.delete(0, END)\n",
    "        else:\n",
    "            if (TITLE == \"\" and AUTHOR == \"\" and EDITION == \"\" and PRICE == \"\"  ):\n",
    "                messagebox.askokcancel(\"Information\",\"New Entery Fill All Details\")\n",
    "            else:\n",
    "                messagebox.askokcancel(\"Information\", \"Some fields left blank\")\n",
    "        \n",
    "\n",
    "def show_frame(frame):\n",
    "    frame.tkraise()\n",
    "\n",
    "    \n",
    "def login(): \n",
    "  \n",
    "    name=name_var.get() \n",
    "    password=passw_var.get()\n",
    "    \n",
    "    \n",
    "    cursor.execute(\"SELECT * from user WHERE USER_ID = '%s' \"%(name))\n",
    "    t=(cursor.fetchall())\n",
    "    \n",
    "    \n",
    "    try:\n",
    "        if t[0][3]==password:\n",
    "            frame13_label.config(text=\"Successfull\")\n",
    "            if t[0][5]=='Admin':\n",
    "                show_frame(frame2)\n",
    "            elif t[0][5]=='Student':\n",
    "                show_frame(frame17)\n",
    "                frame17name_label.config(text=t[0][2])\n",
    "                frame17user_label.config(text=t[0][0])\n",
    "                frame17status_label.config(text=t[0][5])\n",
    "                frame17email_label.config(text=t[0][4])\n",
    "                frame17mob_label.config(text=t[0][1])\n",
    "                frame17due_label.config(text=t[0][13])\n",
    "                if t[0][7]== '0000':\n",
    "                    frame17book1_label.config(text=\"None\\t\\t\\tNone\\t\\t\\tNone\\t\\tnone\")\n",
    "                else:\n",
    "                    cursor.execute(\"SELECT * from book_details WHERE BOOK_ID = '%s' \"%(t[0][7]))\n",
    "                    v=(cursor.fetchall())\n",
    "                    frame17book1_label.config(text=str(t[0][7])+\"\\t\\t\\t \"+v[0][1]+'\\t\\t\\t  '+str(t[0][8])+'\\t\\t'+str(t[0][9]))\n",
    "                if t[0][10]== '0000':\n",
    "                    frame17book2_label.config(text=\"None\\t\\t\\tNone\\t\\t\\tNone\\t\\tnone\")\n",
    "                else:\n",
    "                    cursor.execute(\"SELECT * from book_details WHERE BOOK_ID = '%s' \"%(t[0][10]))\n",
    "                    v=(cursor.fetchall())\n",
    "                    frame17book2_label.config(text=str(t[0][10])+'\\t\\t\\t'+v[0][1]+'\\t\\t\\t  '+str(t[0][11])+'\\t\\t'+str(t[0][12]))\n",
    "        else:\n",
    "            frame13_label.config(text=\"Wrong password\")\n",
    "    except IndexError:\n",
    "        frame13_label.config(text=\"USERNAME not found\")\n",
    "        \n",
    "        \n",
    "\n",
    "image=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\FRAME1.jpg\")\n",
    "image=image.resize((1530,800),Image.ANTIALIAS)\n",
    "img = ImageTk.PhotoImage(image)\n",
    "panel = tk.Label(frame1, image = img)\n",
    "panel.place(relx=0,rely=0)\n",
    "frame1_title=tk.Label(frame1,text='LIBRARY MANAGEMENT SYSTEM',bg='red',font=20)\n",
    "frame1_title.pack(fill='x')\n",
    "frame11_entry=tk.Entry(frame1,textvariable=name_var,)\n",
    "frame11_entry.place(relx=0.8,rely=0.435)\n",
    "frame12_entry=tk.Entry(frame1,textvariable=passw_var,show='*')\n",
    "frame12_entry.place(relx=0.8,rely=0.535)\n",
    "frame11_btn1 = tk.Button(frame1,text='LOGIN',command=login,bg='white')\n",
    "frame11_btn1.place(relx=0.7,rely=0.65)\n",
    "frame12_btn2 = tk.Button(frame1,text='FORGOT PASSWORD',command=forgot,bg='white')\n",
    "frame12_btn2.place(relx=0.825,rely=0.65)\n",
    "frame13_label=tk.Label(frame1,text=\"\",font=20,bg='white')\n",
    "frame13_label.place(relx=0.73,rely=0.75,)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "image2=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame41.jpg\")\n",
    "image2=image2.resize((1530,800),Image.ANTIALIAS)\n",
    "img2 = ImageTk.PhotoImage(image2)\n",
    "panel2 = tk.Label(frame2, image = img2)\n",
    "panel2.place(relx=0,rely=0)\n",
    "frame21_label = tk.Label(frame2,text=\"DASHBOARD\",width=20,height=1,font=20)\n",
    "frame211_button = tk.Button(frame2,text=\"PROFILE\",width=8,height=2,command=data)\n",
    "frame21_button = tk.Button(frame2, text=\"ADD BOOKS\",width=15,height=2,command=lambda:show_frame(frame4))\n",
    "frame22_button = tk.Button(frame2, text=\"EDIT BOOKS\",width=15,height=2,command=lambda:show_frame(frame7))\n",
    "frame23_button = tk.Button(frame2, text=\"ISSUE BOOKS\",width=15,height=2,command=lambda:show_frame(frame13))\n",
    "frame24_button = tk.Button(frame2, text=\"RETURN BOOKS\",width=15,height=2,command=lambda:show_frame(frame14))\n",
    "frame25_button = tk.Button(frame2, text=\"DELETE BOOKS\",width=15,height=2,command=lambda:show_frame(frame5))\n",
    "frame26_button = tk.Button(frame2, text=\"SHOW BOOKS\",width=15,height=2,command=Showall)\n",
    "frame27_button = tk.Button(frame2, text=\"SEARCH BOOKS\",width=15,height=2,command=lambda:show_frame(frame11))\n",
    "frame28_button = tk.Button(frame2, text=\"RENEW BOOKS\",width=15,height=2,command=lambda:show_frame(frame15))\n",
    "frame29_button = tk.Button(frame2, text=\"PAY FINE\",width=15,height=2,command=lambda:show_frame(frame16))\n",
    "frame210_button = tk.Button(frame2, text=\"LOGOUT\",width=15,height=2,command=logout)\n",
    "back_button1=tk.Button(frame2,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame1))\n",
    "frame21_label.place(relx=0.42,rely=0.1)\n",
    "frame211_button.place(relx=0.1,rely=0.1)\n",
    "frame21_button.place(relx=0.25,rely=0.2)\n",
    "frame22_button.place(relx=0.25,rely=0.3)\n",
    "frame23_button.place(relx=0.25,rely=0.4)\n",
    "frame24_button.place(relx=0.25,rely=0.5)\n",
    "frame25_button.place(relx=0.25,rely=0.6)\n",
    "frame26_button.place(relx=0.7,rely=0.2)\n",
    "frame27_button.place(relx=0.7,rely=0.3)\n",
    "frame28_button.place(relx=0.7,rely=0.4)\n",
    "frame29_button.place(relx=0.7,rely=0.5)\n",
    "frame210_button.place(relx=0.7,rely=0.6)\n",
    "back_button1.place(relx=0.5,rely=0.8)\n",
    "\n",
    "frame3_title=tk.Label(frame3,text='this is frame3',bg='green')\n",
    "frame3_title.pack(fill='x')\n",
    "frame3_btn = tk.Button(frame3,text='enter',command=lambda:show_frame(frame1))\n",
    "frame3_btn.pack()\n",
    "\n",
    "\n",
    "image3=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame4.jpg\")\n",
    "image3=image3.resize((1530,800),Image.ANTIALIAS)\n",
    "img3 = ImageTk.PhotoImage(image3)\n",
    "panel3 = tk.Label(frame4, image = img3)\n",
    "panel3.place(relx=0,rely=0)\n",
    "frame41_label=tk.Label(frame4,text=\"BOOK_ID\",width=20,height=2,bg=\"pink\")\n",
    "frame41_label.place(relx=0.35,rely=0.2)\n",
    "frame42_label=tk.Label(frame4,text=\"TITLE\",width=20,height=2,bg=\"pink\")\n",
    "frame42_label.place(relx=0.35,rely=0.3)\n",
    "frame43_label=tk.Label(frame4,text=\"AUTHOR\",width=20,height=2,bg=\"pink\")\n",
    "frame43_label.place(relx=0.35,rely=0.4)\n",
    "frame44_label=tk.Label(frame4,text=\"EDITION\",width=20,height=2,bg=\"pink\")\n",
    "frame44_label.place(relx=0.35,rely=0.5)\n",
    "frame45_label=tk.Label(frame4,text=\"PRICE\",width=20,height=2,bg=\"pink\")\n",
    "frame45_label.place(relx=0.35,rely=0.6)\n",
    "back_button41=tk.Button(frame4,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button41.place(relx=0.51,rely=0.8)\n",
    "frame41_entry=tk.Entry(frame4,width=30,borderwidth=8)\n",
    "frame41_entry.place(relx=0.55,rely=0.2)\n",
    "frame42_entry=tk.Entry(frame4,width=30,borderwidth=8)\n",
    "frame42_entry.place(relx=0.55,rely=0.3)\n",
    "frame43_entry=tk.Entry(frame4,width=30,borderwidth=8)\n",
    "frame43_entry.place(relx=0.55,rely=0.4)\n",
    "frame44_entry=tk.Entry(frame4,width=30,borderwidth=8)\n",
    "frame44_entry.place(relx=0.55,rely=0.5)\n",
    "frame45_entry=tk.Entry(frame4,width=30,borderwidth=8)\n",
    "frame45_entry.place(relx=0.55,rely=0.6)\n",
    "frame42_button=tk.Button(frame4,text=\"REGISTER\",width=10,height=2,command=Register).place(relx=0.5,rely=0.7)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "image5=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame3.jpg\")\n",
    "image5=image5.resize((1530,800),Image.ANTIALIAS)\n",
    "img5 = ImageTk.PhotoImage(image5)\n",
    "panel5 = tk.Label(frame5, image = img5)\n",
    "panel5.place(relx=0,rely=0)\n",
    "frame51_label=tk.Label(frame5,text=\"BOOK_ID\",width=20,height=2,bg=\"pink\")\n",
    "frame51_label.place(relx=0.31,rely=0.3)\n",
    "frame51_entry=tk.Entry(frame5,width=30,borderwidth=8)\n",
    "frame51_entry.place(relx=0.49,rely=0.3)\n",
    "frame51_button=tk.Button(frame5,text=\"DELETE\",width=10,height=2,command=Delete)\n",
    "frame51_button.place(relx=0.45,rely=0.52)\n",
    "back_button51=tk.Button(frame5,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button51.place(relx=0.46,rely=0.6)\n",
    "\n",
    "\n",
    "image17=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame6.jpg\")\n",
    "image17=image17.resize((1530,800),Image.ANTIALIAS)\n",
    "img17 = ImageTk.PhotoImage(image17)\n",
    "panel17 = tk.Label(frame17, image = img17)\n",
    "panel17.place(relx=0,rely=0)\n",
    "frame171_label = tk.Label(frame17,text=\"DASHBOARD\",width=20,height=1,font=20)\n",
    "frame176_button = tk.Button(frame17, text=\"SHOW BOOKS\",width=15,height=2,command=Showall)\n",
    "frame177_button = tk.Button(frame17, text=\"SEARCH BOOKS\",width=15,height=2,command=lambda:show_frame(frame18))\n",
    "frame179_button = tk.Button(frame17, text=\"PAY FINE\",width=15,height=2,command=lambda:show_frame(frame19))\n",
    "frame1710_button = tk.Button(frame17, text=\"LOGOUT\",width=15,height=2,command=logout)\n",
    "frame171_label.place(relx=0.42,rely=0.1)\n",
    "frame176_button.place(relx=0.2,rely=0.2)\n",
    "frame177_button.place(relx=0.4,rely=0.2)\n",
    "frame179_button.place(relx=0.6,rely=0.2)\n",
    "frame1710_button.place(relx=0.8,rely=0.2)\n",
    "frame17name_label = tk.Label(frame17,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame17name_label.place(relx=0.25,rely=0.41)\n",
    "frame17user_label = tk.Label(frame17,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame17user_label.place(relx=0.25,rely=0.465)\n",
    "frame17status_label = tk.Label(frame17,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame17status_label.place(relx=0.62,rely=0.465)\n",
    "frame17email_label = tk.Label(frame17,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame17email_label.place(relx=0.25,rely=0.52)\n",
    "frame17mob_label = tk.Label(frame17,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame17mob_label.place(relx=0.62,rely=0.52)\n",
    "frame17book1_label = tk.Label(frame17,text=\"\",width=110,height=1,font=22,bg='white')\n",
    "frame17book1_label.place(relx=0.1,rely=0.65)\n",
    "frame17book2_label = tk.Label(frame17,text=\"\",width=110,height=1,font=22,bg='white')\n",
    "frame17book2_label.place(relx=0.1,rely=0.725)\n",
    "frame17due_label = tk.Label(frame17,text=\"\",width=20,height=1,font=22,bg='white')\n",
    "frame17due_label.place(relx=0.2,rely=0.83)\n",
    "\n",
    "\n",
    "image20=Image.open(\"C:\\\\Users\\\\RISHABH LUHARUKA\\\\Downloads\\\\frame20.jpg\")\n",
    "image20=image20.resize((1530,800),Image.ANTIALIAS)\n",
    "img20 = ImageTk.PhotoImage(image20)\n",
    "panel20 = tk.Label(frame20, image = img20)\n",
    "panel20.place(relx=0,rely=0)\n",
    "frame20name_label = tk.Label(frame20,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame20name_label.place(relx=0.25,rely=0.41)\n",
    "frame20user_label = tk.Label(frame20,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame20user_label.place(relx=0.25,rely=0.465)\n",
    "frame20status_label = tk.Label(frame20,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame20status_label.place(relx=0.62,rely=0.465)\n",
    "frame20email_label = tk.Label(frame20,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame20email_label.place(relx=0.25,rely=0.52)\n",
    "frame20mob_label = tk.Label(frame20,text=\"\",width=30,height=1,font=22,bg='white')\n",
    "frame20mob_label.place(relx=0.62,rely=0.52)\n",
    "frame20book1_label = tk.Label(frame20,text=\"\",width=110,height=1,font=22,bg='white')\n",
    "frame20book1_label.place(relx=0.1,rely=0.65)\n",
    "frame20book2_label = tk.Label(frame20,text=\"\",width=110,height=1,font=22,bg='white')\n",
    "frame20book2_label.place(relx=0.1,rely=0.725)\n",
    "frame20due_label = tk.Label(frame20,text=\"\",width=20,height=1,font=22,bg='white')\n",
    "frame20due_label.place(relx=0.2,rely=0.83)\n",
    "back_button20=tk.Button(frame20,text=\"BACK\",width=5,height=2,command=lambda:show_frame(frame2))\n",
    "back_button20.place(relx=0.9,rely=0.9)\n",
    "\n",
    "\n",
    "show_frame(frame1)\n",
    "window.mainloop()\n",
    "conn.close()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}