Library Management System Python Project with source code | GUI and Database

Library Management System Python Project with source code GUI and Database

Introduction

Concatenating GUI with a database into a solid management project is currently the most popular project idea when it comes to an interview project or a megaproject. These projects can be desktop or mobile or web apps. So, in this article, we will be building a solid GUI-based Library Management System Python Project with source code and a Database that will manage a library store.

Python supports built-in database ‘sqlite3’ and a GUI library ‘tkinter’, so we don’t need to explicitly install both.

Click here to get all the resources used in this project.

If you want only code, go to the bottom of the page and copy the code with the copy option available there.

Let’s get started. First, let’s discuss the functionalities of the project.

What is it gonna do actually?

Library Management System will consist of
1. Admin Panel – where only authorized admins will be logged in for managing the store through id and password. Also, it includes the change password option.
2. Dashboard – it will include the name of the logged-in admin, date, and clock. Also, it’s the main core of the project as it will be designed for 8 functionalities :
i. Add Books – add books to store
ii. Issue Books – issue books to students, max limit is 3, and the date of the last issue book will be considered while returning
iii. Edit Books – edit details of the books
iv. Return Books – return the book and check for fine charges
v. Delete Books – delete books from the store
vi. Search Books – details about the book
vii. Show Books – show the whole book
viii. Log out – log out from the current admin session

And most important, it is considered here that students and admins are already registered.

How we will build this?

This is a database and GUI-based project, hence we will be using Tkinter and sqlite3 libraries from Python. Other than this we may require some like time or SMTP as per the requirement.
Before moving ahead, let’s go for a short intro to these modules:

Tkinter: It is the standard GUI library in python. It also provides full OOP programming support and it’s easy and fast
sqlite3: SQLite3 can be integrated with Python using the sqlite3 module. It provides an SQL interface compliant.

We don’t have to install these modules as they come into the built-in package.

Note: In the project total of 3 databases we are going to create as per the functionality. So, it is easier to create them visually instead of writing nasty SQL queries. Hence, it is recommended to install SQLite studio or any other workbench. We can create a database and tables and add rows and columns with desired constraints with ease from such apps.
Link to download SQLite studio: https://sqlitestudio.pl/

Now that we are done with the introduction and how we are gonna actually do this, let’s step towards implementation. We are building this stepwise one by one functionality.

assignment advertisement

We are using object-oriented programming here, as there are more functions that are kind of connected to the dashboard, hence classes work best.

Admin Panel:

First, let’s make a rough layout sketch and then start building it by code:

Library Management System Python Project with source code | GUI and Database

Hope you are clear with the layout, let’s build it with code:

As stated earlier, only those admins who are already registered have the right to log in. And here the database comes into the picture. First, we have to create a database with a table that will contain – a username and password. Constraints can be set according to one’s choice.

Herewith the help of SQLite studio, I am creating a database ‘admin’, a table in there as ‘UserLogin’ containing two fields (columns) UserID and Password. Please use column names significantly, as we are using them in our main program.

Here, you can add as many entries as you want.

Let’s now code our layout.
We are gonna create a single object for the whole program instantiating the main code where admins can log in. And from this key function, we are associating various other related functionalities.

Coding Library Management System Python Project with source code

The whole code will be inside the class named ‘main’.

from tkinter import *
from tkinter import ttk
from turtle import bgcolor
from PIL import Image
from PIL import ImageTk

#main window
root = Tk()
root.title("Library Management System")
root.iconbitmap('filename.ico')
root.geometry("900x500+50+100")
root.resizable(0, 0)

class main:

    def code(self):

        self.fm=Frame(root,height=500,width=900,bg='white')
        self.fm.place(x=0,y=0)

        self.canvas=Canvas(self.fm,height=500,width=900,bg='#000000')
        self.canvas.place(x=0,y=0)

        self.photo=PhotoImage(file=r"filename.png")
        self.canvas.create_image(0,0,image=self.photo,anchor=NW)

        self.fm1=Frame(self.canvas,height=260,width=300,bg='#000000',bd=3,relief='sunken')
        self.fm1.place(x=300,y=120)
        
        #UserID Label
        self.b1=Label(self.fm1,text='User ID',bg='black',font=('Arial',10,'bold'),fg='white')
        self.b1.place(x=20,y=42)

        self.e1=Entry(self.fm1,width=22,font=('arial',9,'bold'),bd=4,relief='groove')
        self.e1.place(x=100,y=40)
        
        #Password Label
        self.lb2=Label(self.fm1,text='Password',bg='black',font=('Arial',10,'bold'),fg='white')
        self.lb2.place(x=20,y=102)

        self.e2=Entry(self.fm1,width=22,show='*',font=('arial',9,'bold'),bd=4,relief='groove')
        self.e2.place(x=100,y=100)
        
        #Login Button
        self.btn1=Button(self.fm1,text='  Login',fg='black',bg='yellow',width=100,font=('Arial',11,'bold'),
                    activebackground='black',activeforeground='yellow',command=self.login,bd=3,relief='flat',cursor='hand2')
        self.btn1.place(x=25,y=160)
        self.logo = PhotoImage(file=r"filename.png")
        self.btn1.config(image=self.logo, compound=LEFT)
        self.small_logo = self.logo.subsample(1, 1)
        self.btn1.config(image=self.small_logo)
        
        #Clear Button
        self.btn2=Button(self.fm1,text='  Clear',fg='black',bg='yellow',width=100,font=('Arial',11,'bold'),
                    activebackground='black',activeforeground='yellow',bd=3,relief='flat',cursor='hand2',
                            command=self.mainclear)
        self.btn2.place(x=155,y=160)
        self.log = PhotoImage(file=r"filename.png")
        self.btn2.config(image=self.log, compound=LEFT)
        self.small_log = self.log.subsample(1, 1)
        self.btn2.config(image=self.small_log)
        
        #Forgot Password Clickable Label
        self.forgot=Label(self.fm1,text='Forgot Password?',fg='White',bg='#000000',activeforeground='black',
                            font=('cursive',9,'bold'))
        self.forgot.place(x=80,y=220)
        self.forgot.bind("<Button>",self.mouseClick)
        
        
        root.mainloop()
        
        
    def login(self):
        pass 
    
    def mainclear(self):
        pass 
    
    def mouseClick(self):
        pass
        
        
#object for calling the function
obj=main()
obj.code() 
        

This is our main layout and we haven’t coded for the functions yet for the sake of program execution.
One thing needs to observe here as in the program we have made a clickable label for the forgotten password with the help of the bind() function, which will now behave like a button.

And you can totally customize this with images, colors, and maybe positions. Here, buttons have also been added with some images for a visual better look.

Output:

welcome page of Library Management System Python Project

So Great! And sophisticated with minimum lines of code. Now let’s complete the functions for each of the buttons.

Library Management System Python Project with source code GUI and Database

Note: All the functions we are building are inside single class main. So please take proper care of the indentation.

Let’s code for the Clear button first.

class main:
    def mainclear(self):
        self.e1.delete(0,END)
        self.e2.delete(0,END)

The clear function will clear all the entries i.e. User ID entry and Password entry.

Now for the Forgot Password. If the admin has forgotten the password, a new popup window should appear on the screen to set his password and this change must reflect in our ‘admin’ database.

Creating database connection

This is the point we need to create a connection with the database ‘admin’ for login and forgot password purposes.

#make connection for 'admin' database
db=sqlite3.connect('admin.db')

Note: The connections we are making for each of the databases are not inside the main class. They are at the start right after the module’s code.

class main:

    def mouseClick(self,event):
     
        self.rog=Tk()
        self.rog.title("Change password")
        self.rog.geometry("400x300+300+210")
        self.rog.iconbitmap("filename.ico")
        self.rog.resizable(0,0)
        self.rog.configure(bg='#000')

        self.framerog=Frame(self.rog,width=160,height=30,bg="#d6ed17")
        self.framerog.place(x=95,y=15)

        self.label=Label(self.framerog,text="SET NEW PASSWORD",bg='#d6ed17',fg='#606060',font=("Calibri",12,'bold'))
        self.label.place(x=5,y=4)

        #User ID
        self.user=Label(self.rog,text='User ID',bg='#000',fg='white',font=("Times New Roman",11,'bold'))
        self.user.place(x=40,y=95)

        #New Password
        self.user = Label(self.rog, text='New Password',bg='#000', fg='white', font=("Times New Roman", 11, 'bold'))
        self.user.place(x=40, y=170)

        self.ef1 = Entry(self.rog, width=24, font=('Calibri', 8, 'bold'), bd=4, relief='groove')
        self.ef1.place(x=170, y=95)

        self.ef2 = Entry(self.rog, width=24, font=('Calibri', 8, 'bold'), bd=4, relief='groove')
        self.ef2.place(x=170, y=170)

        #Submit Button
        self.btn1 = Button(self.rog, text='SUBMIT', fg='#606060', bg='#d6ed17', width=8, font=('Calibri', 12, 'bold'),
                        activebackground='black', activeforeground='#d6ed17',bd=3, relief='flat',
                            cursor='hand2',command=self.chan_pas)
        self.btn1.place(x=40, y=240)
        
        
    
    def chan_pas(self):
    
        self.a=self.ef1.get()
        self.b=self.ef2.get()
        
        import sqlite3
        conn=sqlite3.connect('admin.db')
        cursor=conn.cursor()
        cursor.execute("SELECT * FROM UserLogin WHERE UserID='"+self.a+"'")
        conn.commit()
        self.data=cursor.fetchone()

        if self.data!=None:
                cursor = conn.cursor()
                cursor.execute("UPDATE UserLogin SET Password='" + self.b + "' WHERE UserID='" + self.a + "'")
                conn.commit()
                messagebox.showinfo("SUCCESSFUL","Your Password is changed")
                self.rog.destroy()
        else:
                messagebox.showerror("ERROR", "UserID doesn't exist")
                self.rog.destroy()
                

        self.rog.mainloop()
      
    

As to the code, when the forgotten password will be clicked by the user, a new window will appear to set the new password. Using sqlite3 query, database ‘admin’ will reflect the changes.

You can see the password has been successfully changed and the messagebox widget has been used in the program to display errors or success if any.

Login Button

Now that it’s time to code for the Login Button. After clicking the login button via entering the correct ID and Password, the admin must see the functional panel of the library management system which contains 8 different functions (mentioned at the top) and the Name of the logged-in Admin, today’s date, and a real-time clock.

class main:

    def login(self):
    
        self.var1 = self.e1.get()
        self.var2 = self.e2.get()
        
        cursor=db.cursor()
        cursor.execute("SELECT * FROM UserLogin WHERE UserID='"+self.var1+"' and Password='"+self.var2+"'")
        db.commit()
        self.ab = cursor.fetchone()
        
        if self.ab!=None:
            self.under_fm=Frame(root,height=500,width=900,bg='#fff')
            self.under_fm.place(x=0,y=0)
            
            self.fm2=Frame(root,bg='#012727',height=80,width=900)
            self.fm2.place(x=0,y=0)
            
            self.lbb=Label(self.fm2,bg='#012727')
            self.lbb.place(x=15,y=5)
            self.ig=PhotoImage(file='filename.png')
            self.lbb.config(image=self.ig)
            
            self.lb3=Label(self.fm2,text='DASHBOARD',fg='White',bg='#012727',font=('times new roman',30,'bold'))
            self.lb3.place(x=325,y=17)
            
            #Name of the logged in admin
            self.name=Label(root,text="Name : ",bg='#fff',fg="black",font=('Calibri',12,'bold'))
            self.name.place(x=5,y=83)
            self.name1=Label(root,text=self.ab[0],fg='black',bg='#fff',font=('Calibri',12,'bold'))
            self.name1.place(x=60,y=83)
            
            #Display Date
            self.today=date.today()
            self.dat=Label(root,text='Date : ',bg='#fff',fg='black',font=('Calibri',12,'bold'))
            self.dat.place(x=750,y=83)
            self.dat2 = Label(root, text=self.today, bg='#fff', fg='black', font=('Calibri', 12, 'bold'))
            self.dat2.place(x=800, y=83)
            
            #For Head part
            self.cur()

        else:
            messagebox.showerror('Library System', 'Your ID or Password is invalid!')

The heading, Admin’s name, and the current date will be visible after the successful ‘Login’ operation. Here you can see we have defined a separate cur() function which will be taken care of the body part of the window: the buttons and the clock. Let’s code cur()

class main:
    def cur(self):
        self.fm3=Frame(root,bg='#fff',width=900,height=390)
        self.fm3.place(x=0,y=110)
        
        def clock():
            h = str(time.strftime("%H"))
            m = str(time.strftime("%M"))
            s = str(time.strftime("%S"))

            if int(h) >=12 and int(m) >=0:
                    self.lb7_hr.config(text="PM")

            #if int(h) > 12:
                    #h = str(int(h) // 12)

            self.lb1_hr.config(text=h)
            self.lb3_hr.config(text=m)
            self.lb5_hr.config(text=s)

            self.lb1_hr.after(200, clock)
        
        self.lb1_hr = Label(self.fm3, text='12', font=('times new roman', 20, 'bold'), bg='#581845', fg='white')
        self.lb1_hr.place(x=607, y=0, width=60, height=30)
        
        
        self.lb3_hr = Label(self.fm3, text='05', font=('times new roman', 20, 'bold'), bg='#581845', fg='white')
        self.lb3_hr.place(x=677, y=0, width=60, height=30)
        
        
        self.lb5_hr = Label(self.fm3, text='37', font=('times new roman', 20, 'bold'), bg='#581845', fg='white')
        self.lb5_hr.place(x=747, y=0, width=60, height=30)
        
        
        self.lb7_hr = Label(self.fm3, text='AM', font=('times new roman', 17, 'bold'), bg='#581845', fg='white')
        self.lb7_hr.place(x=817, y=0, width=60, height=30)
        
        clock()
        
        #right side image
        self.canvas8 = Canvas(self.fm3, bg='black', width=400, height=300)
        self.canvas8.place(x=475, y=40)
        self.photo9=PhotoImage(file="filename.png")
        self.canvas8.create_image(0,0,image=self.photo9,anchor=NW)
        
        self.develop=Label(self.fm3,text='Developed By - <YourName>',bg='#fff',fg='#d7837f',
                       font=('Candara',12,'bold'))
        self.develop.place(x=732,y=350)
        
        #AddButton

        self.bt1=Button(self.fm3,text='  Add Books',fg='#fff',bg='#581845',font=('Candara',15,'bold'),width=170,
                  height=0,bd=7,relief='flat',command=self.addbook,cursor='hand2',activebackground='black',activeforeground='#581845')
        self.bt1.place(x=40,y=40)
        self.logo = PhotoImage(file='filename.png')
        self.bt1.config(image=self.logo, compound=LEFT)
        self.small_logo = self.logo.subsample(1,1)
        self.bt1.config(image=self.small_logo)
        
        #IssueButton

        self.bt2 = Button(self.fm3, text='  Issue Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),
                    width=170,height=0, bd=7,relief='flat',command=self.issuebook,cursor='hand2',activebackground='black',activeforeground='#581845')
        self.bt2.place(x=250, y=40)
        self.log = PhotoImage(file='bt2.png')
        self.bt2.config(image=self.log, compound=LEFT)
        self.small_log = self.log.subsample(1, 1)
        self.bt2.config(image=self.small_log)
        
        #EditButton

        self.bt3 = Button(self.fm3, text='  Edit Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),
                   width=170,height=0,bd=7,relief='flat',cursor='hand2',command=self.edit,activebackground='black',activeforeground='#581845')
        self.bt3.place(x=40, y=120)
        self.logb = PhotoImage(file='bt3.png')
        self.bt3.config(image=self.logb, compound=LEFT)
        self.small_logb = self.logb.subsample(1, 1)
        self.bt3.config(image=self.small_logb)
        
        #ReturnButton

        self.bt4 = Button(self.fm3, text='  Return Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),
                  width=170,height=0,bd=7,relief='flat',cursor='hand2',command=self.returnbook,activebackground='black',activeforeground='#581845')
        self.bt4.place(x=250, y=120)
        self.log4 = PhotoImage(file='bt4.png')
        self.bt4.config(image=self.log4, compound=LEFT)
        self.small_log4 = self.log4.subsample(1, 1)
        self.bt4.config(image=self.small_log4)
        
        #DeleteButton

        self.bt5 = Button(self.fm3, text=' Delete Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),
                  width=170,height=0,bd=7,relief='flat',cursor='hand2',command=self.delete,activebackground='black',activeforeground='#581845')
        self.bt5.place(x=40, y=200)
        self.log5 = PhotoImage(file='bt5.png')
        self.bt5.config(image=self.log5, compound=LEFT)
        self.small_log5 = self.log5.subsample(1, 1)
        self.bt5.config(image=self.small_log5)
        
                
        #ShowButton

        self.bt6 = Button(self.fm3, text=' Show Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),
                  width=170,height=0,bd=7, relief='flat',cursor='hand2',command=self.show,activebackground='black',activeforeground='#581845')
        self.bt6.place(x=40, y=280)
        self.log6 = PhotoImage(file='bt6.png')
        self.bt6.config(image=self.log6, compound=LEFT)
        self.small_log6 = self.log6.subsample(1, 1)
        self.bt6.config(image=self.small_log6)
        
        
        #SearchButton

        self.bt7 = Button(self.fm3, text='  Search Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),
                   width=170,height=0,bd=7, relief='flat',cursor='hand2',command=self.search,activebackground='black',activeforeground='#581845')
        self.bt7.place(x=250, y=200)
        self.log7 = PhotoImage(file='bt7.png')
        self.bt7.config(image=self.log7, compound=LEFT)
        self.small_log7 = self.log7.subsample(1, 1)
        self.bt7.config(image=self.small_log7)
        
        
        #ExitButton
        try:
        
            self.bt8 = Button(self.fm3, text='  Log Out', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),
                           width=170,
                      height=0, bd=7, relief='flat',cursor='hand2',command=self.code,activebackground='black',activeforeground='#581845')
            self.bt8.place(x=250, y=280)
            self.log8 = PhotoImage(file='bt8.png')
            self.bt8.config(image=self.log8, compound=LEFT)
            self.small_log8 = self.log8.subsample(1, 1)
            self.bt8.config(image=self.small_log8)
        
        except:
        
            self.bt9 = ttk.Button(self.fm3, text="Name", bg='#a40000', font=('Candara', 15, 'bold'), width=150,
                                 height=0)
            self.bt9.place(x=40, y=350)
            self.log9 = PhotoImage(file='bt8.png')
            self.bt9.config(image=self.log9, compound=LEFT)
            self.small_log9 = self.log9.subsample(3, 3)
            self.bt9.config(image=self.small_log9)  
            
    def addbook(self):
        pass
    
    def issuebook(self):
        pass
    
    def edit(self):
        pass
    
    def returnbook(self):
        pass
    
    def delete(self):
        pass
    
    def show(self):
        pass
        
    def search(self):
        pass

This is it. We have successfully coded the login button and so as a dashboard. Now for each of the buttons, we are making a new window for individual functionality but before that let’s check if the code is visual.

We are good to go towards coding the actual functions of our management system. But, before that, do you remember we have talked earlier about the databases? You might have guessed there were gonna be 3 databases and we have only worked for 1 till now. The rest of the 2 databases are coming into the picture now.

The Database

The 2 databases will be 1. Students database – where unique PRN/ERP No, Name, Section, Course, Contact, etc details will be stored and 2. Books database – which will contain info about books in our store.

Let’s create these databases and add some manual entries to them, also it’s a must to create a connection.

Now that you know, how to create a database without writing typical queries, you can create using sqlite3.

Here I am creating a database called ‘StudentsData’ and a table in there as ‘Students’ and it will contain the following parameters:

Library Management System Python Project with source code | GUI and Database Concatenating GUI with a database into a solid management project is currently the most popular project idea when it comes to an interview project or a megaproject. These projects can be desktop or mobile or web apps. So, in this article, we will be building a solid GUI-based Library Management System Python Project with source code and a Database that will manage a library store.

Obviously, you can change the length of data types, primary keys, uniqueness, or anything.

ERP will be a special and unique ID associated with each student. Name, Course, Year, RollNo, Email, ContactNo comes under student details. FromDate will be used to store the date at which the student is issuing a book. Submit Date will be the date chosen for submission. A charge will be charges paid by student after the due date. (Assume it’s Rs. 5/- per day) NoBook will be the number of books the student has and its default value must be set to 0.

Now enter the data manually into the database. Leave the columns FromDate, SubmitDate empty. NoBook and Charge will automatically become 0 as default.

Now, the next and final database of our system ‘StoreBooks’ with table ‘Books’ is as follows:

Library Management System Python Project with source code | GUI and Database Concatenating GUI with a database into a solid management project is currently the most popular project idea when it comes to an interview project or a megaproject. These projects can be desktop or mobile or web apps. So, in this article, we will be building a solid GUI-based Library Management System Python Project with source code and a Database that will manage a library store.

BookID is the unique ID for each book and thus it’s the primary key. Title, Author, Edition, and Price associated with the book information. The issue will tell whether the book is issued or not. ID will basically store the ERP ID of the last student who issued the book. Here also, enter the data manually. Leave the columns Issue and ID empty.

Also, here you don’t have to worry about entering books manually as in one of the utilities, we are already adding the ‘Add Books’ option.

The databases have all set. But not until the connection is established. Let’s establish it first. As said earlier, the connections should be outside the main class without having any kind of indentation, maybe just right after the module’s import. Or right after the database ‘admin’.

#Connection for admin database
db=sqlite3.connect('admin.db')

#Connection for StoreBooks database
dbstore=sqlite3.connect('StoreBooks.db')

#Connection for StudentsData database
dbstudents=sqlite3.connect('StudentsData.db')

Okay, we are good to go towards the core functions of our system. Let’s catch them one by one. From here we will be creating classes inside the functions because there will be more different functions associated with the individual function and also inheriting our main class for the back button.

1. Adding Books:

Add Book will provide utility to add the books and then store it in the database. This addition of books will take BookID, Name, Author, Edition, and Price as input.

At the time of login, we have already defined addbook function, let’s complete it.

class main:
    def addbook(self):
        class temp(main):
            def book(self):
            
                self.fm=Frame(root,bg='#ffe8ec',width=900,height=390)
                self.fm.place(x=0,y=110)
                
                self.fm1=Frame(self.fm,bg='#ffe8ec',width=500,height=360,bd=5,relief='flat')
                self.fm1.place(x=200,y=15)
                
                #Back Button (clickable image)
                self.backbt = Button(self.fm, width=60, bg='#ffe8ec', bd=0, relief='flat',command=self.cur,activeforeground='black',activebackground='#ffe8ec')
                self.backbt.place(x=2, y=7)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2, 2)
                self.backbt.config(image=self.small_log)

                self.fll=Frame(self.fm1,width=150,height=40,bg='#ff6690')
                self.fll.place(x=150,y=15)
                self.ll=Label(self.fll,text='ADD BOOKS',fg='#fff',bg='#ff6690',font=('Canara',12,'bold'),width=15)
                self.ll.place(x=0,y=8)
                
                #ID
                self.lb=Label(self.fm1,text='ID',fg='black',bg='#ffe8ec',font=('times new roman',11,'bold'))
                self.lb.place(x=70,y=90)
                
                #Title
                self.lb2 = Label(self.fm1, text='Title', fg='black', bg='#ffe8ec', font=('times new roman', 11, 'bold'))
                self.lb2.place(x=70, y=130)
                
                #Author
                self.lb3 = Label(self.fm1, text='Author', fg='black', bg='#ffe8ec', font=('times new roman', 11, 'bold'))
                self.lb3.place(x=70, y=170)
                
                #Edition
                self.lb4= Label(self.fm1, text='Edition', fg='black', bg='#ffe8ec', font=('times new roman', 11, 'bold'))
                self.lb4.place(x=70, y=210)
                
                #Price
                self.lb5 = Label(self.fm1, text='Price', fg='black', bg='#ffe8ec', font=('times new roman', 11, 'bold'))
                self.lb5.place(x=70, y=250)
                
                #Entries
                self.ee1=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee1.place(x=180,y=88)
                
                self.ee2=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee2.place(x=180,y=130)
                
                self.ee3=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee3.place(x=180,y=170)
                
                self.ee4=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee4.place(x=180,y=210)
                
                self.ee5=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee5.place(x=180,y=250)
                
                #Submit Button
                self.bt=Button(self.fm1,text='SUBMIT',width=8,fg='white',bg='#ff6690',font=('Canara',12,'bold'),bd=3,
                          relief='flat',command=self.submit1,activebackground='black',activeforeground='#ff6690')
                self.bt.place(x=70,y=300)
              
             
            #Submit Button function 
            def submit1(self):
                try:
                    self.id=self.ee1.get()
                    self.ttl=self.ee2.get()
                    self.aut=self.ee3.get()
                    self.edi=self.ee4.get()
                    self.pri=self.ee5.get()
                    
                    if(self.id and self.ttl and self.aut and self.edi and self.pri):
                        cursor=dbstore.cursor()
                        cursor.execute("INSERT INTO Books(BookID,Title,Author,Edition,Price) values(?,?,?,?,?)",(self.id,
                                                                                                        self.ttl,self.aut,self.edi,self.pri))
                        dbstore.commit()
                        
                        messagebox.showinfo("Success","Book has been added to the library succesfully")
                        
                        #clear the entries after succesful operation
                        self.clear()
                    else:
                        messagebox.showerror("Error", "Enter Valid Details")
                    
                except Exception as e:
                        messagebox.showerror("Error", "Enter Valid Details")
                        
            def clear(self):
                self.ee1.delete(0,END)
                self.ee2.delete(0,END)
                self.ee3.delete(0,END)
                self.ee4.delete(0,END)
                self.ee5.delete(0,END)
         
        #create object to invoke function       
        obj=temp()
        obj.book()

This is a very simple addbook function with OOP approach. We have created a new window for adding books, making admins input details of the book and submitting and thus reflecting changes inside the database ‘Store Books’. Also, if any error occurs it is handled. Let’s run.

Add Books

Next,

2. Issue Books:

This is the core function of our management system as it issues the book to the student and records the return date of the last selected book. A student can take a maximum of 3 books.

We are gonna code this a bit differently, i.e. by putting the yes no option if more books need to issue.

Also, this has a mail option where students will receive mail about book issued but it totally depends upon you, as SMTP requires the sender’s mail and password, so it’s kind of a private matter for most of us.

Let’s code:

import smtplib
import sqlite3
import time
import datetime
from datetime import datetime
from datetime import timedelta
from datetime import date

class main:
    def issuebook(self):
        class test(main):
        
            max=0
            n = 1
            def issue(self):
                self.f = Frame(root, bg='#ffe8ec', width=900, height=390)
                self.f.place(x=0, y=110)
                
                self.fmi=Canvas(self.f,bg='#ffe8ec',width=900,height=390,bd=0,relief='flat')
                self.fmi.place(x=0,y=0)
                
                self.fc=Frame(self.fmi,bg='#ffe8ec',width=338,height=230,bd=4,relief='flat')
                self.fc.place(x=70,y=20)
                
                self.ffbll=Frame(self.fc,bg='#00203f', bd=2,relief='flat', width=210,height=40)
                self.ffbll.place(x=50,y=0)
                
                self.lc=Label(self.ffbll,text='STUDENT  INFORMATION',bg='#00203f',fg='#adefd1',font=('Arial',12,'bold'))
                self.lc.place(x=0,y=6)    
                
                #ERP ID of student
                self.lb = Label(self.fc, text='ERP ID', bg='#ffe8ec', fg='black', font=('times new roman', 11, 'bold'))
                self.lb.place(x=15, y=90)
                
                self.em2 = Entry(self.fc, width=30, bd=5, relief='ridge', font=('Arial', 8, 'bold'))
                self.em2.place(x=105, y=90)
                
                #Submit Button for ERP ID
                self.bt = Button(self.fc, text='SUBMIT', width=8, bg='#00203f', fg='#adefd1', font=('Canara', 12, 'bold'),
                             bd=5,relief='flat',command=self.check, activeforeground='#00203f',activebackground='#adefd1')
                self.bt.place(x=15,y=160)
                
                #Back Button (clickable image)
                self.backbt = Button(self.fmi,width=60, bg='#ffe8ec',activebackground='#ffe8ec',bd=0, relief='flat',
                                       command=self.issueback)
                self.backbt.place(x=5, y=5)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2, 2)
                self.backbt.config(image=self.small_log)
                
            def check(self):
                self.b=self.em2.get()
                
                cursor=dbstudents.cursor()
                cursor.execute("SELECT * FROM Students WHERE ERP='"+self.b+"'")
                self.var=cursor.fetchone()
                if self.var!=None:
                    self.fmii=Canvas(self.f,bg='#ffe8ec',width=338,height=90,bd=0,relief='flat')
                    self.fmii.place(x=70,y=255)
                    
                    #Name
                    self.lb1=Label(self.fmii,text='Name :',fg='black',bg ='#ffe8ec',font=('Calibri',12,'bold'))
                    self.lb1.place(x=5,y=5)
                    self.lb2 = Label(self.fmii, text=self.var[1],fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb2.place(x=70, y=5)
                    
                    #Course
                    self.lb3 = Label(self.fmii, text='Course :',fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb3.place(x=5, y=25)
                    self.lb4 = Label(self.fmii, text=self.var[2],fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb4.place(x=70, y=25)
                    
                    #Year
                    self.lb5 = Label(self.fmii, text='Year :', fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb5.place(x=5, y=45)
                    self.lb6 = Label(self.fmii, text=self.var[3], fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb6.place(x=70, y=45)
                    
                    #Contact
                    self.lb7 = Label(self.fmii, text='Contact :', fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb7.place(x=5, y=65)
                    self.lb8 = Label(self.fmii, text=self.var[6],fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb8.place(x=70, y=65)
                    
                    #IssueBooks
                    self.fr=Frame(self.fmi,bg='#ffe8ec',bd=5,relief='flat',width=338,height=250)
                    self.fr.place(x=420,y=20)
                    self.ff=Frame(self.fr,bg='#adefd1',bd=2,relief='flat',width=140,height=40)
                    self.ff.place(x=80,y=0)
                    
                    self.lb=Label(self.ff,text='ISSUE BOOK',bg='#adefd1',fg='#00203f',font=('Arial',12,'bold'))
                    self.lb.place(x=13,y=5)
                    
                    #Book ID
                    self.tt=Label(self.fr,text='BOOK ID',bg='#ffe8ec',fg='#00203f',font=('times new roman',11,'bold'))
                    self.tt.place(x=30,y=90)
                    self.e1 = Entry(self.fr, width=30, bd=5, relief='ridge', font=('Arial', 8, 'bold'))
                    self.e1.place(x=130, y=90)
                    
                    #Submit Button for BookID
                    self.bt1 = Button(self.fr, text='SUBMIT', width=8, bg='#adefd1', fg='#00203f', font=('Canara', 12,
                                                                    'bold'),bd=5,relief='flat',command=self.data,activeforeground='#adefd1',activebackground='#00203f')
                    self.bt1.place(x=15, y=160)
                
                else:
                    messagebox.showwarning('Warning','This student is not registered !')
                    
            def issueback(self):
                try:
                    self.boot.destroy()
                    self.cur()
                except Exception as e:
                    self.cur()
                    
            repeat=0
            
            def data(self):
                self.b=self.em2.get()
                cursor=dbstudents.cursor()
                cursor.execute("SELECT * FROM Students WHERE ERP='"+self.b+"'")
                self.var=cursor.fetchone()
                self.flag=0
                if(int(self.var[11])>=3):
                    try:
                        self.boot.destroy()
                        messagebox.showerror("Unable to process request","You exceed the limit of Books per student!")
                        self.flag=1
                        self.cur()

                    except Exception as e:
                        messagebox.showerror("Unable to process request","You exceed the limit of Books per student!")
                        self.flag=1
                        self.cur()
                
                self.vva=self.e1.get()
                   
                cursor=dbstore.cursor()
                cursor.execute("SELECT * FROM Books WHERE BookID='"+self.vva+"'")
                dbstore.commit()
                self.value=cursor.fetchone()
                
                if self.value!=None:
                   if(self.flag!=1):
                        self.boot=Tk()
                        self.boot.title("Issue Books")
                        self.boot.iconbitmap("filename.ico")
                        self.boot.configure(bg='#ffe8ec')
                        self.boot.geometry("370x450+880+30")
                        self.boot.resizable(0,0)
                        test.repeat=1
                        
                        self.lb=Label(self.boot,text='Title:',bg='#ffe8ec',fg='black',font=('Calibri',12,'bold'))
                        self.lb.place(x=30,y=30)
                        self.lbn = Label(self.boot, text=self.value[1], bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                        self.lbn.place(x=120,y=30)
                        self.lb = Label(self.boot, text='Author:', bg='#ffe8ec', fg='black', font=('Calibri', 12,
                                                                                                'bold'))
                        self.lb.place(x=30, y=60)
                        self.lbn = Label(self.boot, text=self.value[2], bg='#ffe8ec', fg='black', font=('Calibri', 12,
                                                                                                'bold'))
                        self.lbn.place(x=120, y=60)
                        self.lb = Label(self.boot, text='Edition:', bg='#ffe8ec', fg='black', font=('Calibri', 12,
                                                                                                'bold'))
                        self.lb.place(x=30, y=90)
                        self.lbn = Label(self.boot, text=self.value[3], bg='#ffe8ec', fg='black', font=('Calibri', 12,
                                                                                                'bold'))

                        self.lbn.place(x=120, y=90)
                        
                        self.label = Label(self.fr, text='ADD MORE BOOKS ', bg='#ffe8ec', fg='black', font=('times new romman', 11,
                                                                                                        'bold'))
                        self.label.place(x=15, y=220)
                        
                        #Radio Button
                        self.it1=Radiobutton(self.fr,text='YES',bg='#ffe8ec',variable='radio',value=1,command=self.yes)
                        self.it1.place(x=170,y=220)

                        self.it2 = Radiobutton(self.fr, text='NO',bg='#ffe8ec', variable='radio', value=2,command=self.no)
                        self.it2.place(x=240, y=220)

                        #ISSUED button
                        self.button1 = Button(self.boot, text='ISSUE', bg='#adefd1', fg='#00203f', width=10, height=0,
                                        font=('Canara', 11, 'bold'), activebackground='#00203f',activeforeground='#adefd1',command=self.issued)
                        self.button1.place(x=30, y=400)

                        self.btn = Button(self.boot, text='SEND MAIL', bg='#adefd1', fg='#00203f', width=10, height=0,
                                        font=('Canara', 11, 'bold'),activebackground='#00203f',activeforeground='#adefd1', command=self.mail)
                        self.btn.place(x=160, y=400)
                        
                        #Date - Calendar
                        self.x = date.today()

                        self.cal = Calendar(self.boot, selectmode="day", bg='black',year=2022,month=3,day=30)
                        self.cal.place(x=20,y=150)
                        

                        btn1 = Button(self.boot, text="CONFIRM DATE",command=self.get_data,  bg='#343148',
                                font=('Canara', 11,'bold'),
                                fg='#d7c49e',activebackground='black', activeforeground='#d7c49e', relief='flat')
                        btn1.place(x=90,y=350)

                        self.boot.mainloop()
                
                else:
                    messagebox.showerror('Book Not Found','No such book exists!')
                    self.e1.delete(0,END)
                    
            
            def get_data(self):
                self.datecon=self.cal.selection_get()   
                
            def yes(self):
                self.n=self.n+1
               
                self.bt1 = Button(self.fr, text='SUBMIT', width=8, bg='#adefd1', fg='#00203f', font=('Canara', 12,'bold'),bd=5,relief='flat',command=self.data,activeforeground='#adefd1',activebackground='#00203f',state=ACTIVE)
                self.bt1.place(x=15, y=160)

                self.e1.delete(0, END)
                #self.e2.delete(0, END)
                
                self.max=self.max-1
                
            def no(self):
                self.bt1 = Button(self.fr, text='SUBMIT', width=8, bg='#adefd1', fg='#00203f', font=('Canara', 12,'bold'),bd=5,relief='flat',command=self.data,activeforeground='#adefd1',activebackground='#00203f',state=DISABLED)
                self.bt1.place(x=15, y=160)
                
            def issued(self):
                self.datecon=self.cal.selection_get()
               
                self.ac=self.e1.get()
                cursor=dbstore.cursor()
                    
                cursor.execute("UPDATE Books SET Issue='Issued', ID='"+self.b+"' WHERE "
                                                                                    "BookID='"+self.ac+"'")
                dbstore.commit()
                
                if self.n<=3:
                    book=dbstudents.cursor()
                    self.erpid1=self.em2.get()
                    book.execute("SELECT * FROM Students WHERE ERP='"+self.erpid1+"'")
                    self.issuevar=book.fetchone()
                    self.sum=self.issuevar[11]+1
                    book.execute("UPDATE Students SET NoBook='"+str(self.sum)+"' WHERE ERP='"+self.b+"' ")
                    dbstudents.commit()
                
                comm=dbstudents.cursor()
                comm.execute("UPDATE Students SET FromDate='"+str(self.x)+"', ToDate='"+str(self.datecon)+"' , SubmitDate='' WHERE ERP='"+self.b+"'")
                dbstudents.commit()
                
                messagebox.showinfo('Library Management System', 'YOUR BOOK HAS BEEN ISSUED')
                self.boot.destroy()
                self.e1.delete(0, END)
                
            
            def mail(self):

                self.erpid=self.em2.get()
                cursor=dbstudents.cursor()
                cursor.execute("SELECT * FROM Students WHERE ERP='"+self.erpid+"'")
                self.var=cursor.fetchone()
                sender = "libraryauthority@gmail.com"
                reciever =self.var[5]
                with open("passwordfilename.txt",'r') as file:
                    password=file.read()
                message = """FROM: LIBRARY DEPARTMENT
                          TO : Library Issued Books Department
                          Subject: Hello Student! Your book has been Issued"""
                try:
                    server = smtplib.SMTP_SSL("smtp.gmail.com", 465)
                    server.login(sender, password)
                    server.sendmail(sender, reciever, message)
                    print("ok")
                    messagebox.showinfo("Library System","Send mail Successfully !")
                except Exception as e:
                    pass
                    
        obissue=test()
        obissue.issue()

Hitting Issue Books Button will open a new window for student ERP ID, after submitting the ID, details of the student will be displayed below by fetching them from the database ‘StudentsData’.

Entering the Book ID at the entry box on the right side will make the function display details of the book with the calendar. Confirming the date in the calendar with the help of confirming date button, will set the SubmitDate in the database to the date selected. Students can only issue up to 3 books, and the messagebox will give an error if the limit exceeds. For adding more books at the same time, the radio button will enable the functionality, if it is checked as ‘Yes’, every time a new book has to be added, indicating the right submit button’s changed color.

Note: For the mail button, you can create a password file in the same working folder and enter the login credentials of your email address. And if it’s not working or any error occurs, the program won’t give you any as it is handled in the exception box.

Even if the first time a student has been issued 2 or 1 book, the next time only 1 or 2 books can be assigned as the total NoBook count in the database should not exceed 3.

Let’s run for some of the possible cases:

Issue Books

The changes are clearly visible in the database StudentsData and also, as per the cases we have run (in the above video), the StoreBooks database also seen to be updated as:

showing data Library Management System Python Project with source code

You can add your own ideas or methods inside this function to make it more creative or util.

Library Management System Python Project with source code GUI and Database

3. Editing Books in Library Management System Python Project with source code:

Edit Books function is kind of database-oriented, as it will authorize the admin to modify/update details of the book. This is the simple one. ‘Books’ table from the ‘StoreBooks’ database will reflect changes here. Let’s code for this.

class main:
    def edit(self):
        class editing(main):
            def edbooks(self):
            
                self.ffm=Frame(root,bg='#ffe8ec',width=900,height=390)
                self.ffm.place(x=0,y=110)
                
                self.fm1 = Frame(self.ffm, bg='#ffe8ec', width=500, height=200, bd=5, relief='flat')
                self.fm1.place(x=150, y=30)
                
                self.ed = Frame(self.fm1, bg='#1c1c1b', bd=0, relief='flat', width=160, height=35)
                self.ed.place(x=170,y=0)
                
                self.lab = Label(self.ed, text='EDIT BOOK DETAILS', bg='#1c1c1b', fg='#ce4a7e', font=('Calibri', 12,
                                                                                            'bold'))
                self.lab.place(x=9, y=5)
                
                #BookID
                self.label3=Label(self.fm1,text='Book ID',bg='#ffe8ec',fg='black',font=('Times New Roman',11,'bold'))
                self.label3.place(x=85,y=65)
                self.entry=Entry(self.fm1,width=30,bd=4,relief='groove',font=('Calibri',8,'bold'))
                self.entry.place(x=188,y=65)
                
                #Search Button
                self.button7 = Button(self.fm1, text='SEARCH', bg='#1c1c1b', fg='#ce4a7e', width=8,
                          font=('Calibri', 12, 'bold'),command=self.searchedit ,relief='flat',activebackground='#ce4a7e',activeforeground='#1c1c1b')
                self.button7.place(x=85,y=125)
                
                #Back Button (clickable image)
                self.backbt = Button(self.ffm, width=60, bg='#ffe8ec',activebackground='#ffe8ec',
                                  bd=0, relief='flat', command=self.cur)
                self.backbt.place(x=0, y=0)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2, 2)
                self.backbt.config(image=self.small_log)
                
            def searchedit(self):
                self.datas=self.entry.get()
                cursor=dbstore.cursor()
                cursor.execute("SELECT * FROM Books WHERE BookID = '"+self.datas+"'" )
                dbstore.commit()
                self.val=cursor.fetchone()
                if self.val!=None:
                    self.edcat=Tk()
                    self.edcat.title("Library System")
                    self.edcat.geometry("300x360+600+230")
                    self.edcat.configure(bg='#ffe8ec')
                    self.edcat.iconbitmap("filename.ico")
                    
                    self.fc=Frame(self.edcat,bg='#1c1c1b',width=90,height=30)
                    self.fc.place(x=80,y=10)
                    
                    self.lab=Label(self.fc,bg='#1c1c1b',fg='#ce4a7e',text='EDIT BOOK',font=('Calibri',12,'bold'))
                    self.lab.place(x=3,y=3)
                    
                    #BookID
                    self.labid = Label(self.edcat, bg='#ffe8ec', fg='black', text='Book ID:', font=('Calibri', 12,
                                                                                               'bold'))
                    self.labid.place(x=30, y=60)
                    
                    #Title
                    self.labti = Label(self.edcat, bg='#ffe8ec', fg='black', text='Title:', font=('Calibri', 12,
                                                                                            'bold'))
                    self.labti.place(x=30, y=100)
                    
                    #Author
                    self.labaut = Label(self.edcat, bg='#ffe8ec', fg='black', text='Author:', font=('Calibri', 12,
                                                                                            'bold'))
                    self.labaut.place(x=30, y=140)
                    
                    #Edition
                    self.labed = Label(self.edcat, bg='#ffe8ec', fg='black', text='Edition:', font=('Calibri', 12,
                                                                                            'bold'))
                    self.labed.place(x=30, y=180)
                    
                    #Price
                    self.labpr = Label(self.edcat, bg='#ffe8ec', fg='black', text='Price:', font=('Calibri', 12,
                                                                                            'bold'))
                    self.labpr.place(x=30, y=220)


                    self.en1=Entry(self.edcat,width=20,bd=4,relief='groove',font=('Times New Roman',9,'bold'))
                    self.en1.place(x=110,y=60)
                    
                    self.en2 = Entry(self.edcat, width=20, bd=4, relief='groove',font=('Times New Roman',9,'bold'))
                    self.en2.place(x=110, y=100)
                    
                    self.en3 = Entry(self.edcat, width=20, bd=4, relief='groove',font=('Times New Roman',9,'bold'))
                    self.en3.place(x=110, y=140)
                    
                    self.en4 = Entry(self.edcat, width=20, bd=4, relief='groove',font=('Times New Roman',9,'bold'))
                    self.en4.place(x=110, y=180)
                    
                    self.en5 = Entry(self.edcat, width=20, bd=4, relief='groove',font=('Times New Roman',9,'bold'))
                    self.en5.place(x=110, y=220)
                    
                    #Submit Button for updating changes
                    self.butt = Button(self.edcat, text='SUBMIT', bg='#1c1c1b', fg='#ce4a7e', width=8,
                              font=('Calibri', 12, 'bold'),command=self.savedit,relief='flat')
                    self.butt.place(x=30, y=273)
                    
                    self.en1.insert(0, self.val[0])
                    self.en2.insert(0, self.val[1])
                    self.en3.insert(0, self.val[2])
                    self.en4.insert(0, self.val[3])
                    self.en5.insert(0, self.val[4])
                    
                    self.edcat.mainloop()
                
                else:
                    messagebox.showerror('Invalid Entry',"This Book doesn't exists!")
                    self.entry.delete(0,END)
                    
            def savedit(self):
                self.id = self.en1.get()
                self.ti = self.en2.get()
                self.au = self.en3.get()
                self.ed = self.en4.get()
                self.pi = self.en5.get()
                
                if(self.id and self.ti and self.au and self.ed and self.pi):
                    cursor= dbstore.cursor()
                    cursor.execute("UPDATE Books SET BookID='"+self.id+"', Title='"+self.ti+"',Author='"+self.au+"',Edition='"+self.ed+"',Price='"+self.pi+"' WHERE BookID='"+self.datas+"'")
                    dbstore.commit()
                    messagebox.showinfo('Changes Saved','Data has been updated successfully!')
                    self.edcat.destroy()
                    self.entry.delete(0,END)
                else:
                    messagebox.showerror('Error','Enter Valid Details')
                    self.entry.delete(0,END)
        obj=editing()
        obj.edbooks()

Let’s run the code:

Edit Books

In case the admin enters null values or if the book is not in store, the messagebox will give a corresponding error.

4. Return Books:

In the return books function, students can return the book and they will be charged if it’s above due.

Let’s code:

class main:
    def returnbook(self):
        class retu(main):
            def __init__(self):
            
                self.frame=Frame(root,bd=0,relief='flat',bg='#ffe8ec',width=900,height=390)
                self.frame.place(x=0,y=110)
                
                self.f1 = Frame(self.frame, bg='#ffe8ec', width=500, height=200, bd=5, relief='flat')
                self.f1.place(x=200, y=15)
                
                self.ed = Frame(self.f1, bg='#581845', bd=0, relief='flat', width=130, height=35)
                self.ed.place(x=170, y=0)
                
                self.lac = Label(self.ed, text='RETURN BOOKS ', bg='#581845', fg='#fff', font=('Calibri', 12, 'bold'))
                self.lac.place(x=10, y=5)
                
                #ERP ID
                self.label8 = Label(self.f1, text='ERP ID', bg='#ffe8ec', fg='black', font=('Times New Roman', 11, 'bold'))
                self.label8.place(x=85, y=65)
                
                self.entry4 = Entry(self.f1, width=30, bd=4, relief='groove', font=('Calibri', 8, 'bold'))
                self.entry4.place(x=188, y=65)
                
                #Return Button
                self.button9 = Button(self.f1, text='RETURN', bg='#581845', fg='#fff', width=8, height=0,
                                font=('Calibri', 12, 'bold'),command=self.retbook,activebackground="#000",activeforeground="#581845")
                self.button9.place(x=85, y=120)
                
                #Back Button (Clickable Image)
                self.backbt = Button(self.frame, width=60, bg='#ffe8ec', activebackground='#ffe8ec',
                                bd=0, relief='flat', command=self.cur)
                self.backbt.place(x=0, y=0)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2,2)
                self.backbt.config(image=self.small_log)
                
            def retsucc(self):
                self.entry4.delete(0,END)
                cursor1 = dbstudents.cursor()
                cursor1.execute("UPDATE Students SET FromDate='',ToDate='',Charge='"+str(self.charge)+"' WHERE ERP='"+self.entry+"'")
                dbstudents.commit()
                messagebox.showinfo("Success","Charges Updated and Books Returned Succesfully")
                self.tom.destroy()
                
            def retbook(self):
                self.charge=0
                self.entry=self.entry4.get()
                
                cursor=dbstudents.cursor()
                cursor.execute("SELECT * FROM Students WHERE ERP='"+self.entry+"'")
                dbstudents.commit()
                
                self.data=cursor.fetchone()
                if self.data!=None:
                    if(int(self.data[11])>=1):
                        self.get_date = date.today()
                        cursor = dbstudents.cursor()
                        
                        cursor.execute("UPDATE Students SET NoBook = 0, SubmitDate='" + str(
                                self.get_date) + "' WHERE ERP='" + self.entry + "'")
                        dbstudents.commit()

                        cursor=dbstore.cursor()
                        cursor.execute("UPDATE Books SET Issue='', ID='' WHERE ID='"+self.entry+"'")
                        dbstore.commit()   
                        
                        from datetime import datetime
                        
                        cursor=dbstudents.cursor()
                        cursor.execute("SELECT * FROM Students WHERE ERP='"+self.entry+"'")
                        dbstudents.commit()
                        self.var=cursor.fetchone()
                        if self.var!=None:
                            self.a=self.var[8]
                            self.b=self.var[9]
                            formatStr='%Y-%m-%d'
                            delta1=datetime.strptime(self.a,formatStr)
                            delta2=datetime.strptime(self.b, formatStr)
                            delta=delta2-delta1
                            chm=delta.days
                            
                            if chm<=0:
                                messagebox.showinfo("Success","Books returned successfully")
                                self.entry4.delete(0,END)
                            
                            else:
                                self.tom=Tk()
                                self.tom.geometry("300x150+300+258")
                                self.tom.iconbitmap("filename.ico")
                                self.tom.title("Library System")
                                self.tom.resizable(0,0)
                                self.tom.configure(bg="#ffe8ec")
                                
                                self.lb=Label(self.tom,text="Name of Student: ",bg="#ffe8ec",fg="black",font=('Calibri',11,'bold'))
                                self.lb.place(x=5,y=20)
                                self.lb2=Label(self.tom,text=self.var[1],bg="#ffe8ec",fg="black",font=('Calibri',11,'bold'))
                                self.lb2.place(x=130,y=20)
                                
                                self.charge=(5*chm)+int(self.var[10])
                                self.lb3=Label(self.tom,text="Fine Charge: ",bg="#ffe8ec",fg="black",font=('Calibri',11,'bold'))
                                self.lb3.place(x=5,y=55)
                                
                                self.lc2 = Label(self.tom, text=self.charge, bg="#ffe8ec", fg="black", font=('Calibri',11,
                                                                                                                        'bold'))
                                self.lc2.place(x=130, y=55)
                                self.lc3 = Label(self.tom, text='Rs.', bg="#ffe8ec", fg="black",
                                                font=('Calibri', 11, 'bold'))
                                self.lc3.place(x=150, y=55)

                                self.tombtn = Button(self.tom,text='SUBMIT', background='#581845',foreground='white',font=('Calibri',12,'bold'),width=8,
                                                      activebackground='black',activeforeground='#581845',relief='flat',command=self.retsucc)

                                self.tombtn.place(x=5,y=90)
                                
                                self.tom.mainloop()
                               
                            cursor1 = dbstudents.cursor()
                            cursor1.execute("UPDATE Students SET FromDate='',ToDate='', Charge='"+str(self.charge)+"' WHERE ERP='"+self.entry+"'")
                            dbstudents.commit()
                    else:
                        messagebox.showwarning("No Books Found","This student does not have any book issued!")
                        self.entry4.delete(0,END)
                        
                else:
                        messagebox.showerror("Invalid ERP ID","This student doesn't exist!")
                        self.entry4.delete(0,END)
        object=retu()        
                        

All the books issued to a given ERP ID will be returned and the Date of Submission will be noted. If there are any charges pending (previous any), they will be added to current charges if overdue. And Both databases, StoreBooks and StudentsData will be updated.

Return Books

5. Delete Books:

Delete Books function will delete the inputted book ID from the store i.e. from the ‘Books’ table in the database ‘StoreBooks’. Pretty easy right? Yes, let’s see:

class main:
    def delete(self):
            class dele(main):
                def deletebooks(self):
               
                    self.ff = Frame(root, bg='#ffe8ec', width=900, height=390)
                    self.ff.place(x=0, y=110)
                    
                    self.f1 = Frame(self.ff, bg='#ffe8ec', width=500, height=200, bd=5, relief='flat')
                    self.f1.place(x=200, y=15)
                    
                    self.ed = Frame(self.f1, bg='#7ea310', bd=0, relief='flat', width=120, height=30)
                    self.ed.place(x=150, y=0)
                    
                    self.lac = Label(self.ed, text='DELETE BOOKS ', bg='#7ea310', fg='#213502', font=('Calibri', 12,'bold'))
                    self.lac.place(x=7, y=3)
                    
                    #Book ID
                    self.label8 = Label(self.f1, text='Book ID', bg='#ffe8ec', fg='black', font=('times new roman', 11, 'bold'))
                    self.label8.place(x=85, y=65)
                    self.entry4 = Entry(self.f1, width=30, bd=4, relief='groove', font=('Calibri', 8, 'bold'))
                    self.entry4.place(x=188, y=65)
                    
                    #Delete Books Button
                    self.button9 = Button(self.f1, text='DELETE', bg='#7ea310', fg='#213502', width=8,
                              font=('Calibri', 12, 'bold'),command=self.deldata,relief='flat',activebackground='black',activeforeground='#7ea310')
                    self.button9.place(x=85, y=120)
                    
                    #Back Button (Clickable Image)
                    self.backbt = Button(self.ff,width=60, bg='#ffe8ec',activebackground='#ffe8ec',
                                      bd=0, relief='flat', command=self.cur)
                    self.backbt.place(x=0, y=0)
                    self.log = PhotoImage(file='filename.png')
                    self.backbt.config(image=self.log, compound=LEFT)
                    self.small_log = self.log.subsample(2,2)
                    self.backbt.config(image=self.small_log)
                    
                def deldata(self):
                    self.a=self.entry4.get()
                    
                    cursor=dbstore.cursor()
                    cursorv=dbstore.cursor()
                    cursorv.execute("SELECT * FROM BOOKS WHERE BookID='"+self.a+"'")
                    dbstore.commit()
                    self.validation=cursorv.fetchone()
                    
                    if(self.validation!=None):
                        cursor.execute("DELETE FROM Books WHERE BookID='"+self.a+"'")
                        dbstore.commit()
                        messagebox.showinfo('Succesful','The book is successfully removed from the store!')
                        self.entry4.delete(0,END)
                    else:
                        messagebox.showerror('Invalid Operation','This book does not exist!')
                        self.entry4.delete(0,END)
                        
            occ=dele()
            occ.deletebooks()

Easy to understand right, let’s check if it’s really removing the books from our store. We will check through the program window itself again once we complete our Search Book function.

Delete Books

Next,

6. Searching Books in Library Management System Python Project with source code:

As the name suggests, this function will look for the Book ID inputted and display the result if it’s available. Or error message if it’s not. Easy Pizy, let’s code:

class main:
    def search(self):
            class demt(main):
                def delmdata(self):

                    self.fc = Frame(root, bg='#ffe8ec', width=900, height=390)
                    self.fc.place(x=0, y=110)
                    
                    self.fc1 = Frame(self.fc, bg='#ffe8ec', width=500, height=200, bd=5, relief='flat')
                    self.fc1.place(x=200, y=15)
                    
                    self.edm = Frame(self.fc1, bg='#b76e79', bd=0, relief='flat', width=130, height=35)
                    self.edm.place(x=140, y=0)
                    
                    self.lac = Label(self.edm, text='SEARCH BOOKS ', bg='#b76e79', fg='#fff', font=('Calibri', 12, 'bold'))
                    self.lac.place(x=8, y=5)
                    
                    #Book ID
                    self.label8 = Label(self.fc1, text='Book ID', bg='#ffe8ec', fg='black', font=('Times New Roman', 11, 'bold'))
                    self.label8.place(x=85, y=65)
                    self.entryl= Entry(self.fc1, width=30, bd=4, relief='groove', font=('Calibri', 8, 'bold'))
                    self.entryl.place(x=188, y=65)
                    
                    #Search Button
                    self.butto = Button(self.fc1, text='SEARCH', bg='#b76e79', fg='#fff', width=8,
                                    font=('Calibri', 12, 'bold'),command=self.srch,relief='flat',activebackground='black',activeforeground='#b76e79')
                    self.butto.place(x=85, y=120)
                    
                    #Back Button (Clickable Image)
                    self.backbt = Button(self.fc,width=60, bg='#ffe8ec',activebackground='#ffe8ec',bd=0, relief='flat', command=self.cur)
                    self.backbt.place(x=0, y=0)
                    self.log = PhotoImage(file='filename.png')
                    self.backbt.config(image=self.log, compound=LEFT)
                    self.small_log = self.log.subsample(2, 2)
                    self.backbt.config(image=self.small_log)
                    
                def srch(self):
                    self.emp=self.entryl.get()
                    
                    cursor=dbstore.cursor()
                    cursor.execute("SELECT * FROM Books WHERE BookID='"+self.emp+"'")
                    dbstore.commit()
                    self.srval=cursor.fetchone()
                    
                    if self.srval!=None:
                        self.top=Tk()
                        self.top.title("Library System")
                        self.top.iconbitmap("filename.ico")
                        self.top.geometry("400x200+335+250")
                        self.top.resizable(0, 0)
                        self.top.configure(bg='#ffe8ec')

                        self.frm=Frame(self.top,bg='#b76e79',width=100,height=35)
                        self.frm.place(x=100,y=10)

                        self.mnlb=Label(self.frm,bg='#b76e79',fg='#fff',text="AVAILABLE",font=('Calibri',12,'bold'))
                        self.mnlb.place(x=9,y=5)

                        self.lb1 = Label(self.top, text='Title: ', bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                        self.lb1.place(x=85,y=70)
                        self.lb2=Label(self.top,text=self.srval[1],bg='#ffe8ec', fg='black',font=('Calibri',12,'bold'))
                        self.lb2.place(x=165,y=70)

                        self.lb3 = Label(self.top, text='Author: ', bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                        self.lb3.place(x=85, y=110)
                        self.lb4 = Label(self.top, text=self.srval[2], bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                        self.lb4.place(x=165, y=110)

                        self.lb5 = Label(self.top, text='Edition: ',bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                        self.lb5.place(x=85, y=150)
                        self.lb6 = Label(self.top, text=self.srval[3], bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                        self.lb6.place(x=165, y=150)
                        self.entryl.delete(0,END)
                        
                    else:
                        messagebox.showwarning('Invalid Data','This book does not exists!')
                        self.entryl.delete(0,END)
                
            object=demt()
            object.delmdata()

Time to run:

Search Books

We are almost done here! Let’s make this ‘almost’ the ‘full’:

7. Show Books:

Using tkinter’s table widget, we will put all the books in the store into tabular form.

class main:
    def show(self):
        class test(main):
            def __init__(self):
            
                self.fc = Frame(root, bg='#ffe8ec', width=900, height=390)
                self.fc.place(x=0, y=110)
                self.popframe=Frame(self.fc,width=180,height=30,bg='#edb40d')
                self.popframe.place(x=360,y=0)
                self.lbn=Label(self.popframe,bg='#edb40d',text='BOOKS INFORMATION',fg='#fff',font=('Calibri',12,
                                                                                                'bold'))
                self.lbn.place(x=8,y=4)
            
                #Back Button (Clickable Image)    
                self.backbt = Button(self.fc,width=30, bg='#ffe8ec',activebackground='#ffe8ec',
                                bd=0, relief='flat', command=self.cur)
                self.backbt.place(x=0, y=0)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(3, 3)
                self.backbt.config(image=self.small_log)

                self.table_frame=Frame(self.fc,bg='#ffe8ec',bd=1,relief='flat')
                self.table_frame.place(x=0,y=30,width=900,height=360)

                self.scroll_x=Scrollbar(self.table_frame,orient=HORIZONTAL)
                self.scroll_y=Scrollbar(self.table_frame,orient=VERTICAL)
                self.book_table=ttk.Treeview(self.table_frame,columns=("Book ID","Title","Author","Edition",
                                                                        "Price"),
                                xscrollcommand=self.scroll_x.set,yscrollcommand=self.scroll_y.set)
                self.scroll_x.pack(side=BOTTOM,fill=X)
                self.scroll_y.pack(side=RIGHT, fill=Y)
                self.scroll_x.config(command=self.book_table.xview)
                self.scroll_y.config(command=self.book_table.yview)

                self.book_table.heading("Book ID",text="Book ID")
                self.book_table.heading("Title", text="Title")
                self.book_table.heading("Author", text="Author")
                self.book_table.heading("Edition", text="Edition")
                self.book_table.heading("Price", text="Price")
                self.book_table['show']='headings'
                self.book_table.column("Book ID",width=200)
                self.book_table.column("Title", width=200)
                self.book_table.column("Author", width=200)
                self.book_table.column("Edition", width=120)
                self.book_table.column("Price", width=110)
                self.book_table.pack(fill=BOTH,expand=1)
                self.fetch_data()
                
            def fetch_data(self):
                cursor=dbstore.cursor()
                cursor.execute("SELECT * FROM Books")
                self.rows=cursor.fetchall()
                if len(self.rows)!=0:
                        for self.row in self.rows:
                                self.book_table.insert('',END,values=self.row)
                dbstore.commit()
                
        oc=test()

Output time:

Show Books

We are at the end. Our next function is,

8. Log Out of Library Management System Python Project with source code:

This function will log out the admin from the currently running session. We have already coded the function at the time of creating the button for it. We have assigned the command ‘self.code’ i.e. every time the Log Out button is clicked, self.code will get executed which is the first login window of our program!

Let’s run:

Log Out

Hurray! The project is done. So simple and beautiful.
Working with Tkinter is not a hard task unless you are familiar with its widgets and most importantly placing methods. If you want to add images in labels or in the background, use PhotoImage and go for images with ‘.png’, as it is generally easier. ‘.jpg’ or ‘.jpeg’ extensions also work but need write extra functions for it.

Also, here for the window logo, ‘icons’ are used. And the file must be of ‘.ico’ extension. OOP comes in handy when you have to include 2 or more functions in a single widget. You can convert this whole project into an exe application by Python’s auto-py-exe module.

Full code for Library Management System Python Project with source code-

from tkinter import *
from tkinter import ttk
from tkinter import messagebox
from tkinter import font
from turtle import bgcolor
from PIL import Image
from PIL import ImageTk
from tkcalendar import *
import smtplib
import sqlite3
import time
import datetime
from datetime import datetime
from datetime import timedelta
from datetime import date

db=sqlite3.connect('admin.db')
dbstore=sqlite3.connect('StoreBooks.db')
dbstudents=sqlite3.connect('StudentsData.db')

root = Tk()
root.title("Library Management System")
root.iconbitmap('filename.ico')
root.geometry("900x500+50+100")
root.resizable(0, 0)

class main:
    def login(self):
        self.var1 = self.e1.get()
        self.var2 = self.e2.get()
        cursor=db.cursor()
        cursor.execute("SELECT * FROM UserLogin WHERE UserID='"+self.var1+"' and Password='"+self.var2+"'")
        db.commit()
        self.ab = cursor.fetchone()
        
        if self.ab!=None:
            self.under_fm=Frame(root,height=500,width=900,bg='#fff')
            self.under_fm.place(x=0,y=0)
            
            self.fm2=Frame(root,bg='#012727',height=80,width=900)
            self.fm2.place(x=0,y=0)
            
            self.lbb=Label(self.fm2,bg='#012727')
            self.lbb.place(x=15,y=5)
            self.ig=PhotoImage(file='filename.png')
            self.lbb.config(image=self.ig)
            
            self.lb3=Label(self.fm2,text='DASHBOARD',fg='White',bg='#012727',font=('times new roman',30,'bold'))
            self.lb3.place(x=325,y=17)
            
            self.name=Label(root,text="Name : ",bg='#fff',fg="black",font=('Calibri',12,'bold'))
            self.name.place(x=5,y=83)
            self.name1=Label(root,text=self.ab[0],fg='black',bg='#fff',font=('Calibri',12,'bold'))
            self.name1.place(x=60,y=83)
            
            self.today=date.today()
            self.dat=Label(root,text='Date : ',bg='#fff',fg='black',font=('Calibri',12,'bold'))
            self.dat.place(x=750,y=83)
            self.dat2 = Label(root, text=self.today, bg='#fff', fg='black', font=('Calibri', 12, 'bold'))
            self.dat2.place(x=800, y=83)
            
            self.cur()
        else:
            messagebox.showerror('Library System', 'Your ID or Password is invalid!')
            
    def cur(self):
        self.fm3=Frame(root,bg='#fff',width=900,height=390)
        self.fm3.place(x=0,y=110)
        
        def clock():
            h = str(time.strftime("%H"))
            m = str(time.strftime("%M"))
            s = str(time.strftime("%S"))
            
            if int(h) >=12 and int(m) >=0:
                self.lb7_hr.config(text="PM")
                
            self.lb1_hr.config(text=h)
            self.lb3_hr.config(text=m)
            self.lb5_hr.config(text=s)
    
            self.lb1_hr.after(200, clock)
        
        self.lb1_hr = Label(self.fm3, text='12', font=('times new roman', 20, 'bold'), bg='#581845', fg='white')
        self.lb1_hr.place(x=607, y=0, width=60, height=30)

        self.lb3_hr = Label(self.fm3, text='05', font=('times new roman', 20, 'bold'), bg='#581845', fg='white')
        self.lb3_hr.place(x=677, y=0, width=60, height=30)
        
        self.lb5_hr = Label(self.fm3, text='37', font=('times new roman', 20, 'bold'), bg='#581845', fg='white')
        self.lb5_hr.place(x=747, y=0, width=60, height=30)
        
        self.lb7_hr = Label(self.fm3, text='AM', font=('times new roman', 17, 'bold'), bg='#581845', fg='white')
        self.lb7_hr.place(x=817, y=0, width=60, height=30)
        
        clock()
        self.canvas8 = Canvas(self.fm3, bg='black', width=400, height=300)
        self.canvas8.place(x=475, y=40)
        
        self.photo9=PhotoImage(file="filename.png")
        self.canvas8.create_image(0,0,image=self.photo9,anchor=NW)
        
        self.develop=Label(self.fm3,text='Developed By - Ishika',bg='#fff',fg='#d7837f'font=('Candara',12,'bold'))
        self.develop.place(x=732,y=350)
        
        
        self.bt1=Button(self.fm3,text='  Add Books',fg='#fff',bg='#581845',font=('Candara',15,'bold'),width=170,height=0,bd=7,relief='flat',command=self.addbook,cursor='hand2',activebackground='black',activeforeground='#581845')
        self.bt1.place(x=40,y=40)
        self.logo = PhotoImage(file='bt1.png')
        self.bt1.config(image=self.logo, compound=LEFT)
        self.small_logo = self.logo.subsample(1,1)
        self.bt1.config(image=self.small_logo)
        
        
        self.bt2 = Button(self.fm3, text='  Issue Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0, bd=7,relief='flat',command=self.issuebook,cursor='hand2',activebackground='black',activeforeground='#581845')
        self.bt2.place(x=250, y=40)
        self.log = PhotoImage(file='bt2.png')
        self.bt2.config(image=self.log, compound=LEFT)
        self.small_log = self.log.subsample(1, 1)
        self.bt2.config(image=self.small_log)
            
             
        self.bt3 = Button(self.fm3, text='  Edit Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7,relief='flat',cursor='hand2',command=self.edit,activebackground='black',activeforeground='#581845')
        self.bt3.place(x=40, y=120)
        self.logb = PhotoImage(file='bt3.png')
        self.bt3.config(image=self.logb, compound=LEFT)
        self.small_logb = self.logb.subsample(1, 1)
        self.bt3.config(image=self.small_logb)
             
             
        self.bt4 = Button(self.fm3, text='  Return Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7,relief='flat',cursor='hand2',command=self.returnbook,activebackground='black',activeforeground='#581845')
        self.bt4.place(x=250, y=120)
        self.log4 = PhotoImage(file='bt4.png')
        self.bt4.config(image=self.log4, compound=LEFT)
        self.small_log4 = self.log4.subsample(1, 1)
        self.bt4.config(image=self.small_log4)
             
             
        self.bt5 = Button(self.fm3, text=' Delete Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7,relief='flat',cursor='hand2',command=self.delete,activebackground='black',activeforeground='#581845')
        self.bt5.place(x=40, y=200)
        self.log5 = PhotoImage(file='bt5.png')
        self.bt5.config(image=self.log5, compound=LEFT)
        self.small_log5 = self.log5.subsample(1, 1)
        self.bt5.config(image=self.small_log5)
 
 
        self.bt6 = Button(self.fm3, text=' Show Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7, relief='flat',cursor='hand2',command=self.show,activebackground='black',activeforeground='#581845')
        self.bt6.place(x=40, y=280)
        self.log6 = PhotoImage(file='bt6.png')
        self.bt6.config(image=self.log6, compound=LEFT)
        self.small_log6 = self.log6.subsample(1, 1)
        self.bt6.config(image=self.small_log6)
    
        self.bt7 = Button(self.fm3, text='  Search Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7, relief='flat',cursor='hand2',command=self.search,activebackground='black',activeforeground='#581845')
        self.bt7.place(x=250, y=200)
        self.log7 = PhotoImage(file='bt7.png')
        self.bt7.config(image=self.log7, compound=LEFT)
        self.small_log7 = self.log7.subsample(1, 1)
        self.bt7.config(image=self.small_log7)
        
        try:

            self.bt8 = Button(self.fm3, text='  Log Out', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0, bd=7, relief='flat',cursor='hand2',command=self.code,activebackground='black',activeforeground='#581845')
            self.bt8.place(x=250, y=280)
            self.log8 = PhotoImage(file='bt8.png')
            self.bt8.config(image=self.log8, compound=LEFT)
            self.small_log8 = self.log8.subsample(1, 1)
            self.bt8.config(image=self.small_log8)

        except:

            self.bt9 = ttk.Button(self.fm3, text="Ram", bg='#a40000', font=('Candara', 15, 'bold'), width=150,height=0)
            self.bt9.place(x=40, y=350)
            self.log9 = PhotoImage(file='bt8.png')
            self.bt9.config(image=self.log9, compound=LEFT)
            self.small_log9 = self.log9.subsample(3, 3)
            self.bt9.config(image=self.small_log9)
            
    def addbook(self):
        class temp(main):
            def book(self):

                self.fm=Frame(root,bg='#ffe8ec',width=900,height=390)
                self.fm.place(x=0,y=110)
                
                self.fm1=Frame(self.fm,bg='#ffe8ec',width=500,height=360,bd=5,relief='flat')
                self.fm1.place(x=200,y=15)
                
                self.backbt = Button(self.fm, width=60, bg='#ffe8ec', bd=0, relief='flat',command=self.cur,activeforeground='black',activebackground='#ffe8ec')
                self.backbt.place(x=2, y=7)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2, 2)
                self.backbt.config(image=self.small_log)
                
                self.fll=Frame(self.fm1,width=150,height=40,bg='#ff6690')
                self.fll.place(x=150,y=15)
                self.ll=Label(self.fll,text='ADD BOOKS',fg='#fff',bg='#ff6690',font=('Canara',12,'bold'),width=15)
                #self.ll.config(height=5)
                self.ll.place(x=0,y=8)
                        
                self.lb=Label(self.fm1,text='ID',fg='black',bg='#ffe8ec',font=('times new roman',11,'bold'))
                self.lb.place(x=70,y=90)
                self.lb2 = Label(self.fm1, text='Title', fg='black', bg='#ffe8ec', font=('times new roman', 11, 'bold'))
                self.lb2.place(x=70, y=130)
                self.lb3 = Label(self.fm1, text='Author', fg='black', bg='#ffe8ec', font=('times new roman', 11, 'bold'))
                self.lb3.place(x=70, y=170)
                self.lb4= Label(self.fm1, text='Edition', fg='black', bg='#ffe8ec', font=('times new roman', 11, 'bold'))
                self.lb4.place(x=70, y=210)
                self.lb5 = Label(self.fm1, text='Price', fg='black', bg='#ffe8ec', font=('times new roman', 11, 'bold'))
                self.lb5.place(x=70, y=250)
        
                self.ee1=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee1.place(x=180,y=88)
                self.ee2=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee2.place(x=180,y=130)
                self.ee3=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee3.place(x=180,y=170)
                self.ee4=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee4.place(x=180,y=210)
                self.ee5=Entry(self.fm1,width=25,bd=4,relief='groove',font=('Calibri',11,'bold'))
                self.ee5.place(x=180,y=250)

                self.bt=Button(self.fm1,text='SUBMIT',width=8,fg='white',bg='#ff6690',font=('Canara',12,'bold'),bd=3,relief='flat',command=self.submit1,activebackground='black',activeforeground='#ff6690')
                self.bt.place(x=70,y=300)
            
            def submit1(self):
                try:

                    self.id=self.ee1.get()
                    self.ttl=self.ee2.get()
                    self.aut=self.ee3.get()
                    self.edi=self.ee4.get()
                    self.pri=self.ee5.get()

                    if(self.id and self.ttl and self.aut and self.edi and self.pri):
                            cursor=dbstore.cursor()
                            cursor.execute("INSERT INTO Books(BookID,Title,Author,Edition,Price) values(?,?,?,?,?)",(self.id,
                                                                                                            self.ttl,self.aut,self.edi,self.pri))
                            dbstore.commit()
                            messagebox.showinfo("Success","Book has been added to the library succesfully")
                            self.clear()
                    else:
                            messagebox.showerror("Error", "Enter Valid Details")
                except Exception as e:
                    messagebox.showerror("Error", "Enter Valid Details")
            
            def clear(self):
                self.ee1.delete(0,END)
                self.ee2.delete(0,END)
                self.ee3.delete(0,END)
                self.ee4.delete(0,END)
                self.ee5.delete(0,END)
                
        obj=temp()
        obj.book()
        
    def issuebook(self):
        class test(main):
            max=0
            n = 1
            def issue(self):
                self.f = Frame(root, bg='#ffe8ec', width=900, height=390)
                self.f.place(x=0, y=110)
                
                self.fmi=Canvas(self.f,bg='#ffe8ec',width=900,height=390,bd=0,relief='flat')
                self.fmi.place(x=0,y=0)
                
                self.fc=Frame(self.fmi,bg='#ffe8ec',width=338,height=230,bd=4,relief='flat')
                self.fc.place(x=70,y=20)
                
                self.ffbll=Frame(self.fc,bg='#00203f', bd=2,relief='flat', width=210,height=40)
                self.ffbll.place(x=50,y=0)
                
                self.lc=Label(self.ffbll,text='STUDENT  INFORMATION',bg='#00203f',fg='#adefd1',font=('Arial',12,'bold'))
                self.lc.place(x=0,y=6)
                
                self.lb = Label(self.fc, text='ERP ID', bg='#ffe8ec', fg='black', font=('times new roman', 11, 'bold'))
                self.lb.place(x=15, y=90)
                self.em2 = Entry(self.fc, width=30, bd=5, relief='ridge', font=('Arial', 8, 'bold'))
                self.em2.place(x=105, y=90)
                self.bt = Button(self.fc, text='SUBMIT', width=8, bg='#00203f', fg='#adefd1', font=('Canara', 12, 'bold'),bd=5,relief='flat',command=self.check, activeforeground='#00203f',activebackground='#adefd1')
                self.bt.place(x=15,y=160)
                 
                self.backbt = Button(self.fmi,width=60, bg='#ffe8ec',activebackground='#ffe8ec',bd=0, relief='flat',command=self.issueback)
                self.backbt.place(x=5, y=5)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2, 2)
                self.backbt.config(image=self.small_log)
        
            def check(self):
                self.b=self.em2.get()
                cursor=dbstudents.cursor()
                cursor.execute("SELECT * FROM Students WHERE ERP='"+self.b+"'")
                self.var=cursor.fetchone()
                
                if self.var!=None:
                    self.fmii=Canvas(self.f,bg='#ffe8ec',width=338,height=90,bd=0,relief='flat')
                    self.fmii.place(x=70,y=255)
                    self.lb1=Label(self.fmii,text='Name :',fg='black',bg ='#ffe8ec',font=('Calibri',12,'bold'))
                    self.lb1.place(x=5,y=5)
                    self.lb2 = Label(self.fmii, text=self.var[1],fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb2.place(x=70, y=5)
                    self.lb3 = Label(self.fmii, text='Course :',fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb3.place(x=5, y=25)
                    self.lb4 = Label(self.fmii, text=self.var[2],fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb4.place(x=70, y=25)
                    self.lb5 = Label(self.fmii, text='Year :', fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb5.place(x=5, y=45)
                    self.lb6 = Label(self.fmii, text=self.var[3], fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb6.place(x=70, y=45)
                    self.lb7 = Label(self.fmii, text='Contact :', fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb7.place(x=5, y=65)
                    self.lb8 = Label(self.fmii, text=self.var[6],fg='black',bg ='#ffe8ec', font=('Calibri', 12, 'bold'))
                    self.lb8.place(x=70, y=65)
                    
                    self.fr=Frame(self.fmi,bg='#ffe8ec',bd=5,relief='flat',width=338,height=250)
                    self.fr.place(x=420,y=20)
                    self.ff=Frame(self.fr,bg='#adefd1',bd=2,relief='flat',width=140,height=40)
                    self.ff.place(x=80,y=0)
                    self.lb=Label(self.ff,text='ISSUE BOOK',bg='#adefd1',fg='#00203f',font=('Arial',12,'bold'))
                    self.lb.place(x=13,y=5)
                    self.tt=Label(self.fr,text='BOOK ID',bg='#ffe8ec',fg='#00203f',font=('times new roman',11,'bold'))
                    self.tt.place(x=30,y=90)
                    self.e1 = Entry(self.fr, width=30, bd=5, relief='ridge', font=('Arial', 8, 'bold'))
                    self.e1.place(x=130, y=90)
                    
                    self.bt1 = Button(self.fr, text='SUBMIT', width=8, bg='#adefd1', fg='#00203f', font=('Canara', 12,'bold'),bd=5,relief='flat',command=self.data,activeforeground='#adefd1',activebackground='#00203f')
                    self.bt1.place(x=15, y=160)
                else:
                    messagebox.showwarning('Warning','This student is not registered !')
                    self.em2.delete(0,END)
            def issueback(self):
                try:
                    self.boot.destroy()
                    self.cur()
                except Exception as e:
                    self.cur()
            
            repeat=0
            def data(self):
                self.b=self.em2.get()
                cursor=dbstudents.cursor()
                cursor.execute("SELECT * FROM Students WHERE ERP='"+self.b+"'")
                self.var=cursor.fetchone()
                self.flag=0
                
                if(int(self.var[11])>=3):
                    try:
                        self.boot.destroy()
                        messagebox.showerror("Unable to process request","You exceed the limit of Books per student!")
                        self.flag=1
                        self.cur()

                    except Exception as e:
                        messagebox.showerror("Unable to process request","You exceed the limit of Books per student!")
                        self.flag=1
                        self.cur()
                
                self.vva=self.e1.get()
                
                cursor=dbstore.cursor()
                cursor.execute("SELECT * FROM Books WHERE BookID='"+self.vva+"'")
                dbstore.commit()
                self.value=cursor.fetchone()
                if self.value!=None:
                    if(self.flag!=1):
                        self.boot=Tk()
                        self.boot.title("Issue Books")
                        self.boot.iconbitmap("filename.ico")
                        self.boot.configure(bg='#ffe8ec')
                        self.boot.geometry("370x450+880+30")
                        self.boot.resizable(0,0)
                        test.repeat=1
                        
                        self.lb=Label(self.boot,text='Title:',bg='#ffe8ec',fg='black',font=('Calibri',12,'bold'))
                        self.lb.place(x=30,y=30)
                        self.lbn = Label(self.boot, text=self.value[1], bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                        self.lbn.place(x=120,y=30)
                        self.lb = Label(self.boot, text='Author:', bg='#ffe8ec', fg='black', font=('Calibri', 12,'bold'))
                        
                        self.lb.place(x=30, y=60)
                        self.lbn = Label(self.boot, text=self.value[2], bg='#ffe8ec', fg='black', font=('Calibri', 12,'bold'))
                        
                        self.lbn.place(x=120, y=60)
                        self.lb = Label(self.boot, text='Edition:', bg='#ffe8ec', fg='black', font=('Calibri', 12,'bold'))
                        
                        self.lb.place(x=30, y=90)
                        self.lbn = Label(self.boot, text=self.value[3], bg='#ffe8ec', fg='black', font=('Calibri', 12,'bold'))
                        self.lbn.place(x=120, y=90)
                        
                        self.label = Label(self.fr, text='ADD MORE BOOKS ', bg='#ffe8ec', fg='black', font=('times new romman', 11,'bold'))
                        self.label.place(x=15, y=220)
                        
                        self.it1=Radiobutton(self.fr,text='YES',bg='#ffe8ec',variable='radio',value=1,command=self.yes)
                        self.it1.place(x=170,y=220)

                        self.it2 = Radiobutton(self.fr, text='NO',bg='#ffe8ec', variable='radio', value=2,command=self.no)
                        self.it2.place(x=240, y=220)
                        
                        self.button1 = Button(self.boot, text='ISSUE', bg='#adefd1', fg='#00203f', width=10, height=0,font=('Canara', 11, 'bold'), activebackground='#00203f',activeforeground='#adefd1',command=self.issued)
                        self.button1.place(x=30, y=400)

                        self.btn = Button(self.boot, text='SEND MAIL', bg='#adefd1', fg='#00203f', width=10, height=0,font=('Canara', 11, 'bold'),activebackground='#00203f',activeforeground='#adefd1', command=self.mail)
                        self.btn.place(x=160, y=400)
                        
                        self.x = date.today()

                        self.cal = Calendar(self.boot, selectmode="day", bg='black',year=2022,month=3,day=30)
                        self.cal.place(x=20,y=150)
                
                        btn1 = Button(self.boot, text="CONFIRM DATE",command=self.get_data,  bg='#343148',font=('Canara', 11,'bold'),fg='#d7c49e',activebackground='black', activeforeground='#d7c49e', relief='flat')
                        btn1.place(x=90,y=350)
                        
                        self.boot.mainloop()
                else:
                    messagebox.showerror('Book Not Found','No such book exists!')
                    self.e1.delete(0,END)
            
            def get_data(self):
                self.datecon=self.cal.selection_get()
                
            def yes(self):
                self.n=self.n+1
               
                self.bt1 = Button(self.fr, text='SUBMIT', width=8, bg='#adefd1', fg='#00203f', font=('Canara', 12,'bold'),bd=5,relief='flat',command=self.data,activeforeground='#adefd1',activebackground='#00203f',state=ACTIVE)
                self.bt1.place(x=15, y=160)
    
                self.e1.delete(0, END)
                #self.e2.delete(0, END)
                
                self.max=self.max-1
                
            def no(self):
                self.bt1 = Button(self.fr, text='SUBMIT', width=8, bg='#adefd1', fg='#00203f', font=('Canara', 12,'bold'),bd=5,relief='flat',command=self.data,activeforeground='#adefd1',activebackground='#00203f',state=DISABLED)
                self.bt1.place(x=15, y=160)
            
            def issued(self):
                self.datecon=self.cal.selection_get()
               
                self.ac=self.e1.get()
                cursor=dbstore.cursor()
                    
                cursor.execute("UPDATE Books SET Issue='Issued', ID='"+self.b+"' WHERE BookID='"+self.ac+"'")
                dbstore.commit()
                
                if self.n<=3:
                    book=dbstudents.cursor()
                    self.erpid1=self.em2.get()
                    book.execute("SELECT * FROM Students WHERE ERP='"+self.erpid1+"'")
                    self.issuevar=book.fetchone()
                    self.sum=self.issuevar[11]+1
                    book.execute("UPDATE Students SET NoBook='"+str(self.sum)+"' WHERE ERP='"+self.b+"' ")
                    dbstudents.commit()
                
                comm=dbstudents.cursor()
                comm.execute("UPDATE Students SET FromDate='"+str(self.x)+"', ToDate='"+str(self.datecon)+"' , SubmitDate='' WHERE ERP='"+self.b+"'")
                dbstudents.commit()
                
                messagebox.showinfo('Library Management System', 'YOUR BOOK HAS BEEN ISSUED')
                self.boot.destroy()
                self.e1.delete(0, END)
                
            def mail(self):

                self.erpid=self.em2.get()
                cursor=dbstudents.cursor()
                cursor.execute("SELECT * FROM Students WHERE ERP='"+self.erpid+"'")
                self.var=cursor.fetchone()
                sender = "libraryauthority@gmail.com"
                reciever =self.var[5]
                with open("pass.txt",'r') as file:
                        password=file.read()
                message = """FROM: LIBRARY DEPARTMENT
                          TO : Library Issued Books Department
                          Subject: Hello Student! Your book has been Issued"""
                try:
                    server = smtplib.SMTP_SSL("smtp.gmail.com", 465)
                    server.login(sender, password)
                    server.sendmail(sender, reciever, message)
                    print("ok")
                    messagebox.showinfo("Library System","Send mail Successfully !")
                except Exception as e:
                    pass
    
        obissue=test()
        obissue.issue()
    
    def edit(self):
        class editing(main):
            def edbooks(self):
                self.ffm=Frame(root,bg='#ffe8ec',width=900,height=390)
                self.ffm.place(x=0,y=110)
                self.fm1 = Frame(self.ffm, bg='#ffe8ec', width=500, height=200, bd=5, relief='flat')
                self.fm1.place(x=150, y=30)
                self.ed = Frame(self.fm1, bg='#1c1c1b', bd=0, relief='flat', width=160, height=35)
                self.ed.place(x=170,y=0)
                self.lab = Label(self.ed, text='EDIT BOOK DETAILS', bg='#1c1c1b', fg='#ce4a7e', font=('Calibri', 12,'bold'))
                self.lab.place(x=9, y=5)
                self.label3=Label(self.fm1,text='Book ID',bg='#ffe8ec',fg='black',font=('Times New Roman',11,'bold'))
                self.label3.place(x=85,y=65)
                self.entry=Entry(self.fm1,width=30,bd=4,relief='groove',font=('Calibri',8,'bold'))
                self.entry.place(x=188,y=65)
                self.button7 = Button(self.fm1, text='SEARCH', bg='#1c1c1b', fg='#ce4a7e', width=8,font=('Calibri', 12, 'bold'),command=self.searchedit ,relief='flat',activebackground='#ce4a7e',activeforeground='#1c1c1b')
                self.button7.place(x=85,y=125)

                self.backbt = Button(self.ffm, width=60, bg='#ffe8ec',activebackground='#ffe8ec',bd=0, relief='flat', command=self.cur)
                self.backbt.place(x=0, y=0)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2, 2)
                self.backbt.config(image=self.small_log)
                
            def searchedit(self):
                self.datas=self.entry.get()
                cursor=dbstore.cursor()
                cursor.execute("SELECT * FROM Books WHERE BookID = '"+self.datas+"'" )
                dbstore.commit()
                self.val=cursor.fetchone()
                if self.val!=None:
                    self.edcat=Tk()
                    self.edcat.title("Library System")
                    self.edcat.geometry("300x360+600+230")
                    self.edcat.configure(bg='#ffe8ec')
                    self.edcat.iconbitmap("filename.ico")
                    
                    self.fc=Frame(self.edcat,bg='#1c1c1b',width=90,height=30)
                    self.fc.place(x=80,y=10)
                    self.lab=Label(self.fc,bg='#1c1c1b',fg='#ce4a7e',text='EDIT BOOK',font=('Calibri',12,'bold'))
                    self.lab.place(x=3,y=3)
                    
                    self.labid = Label(self.edcat, bg='#ffe8ec', fg='black', text='Book ID:', font=('Calibri', 12,'bold'))
                                                                                            
                    self.labid.place(x=30, y=60)
                    self.labti = Label(self.edcat, bg='#ffe8ec', fg='black', text='Title:', font=('Calibri', 12, 'bold'))
    
                    self.labti.place(x=30, y=100)
                    self.labaut = Label(self.edcat, bg='#ffe8ec', fg='black', text='Author:', font=('Calibri', 12,'bold'))
                                                                                            
                    self.labaut.place(x=30, y=140)
                    self.labed = Label(self.edcat, bg='#ffe8ec', fg='black', text='Edition:', font=('Calibri', 12,'bold'))
                                                                                            
                    self.labed.place(x=30, y=180)
                    self.labpr = Label(self.edcat, bg='#ffe8ec', fg='black', text='Price:', font=('Calibri', 12,'bold'))
                    self.labpr.place(x=30, y=220)
                
                    self.en1=Entry(self.edcat,width=20,bd=4,relief='groove',font=('Times New Roman',9,'bold'))
                    self.en1.place(x=110,y=60)
                    self.en2 = Entry(self.edcat, width=20, bd=4, relief='groove',font=('Times New Roman',9,'bold'))
                    self.en2.place(x=110, y=100)
                    self.en3 = Entry(self.edcat, width=20, bd=4, relief='groove',font=('Times New Roman',9,'bold'))
                    self.en3.place(x=110, y=140)
                    self.en4 = Entry(self.edcat, width=20, bd=4, relief='groove',font=('Times New Roman',9,'bold'))
                    self.en4.place(x=110, y=180)
                    self.en5 = Entry(self.edcat, width=20, bd=4, relief='groove',font=('Times New Roman',9,'bold'))
                    self.en5.place(x=110, y=220)
                    self.butt = Button(self.edcat, text='SUBMIT', bg='#1c1c1b', fg='#ce4a7e', width=8,font=('Calibri', 12, 'bold'),command=self.savedit,relief='flat')
                    self.butt.place(x=30, y=273)
                    
                    self.en1.insert(0, self.val[0])
                    self.en2.insert(0, self.val[1])
                    self.en3.insert(0, self.val[2])
                    self.en4.insert(0, self.val[3])
                    self.en5.insert(0, self.val[4])
                    
                    self.edcat.mainloop()
                else:
                    messagebox.showerror('Invalid Entry',"This Book doesn't exists!")
                    self.entry.delete(0,END)
                    
            def savedit(self):
                self.id = self.en1.get()
                self.ti = self.en2.get()
                self.au = self.en3.get()
                self.ed = self.en4.get()
                self.pi = self.en5.get()
                
                if(self.id and self.ti and self.au and self.ed and self.pi):
                    cursor= dbstore.cursor()
                    cursor.execute("UPDATE Books SET BookID='"+self.id+"', Title='"+self.ti+"',Author='"+self.au+"',Edition='"+self.ed+"',Price='"+self.pi+"' WHERE BookID='"+self.datas+"'")
                    dbstore.commit()
                    messagebox.showinfo('Changes Saved','Data has been updated successfully!')
                    self.edcat.destroy()
                    self.entry.delete(0,END)
                else:
                    messagebox.showerror('Error','Enter Valid Details')
                    self.entry.delete(0,END)
        obj=editing()
        obj.edbooks()
        
    def returnbook(self):
        class retu(main):
            def __init__(self):
            
                self.frame=Frame(root,bd=0,relief='flat',bg='#ffe8ec',width=900,height=390)
                self.frame.place(x=0,y=110)
                self.f1 = Frame(self.frame, bg='#ffe8ec', width=500, height=200, bd=5, relief='flat')
                self.f1.place(x=200, y=15)
                self.ed = Frame(self.f1, bg='#581845', bd=0, relief='flat', width=130, height=35)
                self.ed.place(x=170, y=0)
                self.lac = Label(self.ed, text='RETURN BOOKS ', bg='#581845', fg='#fff', font=('Calibri', 12, 'bold'))
                self.lac.place(x=10, y=5)
                self.label8 = Label(self.f1, text='ERP ID', bg='#ffe8ec', fg='black', font=('Times New Roman', 11, 'bold'))
                self.label8.place(x=85, y=65)
                self.entry4 = Entry(self.f1, width=30, bd=4, relief='groove', font=('Calibri', 8, 'bold'))
                self.entry4.place(x=188, y=65)
                self.button9 = Button(self.f1, text='RETURN', bg='#581845', fg='#fff', width=8, height=0,
                                font=('Calibri', 12, 'bold'),command=self.retbook,activebackground="#000",activeforeground="#581845")
                self.button9.place(x=85, y=120)
                
                self.backbt = Button(self.frame, width=60, bg='#ffe8ec', activebackground='#ffe8ec',bd=0, relief='flat', command=self.cur)
                self.backbt.place(x=0, y=0)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2,2)
                self.backbt.config(image=self.small_log)
            
            def retsucc(self):
                self.entry4.delete(0,END)
                cursor1 = dbstudents.cursor()
                cursor1.execute("UPDATE Students SET FromDate='',ToDate='',Charge='"+str(self.charge)+"' WHERE ERP='"+self.entry+"'")
                dbstudents.commit()
                messagebox.showinfo("Success","Charges Updated and Books Returned Succesfully")
                self.tom.destroy()
                
            def retbook(self):
                self.charge=0
                self.entry=self.entry4.get()
                cursor=dbstudents.cursor()
                cursor.execute("SELECT * FROM Students WHERE ERP='"+self.entry+"'")
                dbstudents.commit()
                self.data=cursor.fetchone()
                if self.data!=None:
                    if(int(self.data[11])>=1):
                        self.get_date = date.today()
                        cursor = dbstudents.cursor()
                        cursor.execute("UPDATE Students SET NoBook = 0, SubmitDate='" + str(self.get_date) + "' WHERE ERP='" + self.entry + "'")
                        dbstudents.commit()
                        
                        cursor=dbstore.cursor()
                        cursor.execute("UPDATE Books SET Issue='', ID='' WHERE ID='"+self.entry+"'")
                        dbstore.commit()        

                        from datetime import datetime
                        
                        cursor=dbstudents.cursor()
                        cursor.execute("SELECT * FROM Students WHERE ERP='"+self.entry+"'")
                        dbstudents.commit()
                        self.var=cursor.fetchone()
                        
                        if self.var!=None:
                            self.a=self.var[8]
                            self.b=self.var[9]
                            formatStr='%Y-%m-%d'
                            delta1=datetime.strptime(self.a,formatStr)
                            delta2=datetime.strptime(self.b, formatStr)
                            delta=delta2-delta1
                            chm=delta.days
                            
                            if chm<=0:
                                messagebox.showinfo("Success","Books returned successfully")
                                self.entry4.delete(0,END)
                            
                            else:
                                self.tom=Tk()
                                self.tom.geometry("300x150+300+258")
                                self.tom.iconbitmap("filename.ico")
                                self.tom.title("Library System")
                                self.tom.resizable(0,0)
                                self.tom.configure(bg="#ffe8ec")

                                self.lb=Label(self.tom,text="Name of Student: ",bg="#ffe8ec",fg="black",font=('Calibri',11,'bold'))
                                self.lb.place(x=5,y=20)
                                self.lb2=Label(self.tom,text=self.var[1],bg="#ffe8ec",fg="black",font=('Calibri',11,'bold'))
                                self.lb2.place(x=130,y=20)
                                
                                self.charge=(5*chm)+int(self.var[10])
                                self.lb3=Label(self.tom,text="Fine Charge: ",bg="#ffe8ec",fg="black",font=('Calibri',11,'bold'))
                                self.lb3.place(x=5,y=55)
                                
                                self.lc2 = Label(self.tom, text=self.charge, bg="#ffe8ec", fg="black", font=('Calibri',11,'bold'))
                                self.lc2.place(x=130, y=55)
                                self.lc3 = Label(self.tom, text='Rs.', bg="#ffe8ec", fg="black",font=('Calibri', 11, 'bold'))
                                self.lc3.place(x=150, y=55)

                                self.tombtn = Button(self.tom,text='SUBMIT', background='#581845',foreground='white',font=('Calibri',12,'bold'),width=8,activebackground='black',activeforeground='#581845',relief='flat',command=self.retsucc)

                                self.tombtn.place(x=5,y=90)
                                
                                self.tom.mainloop()
                            
                            cursor1 = dbstudents.cursor()
                            cursor1.execute("UPDATE Students SET FromDate='',ToDate='',Charge='"+str(self.charge)+"' WHERE ERP='"+self.entry+"'")
                            dbstudents.commit()
                            
                    else:
                        messagebox.showwarning("No Books Found","This student does not have any book issued!")
                        self.entry4.delete(0,END)
                
                else:
                    messagebox.showerror("Invalid ERP ID","This student doesn't exist!")
                    self.entry4.delete(0,END)
            
        object=retu()
            
    def delete(self):
        class dele(main):
            def deletebooks(self):
            
                self.ff = Frame(root, bg='#ffe8ec', width=900, height=390)
                self.ff.place(x=0, y=110)
                self.f1 = Frame(self.ff, bg='#ffe8ec', width=500, height=200, bd=5, relief='flat')
                self.f1.place(x=200, y=15)
                self.ed = Frame(self.f1, bg='#7ea310', bd=0, relief='flat', width=120, height=30)
                self.ed.place(x=150, y=0)
                self.lac = Label(self.ed, text='DELETE BOOKS ', bg='#7ea310', fg='#213502', font=('Calibri', 12,'bold'))
                self.lac.place(x=7, y=3)
                self.label8 = Label(self.f1, text='Book ID', bg='#ffe8ec', fg='black', font=('times new roman', 11, 'bold'))
                self.label8.place(x=85, y=65)
                self.entry4 = Entry(self.f1, width=30, bd=4, relief='groove', font=('Calibri', 8, 'bold'))
                self.entry4.place(x=188, y=65)
                self.button9 = Button(self.f1, text='DELETE', bg='#7ea310', fg='#213502', width=8,font=('Calibri', 12, 'bold'),command=self.deldata,relief='flat',activebackground='black',activeforeground='#7ea310')
                self.button9.place(x=85, y=120)
                
                self.backbt = Button(self.ff,width=60, bg='#ffe8ec',activebackground='#ffe8ec',bd=0, relief='flat', command=self.cur)
                self.backbt.place(x=0, y=0)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2,2)
                self.backbt.config(image=self.small_log)
                
            def deldata(self):
                self.a=self.entry4.get()
                cursor=dbstore.cursor()
                cursorv=dbstore.cursor()
                cursorv.execute("SELECT * FROM BOOKS WHERE BookID='"+self.a+"'")
                dbstore.commit()
                self.validation=cursorv.fetchone()
                
                if(self.validation!=None):
                    cursor.execute("DELETE FROM Books WHERE BookID='"+self.a+"'")
                    dbstore.commit()
                    messagebox.showinfo('Succesful','The book is successfully removed from the store!')
                    self.entry4.delete(0,END)
                else:
                    messagebox.showerror('Invalid Operation','This book does not exist!')
                    self.entry4.delete(0,END)
            
        occ=dele()
        occ.deletebooks()
    
    def search(self):
        class demt(main):
            def delmdata(self):

                self.fc = Frame(root, bg='#ffe8ec', width=900, height=390)
                self.fc.place(x=0, y=110)
                self.fc1 = Frame(self.fc, bg='#ffe8ec', width=500, height=200, bd=5, relief='flat')
                self.fc1.place(x=200, y=15)
                self.edm = Frame(self.fc1, bg='#b76e79', bd=0, relief='flat', width=130, height=35)
                self.edm.place(x=140, y=0)
                self.lac = Label(self.edm, text='SEARCH BOOKS ', bg='#b76e79', fg='#fff', font=('Calibri', 12, 'bold'))
                self.lac.place(x=8, y=5)
                self.label8 = Label(self.fc1, text='Book ID', bg='#ffe8ec', fg='black', font=('Times New Roman', 11, 'bold'))
                self.label8.place(x=85, y=65)
                self.entryl= Entry(self.fc1, width=30, bd=4, relief='groove', font=('Calibri', 8, 'bold'))
                self.entryl.place(x=188, y=65)
                self.butto = Button(self.fc1, text='SEARCH', bg='#b76e79', fg='#fff', width=8,font=('Calibri', 12, 'bold'),command=self.srch,relief='flat',activebackground='black',activeforeground='#b76e79')
                self.butto.place(x=85, y=120)

                self.backbt = Button(self.fc,width=60, bg='#ffe8ec',activebackground='#ffe8ec',bd=0, relief='flat', command=self.cur)
                self.backbt.place(x=0, y=0)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(2, 2)
                self.backbt.config(image=self.small_log)
                
            def srch(self):
                self.emp=self.entryl.get()
                cursor=dbstore.cursor()
                cursor.execute("SELECT * FROM Books WHERE BookID='"+self.emp+"'")
                dbstore.commit()
                self.srval=cursor.fetchone()
                if self.srval!=None:
                    self.top=Tk()
                    self.top.title("Library System")
                    self.top.iconbitmap("filename.ico")
                    self.top.geometry("400x200+335+250")
                    self.top.resizable(0, 0)
                    self.top.configure(bg='#ffe8ec')

                    self.frm=Frame(self.top,bg='#b76e79',width=100,height=35)
                    self.frm.place(x=100,y=10)

                    self.mnlb=Label(self.frm,bg='#b76e79',fg='#fff',text="AVAILABLE",font=('Calibri',12,'bold'))
                    self.mnlb.place(x=9,y=5)

                    self.lb1 = Label(self.top, text='Title: ', bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                    self.lb1.place(x=85,y=70)
                    self.lb2=Label(self.top,text=self.srval[1],bg='#ffe8ec', fg='black',font=('Calibri',12,'bold'))
                    self.lb2.place(x=165,y=70)

                    self.lb3 = Label(self.top, text='Author: ', bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                    self.lb3.place(x=85, y=110)
                    self.lb4 = Label(self.top, text=self.srval[2], bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                    self.lb4.place(x=165, y=110)

                    self.lb5 = Label(self.top, text='Edition: ',bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                    self.lb5.place(x=85, y=150)
                    self.lb6 = Label(self.top, text=self.srval[3], bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))
                    self.lb6.place(x=165, y=150)
                    self.entryl.delete(0,END)
                
                else:
                    messagebox.showwarning('Invalid Data','This book does not exists!')
                    self.entryl.delete(0,END)
        object=demt()
        object.delmdata()
        
    def show(self):
        class test(main):
            def __init__(self):
                self.fc = Frame(root, bg='#ffe8ec', width=900, height=390)
                self.fc.place(x=0, y=110)
                self.popframe=Frame(self.fc,width=180,height=30,bg='#edb40d')
                self.popframe.place(x=360,y=0)
                self.lbn=Label(self.popframe,bg='#edb40d',text='BOOKS INFORMATION',fg='#fff',font=('Calibri',12,'bold'))
                                                                                                
                self.lbn.place(x=8,y=4)

                self.backbt = Button(self.fc,width=30, bg='#ffe8ec',activebackground='#ffe8ec',bd=0, relief='flat', command=self.cur)
                self.backbt.place(x=0, y=0)
                self.log = PhotoImage(file='filename.png')
                self.backbt.config(image=self.log, compound=LEFT)
                self.small_log = self.log.subsample(3, 3)
                self.backbt.config(image=self.small_log)

                self.table_frame=Frame(self.fc,bg='#ffe8ec',bd=1,relief='flat')
                self.table_frame.place(x=0,y=30,width=900,height=360)

                self.scroll_x=Scrollbar(self.table_frame,orient=HORIZONTAL)
                self.scroll_y=Scrollbar(self.table_frame,orient=VERTICAL)
                self.book_table=ttk.Treeview(self.table_frame,columns=("Book ID","Title","Author","Edition","Price"),xscrollcommand=self.scroll_x.set,yscrollcommand=self.scroll_y.set)
                self.scroll_x.pack(side=BOTTOM,fill=X)
                self.scroll_y.pack(side=RIGHT, fill=Y)
                self.scroll_x.config(command=self.book_table.xview)
                self.scroll_y.config(command=self.book_table.yview)
                
                self.book_table.heading("Book ID",text="Book ID")
                self.book_table.heading("Title", text="Title")
                self.book_table.heading("Author", text="Author")
                self.book_table.heading("Edition", text="Edition")
                self.book_table.heading("Price", text="Price")
                self.book_table['show']='headings'
                self.book_table.column("Book ID",width=200)
                self.book_table.column("Title", width=200)
                self.book_table.column("Author", width=200)
                self.book_table.column("Edition", width=120)
                self.book_table.column("Price", width=110)
                self.book_table.pack(fill=BOTH,expand=1)
                self.fetch_data()
            
            def fetch_data(self):
                cursor=dbstore.cursor()
                cursor.execute("SELECT * FROM Books")
                self.rows=cursor.fetchall()
                if len(self.rows)!=0:
                        for self.row in self.rows:
                                self.book_table.insert('',END,values=self.row)
                dbstore.commit()
                
        oc=test()
        
    def mainclear(self):
        self.e1.delete(0,END)
        self.e2.delete(0,END)
        
        
    def code(self):

            self.fm=Frame(root,height=500,width=900,bg='white')
            self.fm.place(x=0,y=0)

            self.canvas=Canvas(self.fm,height=500,width=900,bg='#000000')
            self.canvas.place(x=0,y=0)

            self.photo=PhotoImage(file=r"pathtoimage\filename.png")
            self.canvas.create_image(0,0,image=self.photo,anchor=NW)

            self.fm1=Frame(self.canvas,height=260,width=300,bg='#000000',bd=3,relief='sunken')
            self.fm1.place(x=300,y=120)
            
            self.b1=Label(self.fm1,text='User ID',bg='black',font=('Arial',10,'bold'),fg='white')
            self.b1.place(x=20,y=42)

            self.e1=Entry(self.fm1,width=22,font=('arial',9,'bold'),bd=4,relief='groove')
            self.e1.place(x=100,y=40)

            self.lb2=Label(self.fm1,text='Password',bg='black',font=('Arial',10,'bold'),fg='white')
            self.lb2.place(x=20,y=102)

            self.e2=Entry(self.fm1,width=22,show='*',font=('arial',9,'bold'),bd=4,relief='groove')
            self.e2.place(x=100,y=100)
            
            self.btn1=Button(self.fm1,text='  Login',fg='black',bg='yellow',width=100,font=('Arial',11,'bold'),activebackground='black',activeforeground='yellow',command=self.login,bd=3,relief='flat',cursor='hand2')
            self.btn1.place(x=25,y=160)
            self.logo = PhotoImage(file=r"pathtoimage.png")
            self.btn1.config(image=self.logo, compound=LEFT)
            self.small_logo = self.logo.subsample(1, 1)
            self.btn1.config(image=self.small_logo)


            self.btn2=Button(self.fm1,text='  Clear',fg='black',bg='yellow',width=100,font=('Arial',11,'bold'),activebackground='black',activeforeground='yellow',bd=3,relief='flat',cursor='hand2',command=self.mainclear)
            self.btn2.place(x=155,y=160)
            self.log = PhotoImage(file=r"pathtoimage.png")
            self.btn2.config(image=self.log, compound=LEFT)
            self.small_log = self.log.subsample(1, 1)
            self.btn2.config(image=self.small_log)
            
            self.forgot=Label(self.fm1,text='Forgot Password?',fg='White',bg='#000000',activeforeground='black',font=('cursive',9,'bold'))
            self.forgot.place(x=80,y=220)
            self.forgot.bind("<Button>",self.mouseClick)

            root.mainloop()
            
    def mouseClick(self,event):
        self.rog=Tk()
        self.rog.title("Change password")
        self.rog.geometry("400x300+300+210")
        self.rog.iconbitmap("filename.ico")
        self.rog.resizable(0,0)
        self.rog.configure(bg='#000')

        self.framerog=Frame(self.rog,width=160,height=30,bg="#d6ed17")
        self.framerog.place(x=95,y=15)

        self.label=Label(self.framerog,text="SET NEW PASSWORD",bg='#d6ed17',fg='#606060',font=("Calibri",12,'bold'))
        self.label.place(x=5,y=4)

        self.user=Label(self.rog,text='User ID',bg='#000',fg='white',font=("Times New Roman",11,'bold'))
        self.user.place(x=40,y=95)

        self.user = Label(self.rog, text='New Password',bg='#000', fg='white', font=("Times New Roman", 11, 'bold'))
        self.user.place(x=40, y=170)

        self.ef1 = Entry(self.rog, width=24, font=('Calibri', 8, 'bold'), bd=4, relief='groove')
        self.ef1.place(x=170, y=95)

        self.ef2 = Entry(self.rog, width=24, font=('Calibri', 8, 'bold'), bd=4, relief='groove')
        self.ef2.place(x=170, y=170)

        self.btn1 = Button(self.rog, text='SUBMIT', fg='#606060', bg='#d6ed17', width=8, font=('Calibri', 12, 'bold'),activebackground='black', activeforeground='#d6ed17',bd=3, relief='flat',cursor='hand2',command=self.chan_pas)
        self.btn1.place(x=40, y=240)
        
    def chan_pas(self):
        self.a=self.ef1.get()
        self.b=self.ef2.get()
        import sqlite3
        conn=sqlite3.connect('admin.db')
        cursor=conn.cursor()
        cursor.execute("SELECT * FROM UserLogin WHERE UserID='"+self.a+"'")
        conn.commit()
        self.data=cursor.fetchone()

        if self.data!=None:
                cursor = conn.cursor()
                cursor.execute("UPDATE UserLogin SET Password='" + self.b + "' WHERE UserID='" + self.a + "'")
                conn.commit()
                messagebox.showinfo("SUCCESSFUL","Your Password is changed")
                self.rog.destroy()
        else:
                messagebox.showerror("ERROR", "UserID doesn't exist")
                self.rog.destroy()
                
        self.rog.mainloop()
                                                                                

obj=main()
obj.code()          

Maybe when you look for the first time here, it can be scary but if you are coming from above stepwise, you will understand the whole thing. Now let’s rerun every function wholely,

This is a kind of GUI and database-oriented project. I hope you are pretty clear with the functions and how everything is put to make it a single frame. You can add your own new methods and implementations to make it more util and catchy. Projects like Restaurant Management, Store Management, Mart Management, etc, these kinds of management projects can also be made with this theme and idea.

Hope you like “Library Management System Python Project with source code”.

Also, if you find yourself stuck, StackOverflow always works!

Thank you for scrolling. All the very best.

Thank you for visiting our website, click here for more articles.


Also read:



Keywords-> library management system project in python, library management system project python,
library management system in python, library management system python, python library management system, library management system source code in python, simple library management system in python with source code, library management system project with coding in python, library management system python project, book management system project in python, python project library management system, library management project in python, library management system in python with source code, python code for library management system, library management system using python, library management system project python, library management system project in python with source code pdf, library management system code in python, library management system project source code in python,
python library management system project, library management system project pdf in python, library management system python code, project on library management system in python, python gui projects with database, library management system project, project report on library management system in python, simple library management system project in python, management system project in python, python project for class 12 on library management pdf, library management system project pdf class 12 python, python management system project, library management system database project, library management system in python tkinter, library system in python

Share:
Avatar of ishika dabare

Author: ishika dabare