Projects And Assignments

DIVYANSH PROJECT

Mohammad SarfrajLeave a comment 
import mysql.connector
import tkinter as tk
from tkinter import PhotoImage
from tkinter import messagebox
from PIL import Image, ImageTk
from tkinter import ttk  # for Treeview

def connect_to_db():
    try:
        return mysql.connector.connect(
            host="localhost",
            user="root",
            password="12345678",
            database="register"
        )
    except mysql.connector.Error as err:
        messagebox.showerror("Database Error", f"Error: {err}")
        return None

# Function to create a new user
def create_user(cursor, name, user_id):
    try:
        cursor.execute("INSERT INTO user (name, id) VALUES (%s, %s)", (name, user_id))
        print("User created successfully.")
    except mysql.connector.Error as err:
        messagebox.showerror("Database Error", f"Error: {err}")

# Function to retrieve all user data
def get_all_users(cursor):
    cursor.execute("SELECT * FROM user")
    return cursor.fetchall()

# Function to retrieve a specific user by ID
def get_user(cursor, user_id):
    cursor.execute("SELECT * FROM user WHERE id = %s", (user_id,))
    return cursor.fetchone()

def register_user():
    conn = connect_to_db()
    if conn:
        cursor = conn.cursor()
        username = entry_name.get()
        user_id = entry_id.get()
        
        if username and user_id:
            create_user(cursor, username, user_id)
            conn.commit()
            messagebox.showinfo("Registration", "Registration Successful!")
            cursor.close()
            conn.close()
        else:
            messagebox.showwarning("Input Error", "Please fill all fields")
        conn.close()

def show_specific_record():
    conn = connect_to_db()
    if conn:
        cursor = conn.cursor()
        user_id = entry_specific_id.get()
        if user_id:
            user_data = get_user(cursor, user_id)
            if user_data:
                display_records([user_data])
            else:
                messagebox.showwarning("Not Found", "No record found for the given ID")
            cursor.close()
            conn.close()
        else:
            messagebox.showwarning("Input Error", "Please enter an ID")

def view_user():
    def display_record_options():
        view_window.destroy()
        show_view_options()

    def show_all_records():
        def check_password():
            if entry_password.get() == '12345678':  #PASSCODE
                conn = connect_to_db()
                if conn:
                    cursor = conn.cursor()
                    records = get_all_users(cursor)
                    display_records(records)
                    cursor.close()
                    conn.close()
                password_window.destroy()
            else:
                messagebox.showwarning("Invalid Password", "The password you entered is incorrect")

        # PASSWORD WINDOW SETTING (VIEW ALL RECORD - ENTER PASSWORD)

        password_window = tk.Toplevel(root)
        password_window.title("Enter Password")
        password_window.geometry("300x150")

        img = PhotoImage(file=r"C:\Users\LIVA\Desktop\Image\6521996.png")
        password_window.iconphoto(False, img)

        password_window.resizable(False, False)
        

        tk.Label(password_window, text="Enter Password", bg='lightblue').pack(pady=10)
        entry_password = tk.Entry(password_window, show="*")
        entry_password.pack(pady=5)

        tk.Button(password_window, text="Submit", command=check_password, bg='blue', fg='white').pack(pady=10)

    view_window = tk.Toplevel(root)
    view_window.title("View Records")
    view_window.geometry("400x300")

    img = PhotoImage(file=r"C:\Users\LIVA\Desktop\Image\6521996.png")
    view_window.iconphoto(False, img)

    view_window.resizable(False, False)
    

  
    
    bg_label = tk.Label(view_window, image=bg_photo)
    bg_label.place(relwidth=1, relheight=1)

    tk.Label(view_window, text="Choose an option", bg='lightblue').pack(pady=10)

    all_button = tk.Button(view_window, text="View All Records", command=show_all_records, bg='blue', fg='white')
    all_button.pack(pady=5)

    specific_button = tk.Button(view_window, text="View Specific Record by ID", command=display_record_options, bg='blue', fg='white')
    specific_button.pack(pady=5)

    view_window.mainloop()

def show_view_options():
    option_window = tk.Toplevel(root)
    option_window.title("View Specific Record")
    option_window.geometry("400x300")
    option_window.resizable(False, False)
    
    img = PhotoImage(file=r"C:\Users\LIVA\Desktop\Image\6521996.png")
    option_window.iconphoto(False, img)

    bg_label = tk.Label(option_window, image=bg_photo)
    bg_label.place(relwidth=1, relheight=1)

    tk.Label(option_window, text="Enter ID to View Record", bg='lightblue').pack(pady=10)
    global entry_specific_id
    entry_specific_id = tk.Entry(option_window)
    entry_specific_id.pack(pady=5)

    view_button = tk.Button(option_window, text="SUBMIT", command=show_specific_record, bg='blue', fg='white')
    
    view_button.pack(pady=10)

    option_window.mainloop()

def display_records(records):
    display_window = tk.Toplevel(root)
    display_window.title("Records")
    display_window.geometry("500x400")

    img = PhotoImage(file=r"C:\Users\LIVA\Desktop\Image\6521996.png")
    display_window.iconphoto(False, img)

    bg_label = tk.Label(display_window, image=bg_photo)
    bg_label.place(relwidth=1, relheight=1)

    tree = ttk.Treeview(display_window, columns=("Name", "ID"), show="headings")
    tree.heading("Name", text="Name")
    tree.heading("ID", text="ID")
    tree.pack(fill=tk.BOTH, expand=True)

    for record in records:
        tree.insert("", "end", values=record)

def show_help():
    messagebox.showinfo("Help", "This application allows you to register your Name and ID, and view your record by entering your ID.")

def show_contact():
    messagebox.showinfo("Contact", "For support, please contact: Divyansh@gmail.com")

def exit_app():
    root.destroy()

# Create the main window
root = tk.Tk()
root.title("Registration Form")

img = PhotoImage(file=r"C:\Users\LIVA\Desktop\Image\6521996.png")
root.iconphoto(False, img)

root.resizable(False, False)

root.geometry("600x500")

bg_image = Image.open(r"C:\Users\LIVA\Desktop\Image\GD1.png")
bg_image = bg_image.resize((600, 500))
bg_photo = ImageTk.PhotoImage(bg_image)
bg_label = tk.Label(root, image=bg_photo)
bg_label.place(relwidth=1, relheight=1)

menu_bar = tk.Menu(root)
root.config(menu=menu_bar)

help_menu = tk.Menu(menu_bar, tearoff=0)
help_menu.add_command(label="Help", command=show_help)
menu_bar.add_cascade(label="Help", menu=help_menu)

contact_menu = tk.Menu(menu_bar, tearoff=0)
contact_menu.add_command(label="Contact", command=show_contact)
menu_bar.add_cascade(label="Contact", menu=contact_menu)

view_menu = tk.Menu(menu_bar, tearoff=0)
view_menu.add_command(label="View Records", command=view_user)
menu_bar.add_cascade(label="View Records", menu=view_menu)

exit_menu = tk.Menu(menu_bar, tearoff=0)
exit_menu.add_command(label="Exit", command=exit_app)
menu_bar.add_cascade(label="Exit", menu=exit_menu)

form_frame = tk.Frame(root, bg='lightblue', bd=5)
form_frame.place(relx=0.5, rely=0.3, anchor='center')

view_frame = tk.Frame(root, bg='lightblue', bd=5)
view_frame.place(relx=0.5, rely=0.7, anchor='center')

tk.Label(form_frame, text="Name", bg='lightblue').grid(row=0, column=0, padx=10, pady=5)
entry_name = tk.Entry(form_frame)
entry_name.grid(row=0, column=1, padx=10, pady=5)

tk.Label(form_frame, text="ID", bg='lightblue').grid(row=1, column=0, padx=10, pady=5)
entry_id = tk.Entry(form_frame)
entry_id.grid(row=1, column=1, padx=10, pady=5)

register_button = tk.Button(form_frame, text="Register", command=register_user, bg='blue', fg='white')
register_button.grid(row=2, columnspan=2, pady=10)

view_button = tk.Button(view_frame, text="View Record", command=view_user, bg='blue', fg='white')
view_button.grid(row=1, columnspan=2, pady=9, padx=18)

root.mainloop()

UPDATE 8.2 of Building a Dynamic Cricket Scoreboard with Python Tkinter

Mohammad Sarfraj1 Comment

The two versions, 8.1 and 8.2, of the cricket scoreboard project have some key differences. Here’s a comparative overview:

Version 8.1

  • Score Entry and Display: Score entry is more direct and handled by global variables, which are retrieved and updated based on user input.
  • Player Name Handling: The conversion of player shirt numbers to names is done using simple conditional checks within the scoreboard() function.
  • UI and Score Display: The window and labels are created within the scoreboard() function. This setup means the UI is dynamically generated every time the function is called.
  • Player Swap Logic: The swapping of striker and non-striker is based on conditions within the scoreboard() function, directly checking the last digit of overs or impact of the ball.
  • Data Persistence: The code writes new data to a CSV file after every update.

Version 8.2

  • Data Management: It uses a slightly more modular approach with better-organized data management, leading to cleaner code and less reliance on global variables.
  • Dynamic UI Updates: The second version incorporates dynamic updates within the existing UI, avoiding the need to recreate the entire window, which makes the program more efficient.
  • Improved Player Handling: The player swap logic is refined and more robust, offering better control over the swapping mechanism.
  • Enhanced Flexibility: This version seems to better handle various match scenarios by organizing the logic more effectively and offering a more streamlined UI experience.

Summary

  • Version 8.1 focuses on simplicity with direct score entry and display, whereas Version 8.2 introduces a more polished structure with improved UI updates and better data management.
  • Version 8.2 enhances user experience by offering a more responsive interface and more organized code, making it preferable for more complex and dynamic match scenarios.
from tkinter import *
window1=None
window2=None
window=None
label1=None
label2=None
label3=None
label4=None
label5=None
label6=None
label8=None
label9=None
label10=None
label11=None
label13=None
label14=None
def scoreboard():
    
    
    global scoreshow
    global strikervalue
    striker=strikervalue.get()

    global armvalue
    arm=armvalue.get()
    
    global strikerscorevalue
    strikerscore=strikerscorevalue.get()
    
    global nonstrikervalue
    nonstriker=nonstrikervalue.get()
    
    global nonstrikerscorevalue
    nonstrikerscore=nonstrikerscorevalue.get()
    
    global team1value
    team1=team1value.get()
    
    

    global overvalue
    over=overvalue.get()
    
    global bowlervalue
    bowler=bowlervalue.get()
    
    global bowlerstatsvalue
    bowlerstats=bowlerstatsvalue.get()
    
    global overstatsvalue
    overstats=overstatsvalue.get()
    
    global notevalue
    note=notevalue.get()
    
    global impactvalue
    impact=impactvalue.get()

    global team1scoreteam2value
    team1scoreteam2=team1scoreteam2value.get()
    #scoreshow+=impact
    

    global team2value
    team2=team2value.get()
    
   



    global label1,label2,label3,label4,label5,label6,label8,label9,label10,label11,label13,label14
    listinfo=[striker,strikerscore,nonstriker,nonstrikerscore,team1,
              team1scoreteam2
              ,over,bowler,bowlerstats,
              overstats,note,impact,team2,arm]
    
    if striker=="45":
        striker="ROHIT"
    elif striker=="18":
        striker="VIRAT"
    if nonstriker=="45":
        nonstriker="ROHIT"
    elif nonstriker=="18":
        nonstriker="VIRAT"
    if bowler=="10":
        bowler="SHAHEEN"
    elif bowler=="71":
        bowler="NASEEM"

    n=read()
    if n[13]!=arm:
        
        import csv
        fh=open("scoreinfo.csv","a")
        fo=csv.writer(fh)
        fo.writerow(listinfo)
        fh.close()

        global window1
        global window2
        new=read()
        #print(new)
        #print(new[11])    
        if new[11]=="1" or new[11]=="3" or new[11]=="0" and new[6][-1]=="6":
            k=nonstrikervalue
            p=nonstrikerscorevalue
            nonstrikervalue=strikervalue
            nonstrikerscorevalue=strikerscorevalue
            strikervalue=k
            strikerscorevalue=p
        if window1 is not None: 
            label1.config(text=striker)
            label2.config(text=strikerscore)
            label3.config(text=nonstriker)
            label4.config(text=nonstrikerscore)
            label5.config(text=team1)
            label6.config(text=team1scoreteam2)
            label8.config(text=over)
            label9.config(text="VS "+team2)
            
            label10.config(text=bowler)
            label11.config(text=bowlerstats)        
            label13.config(text=overstats) 
            
           
            label14.config(text=note)
            
                
            
            
        else:
            
                
            
        
            window1=Tk()
            window1.geometry("1300x300")
            window1.config(relief=RIDGE,background="#882626",bd=20,padx=180,pady=50)
            label1=Label(window1,width=10,text=striker,font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9,)
            label1.place(x=0,y=80)
            label2=Label(window1,width=5,text=strikerscore,font=("Arial",22),fg="blue",relief=RIDGE,bd=9,)
            label2.place(x=200,y=80)

            label3=Label(window1,width=10,text=nonstriker,font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9)
            label3.place(x=0,y=130)
            label4=Label(window1,width=5,text=nonstrikerscore,font=("Arial",22),fg="blue",relief=RIDGE,bd=9,)
            label4.place(x=200,y=130)

            label5=Label(window1,width=5,text=team1,font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9)
            label5.place(x=335,y=80)
            label6=Label(window1,width=7,text=team1scoreteam2,font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9,)
            label6.place(x=445,y=80)

            label7=Label(window1,width=5,text="OVER",font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9)
            label7.place(x=335,y=130)
            label8=Label(window1,width=2,text=over,font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9,)
            label8.place(x=445,y=130)
            label9=Label(window1,width=8,height=2,text="VS "+team2,font=("Arial",12),fg="blue",relief=RIDGE,bd=9,)
            label9.place(x=500,y=130)

            label10=Label(window1,width=10,text=bowler,font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9)
        

            label11=Label(window1,width=10,text=bowlerstats,font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9,)
        
            label12=Label(window1,width=10,text="THIS OVER",font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9)
        
            label13=Label(window1,width=10,text=overstats,font=("Arial",22,"bold"),fg="blue",relief=RIDGE,bd=9,)
        

            label10.place(x=620,y=80)
            label11.place(x=821,y=80)
            label12.place(x=620,y=130)
            label13.place(x=821,y=130)
        
            label14=Label(window1,width=35,height=1,text=note,font=("Arial"),fg="blue",relief=RIDGE,bd=9)
            label14.place(x=0,y=35)
    else:
        print("UPDATE PRIMARY KEY......")
            
            

            
            
        

                       
            
        
        
    
        







        
        

        
def read():
    import csv
    fh=open("scoreinfo.csv","r")
    fo=csv.reader(fh)
    fo=list(fo)
    new=fo[-2]
   
    return new
    
    fh.close()


new=read()
strikervalue=new[0]
strikerscorevalue=new[1]
nonstrikervalue=new[2]
nonstrikerscorevalue=new[3]
team1value=new[4]
team1scoreteam2value=new[5]
overvalue=new[6]
bowlervalue=new[7]
bowlerstatsvalue=new[8]
overstatsvalue=new[9]
notevalue=new[10]
impactvalue=new[11]
team2value=new[12]
if new[11]=="1" or new[11]=="3" or new[11]=="0" and new[6][-1]=="6":
        k=nonstrikervalue
        p=nonstrikerscorevalue
        nonstrikervalue=strikervalue
        nonstrikerscorevalue=strikerscorevalue
        strikervalue=k
        strikerscorevalue=p
window=Tk()
window.geometry("1600x500")
window.title("scoreboard info entry")
window.config(background="skyblue",padx=30,pady=50,border=25)
labelstriker=Label(window,width=22,text="STRIKER SHIRT NO.:",font=("Arial",20),bg="black",fg="white",relief=RIDGE,bd=10)
labelstriker.place(x=0,y=10)
strikervalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
strikervalue.insert(0,new[0])
strikervalue.place(x=370,y=10)

labelstrikerscore=Label(window,width=22,text="STRIKER SCORE:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelstrikerscore.place(x=0,y=80)
strikerscorevalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
strikerscorevalue.insert(0,new[1])
strikerscorevalue.place(x=370,y=80)

labelnonstriker=Label(window,width=22,text="NON-STRIKER SHIRT NO.:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelnonstriker.place(x=0,y=160)
nonstrikervalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
nonstrikervalue.insert(0,new[2])
nonstrikervalue.place(x=370,y=160)

labelnonstrikerscore=Label(window,width=22,text="NON-STRIKER SCORE:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelnonstrikerscore.place(x=0,y=240)
nonstrikerscorevalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
nonstrikerscorevalue.insert(0,new[3])
nonstrikerscorevalue.place(x=370,y=240)

labelteam1=Label(window,width=22,text="BATTING TEAM NAME:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelteam1.place(x=0,y=320)
team1value=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
team1value.insert(0,new[4])
team1value.place(x=370,y=320)

labelteam2=Label(window,width=22,text="BOWLING TEAM NAME:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelteam2.place(x=0,y=400)
team2value=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
team2value.insert(0,new[12])
team2value.place(x=370,y=400)

labelimpact=Label(window,width=22,text="IMPACT OF BALL BOLWED:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelimpact.place(x=0,y=480)
impactvalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
impactvalue.insert(0,new[11])
impactvalue.place(x=370,y=480)

labelteam1score=Label(window,width=23,text="BATTING TEAM SCORE:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelteam1score.place(x=720,y=10)
team1scoreteam2value=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
team1scoreteam2value.insert(0,new[5])
team1scoreteam2value.place(x=1110,y=10)

labelover=Label(window,width=23,text="OVER     :",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelover.place(x=720,y=80)
overvalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
overvalue.insert(0,new[6])
overvalue.place(x=1110,y=80)

labelbowler=Label(window,width=23,text="BOWLER SHIRT NO.:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelbowler.place(x=720,y=160)
bowlervalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
bowlervalue.insert(0,new[7])
bowlervalue.place(x=1110,y=160)

labelbowlerstats=Label(window,width=23,text="BOWLER STATS:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelbowlerstats.place(x=720,y=240)
bowlerstatsvalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
bowlerstatsvalue.insert(0,new[8])
bowlerstatsvalue.place(x=1110,y=240)

labeloverstats=Label(window,width=23,text="OVER STATS:",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labeloverstats.place(x=720,y=320)
overstatsvalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
overstatsvalue.insert(0,new[9])
overstatsvalue.place(x=1110,y=320)

labelnote=Label(window,width=23,text="NOTE::",font=("Arial",20),fg="white",bg="black",relief=RIDGE,bd=10)
labelnote.place(x=720,y=400)
notevalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
notevalue.insert(0,new[10])
notevalue.place(x=1110,y=400)

labelarm=Label(window,width=23,text="ARMVALUE::",font=("Arial",20,"bold"),fg="RED",bg="black",relief=RIDGE,bd=10)
labelarm.place(x=720,y=480)
armvalue=Entry(window,font=("Arial",20),fg="white",bg="red",bd=10,relief=RIDGE)
armvalue.insert(0,new[13])
armvalue.place(x=1110,y=480)


submit_button=Button(window,text="Submit",command=scoreboard,font=("Arial",30,"bold"),bd=20,relief=RIDGE)
submit_button.place(x=550,y=560)

Library Management System

Mohammad SarfrajLeave a comment


### Building a Library Management System with Python and Tkinter

In this blog post, I’ll walk you through a project I recently completed—a Library Management System built using Python and the Tkinter library. This system is designed to manage library records efficiently, allowing users to add, view, and organize information related to library members and books.

#### Project Overview

The Library Management System features a user-friendly interface where admins can manage all aspects of library records. It includes fields for member details like name, address, and contact information, as well as book-specific data such as title, author, and borrow/return dates.

#### Key Features

– **Data Entry:** Users can easily add new members and books to the system. Each entry is stored securely in a MySQL database, ensuring data integrity and easy retrieval.
– **Data Management:** The system fetches data from the database and displays it in a clean, tabular format using the Tkinter Treeview widget. This makes it simple to browse through records.
– **User Interaction:** The system provides feedback through various message boxes, ensuring that users are always informed of successful operations or potential errors.
– **Exit Prompt:** A user-friendly exit prompt is included to confirm if the user really wants to close the application, adding a layer of protection against accidental data loss.

#### Technical Details

– **Backend:** MySQL database is used to store and manage the data. Python’s `pymysql` library handles database connections and operations.
– **Frontend:** The Tkinter library is utilized for the graphical user interface (GUI). The interface is designed to be simple yet effective, with responsive buttons and well-organized entry fields.
– **Code Structure:** The code is structured into a class, making it easy to manage different components of the application and ensuring that the application is scalable for future enhancements.

#### Conclusion

This project was a great learning experience in combining Python’s capabilities with database management and GUI design. Whether you’re a student, an educator, or just someone interested in software development, building a project like this can significantly enhance your coding skills.

Stay tuned for more updates and enhancements to this project. Feel free to share your thoughts or suggestions in the comments below!

—

from tkinter import *
from tkinter import ttk, messagebox
import pymysql as py
 
class LibraryManagementSystem:
    def __init__(self, root):
        self.root = root
        self.root.title(“Library Management System”)
        self.root.geometry(“1400×700+0+0”)
        self.member_var = StringVar()
        self.prn_var = StringVar()
        self.id_var = StringVar()
        self.firstname_var = StringVar()
        self.lastname_var = StringVar()
        self.address1_var = StringVar()
        self.address2_var = StringVar()
        self.postcode_var = StringVar()
        self.mobile_var = StringVar()
        self.bookid_var = StringVar()
        self.booktitle_var = StringVar()
        self.auther_var = StringVar()
        self.dateborrowed_var = StringVar()
        self.datedue_var = StringVar()
        self.daysonbook = StringVar()
        self.lateratefine_var = StringVar()
        self.dateoverdue = StringVar()
        self.finallprice = StringVar()
 
        lbltitle = Label(self.root, text=”LIBRARY MANAGEMENT SYSTEM”, bg=”powder blue”, fg=”green”, bd=20, relief=”ridge”, font=(“Times New Roman”, 50, “bold”), padx=2, pady=6)
        lbltitle.pack(side=TOP, fill=X)
        frame = Frame(self.root, bd=12, relief=”ridge”, padx=20, bg=”powder blue”)
        frame.place(x=0, y=130, width=1365, height=340)
 
        # DATA FRAME LEFT
        DataFrameLeft = LabelFrame(frame, text=”LIBRARY MEMBERSHIP INFORMATION”, bg=”powder blue”, fg=”green”, bd=12, relief=”ridge”, font=(“Times New Roman”, 12, “bold”))
        DataFrameLeft.place(x=0, y=5, width=1305, height=300)
 
        lblmember = Label(DataFrameLeft, bg=”powder blue”, text=”MEMBER TYPE”, font=(“Times New Roman”, 15, “bold”), padx=2, pady=6)
        lblmember.grid(row=0, column=0, sticky=W)
        comMember = ttk.Combobox(DataFrameLeft, font=(“Times New Roman”, 15, “bold”), width=30, textvariable=self.member_var, state=”readonly”)
        comMember[“value”] = (“ADMIN STAFF”, “STUDENT”, “LECTURER”)
        comMember.current(0)
        comMember.grid(row=0, column=1)
 
        lblPRN_no = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”PRN NO.”, padx=2, pady=2, bg=”powder blue”)
        lblPRN_no.grid(row=1, column=0, sticky=W)
        textPRN_no = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.prn_var, width=35)
        textPRN_no.grid(row=1, column=1)
 
        lblTitle = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”ID NO.”, padx=2, pady=2, bg=”powder blue”)
        lblTitle.grid(row=2, column=0, sticky=W)
        textTitle = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.id_var, width=35)
        textTitle.grid(row=2, column=1)
 
        lblFirstName = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”First Name”, padx=2, pady=2, bg=”powder blue”)
        lblFirstName.grid(row=3, column=0, sticky=W)
        textFirstName = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.firstname_var, width=35)
        textFirstName.grid(row=3, column=1)
 
        lblLastName = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Last Name”, padx=2, pady=2, bg=”powder blue”)
        lblLastName.grid(row=4, column=0, sticky=W)
        textLastName = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.lastname_var, width=35)
        textLastName.grid(row=4, column=1)
 
        lblAddress1 = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Address 1″, padx=2, pady=2, bg=”powder blue”)
        lblAddress1.grid(row=5, column=0, sticky=W)
        textAddress1 = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.address1_var, width=35)
        textAddress1.grid(row=5, column=1)
 
        lblAddress2 = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Address 2″, padx=2, pady=2, bg=”powder blue”)
        lblAddress2.grid(row=6, column=0, sticky=W)
        textAddress2 = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.address2_var, width=35)
        textAddress2.grid(row=6, column=1)
 
        lblPostcode = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=” Post Code”, padx=2, pady=2, bg=”powder blue”)
        lblPostcode.grid(row=7, column=0, sticky=W)
        textPostcode = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.postcode_var, width=35)
        textPostcode.grid(row=7, column=1)
 
        lblMobile = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=” Mobile No.”, padx=2, pady=2, bg=”powder blue”)
        lblMobile.grid(row=8, column=0, sticky=W)
        textMobile = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.mobile_var, width=35)
        textMobile.grid(row=8, column=1)
 
        lblBookid = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Book Id.”, padx=70, pady=2, bg=”powder blue”)
        lblBookid.grid(row=0, column=2, sticky=W)
        textBookid = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.bookid_var, width=35)
        textBookid.grid(row=0, column=3)
 
        lblBooktitle = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Book Title”, padx=70, pady=2, bg=”powder blue”)
        lblBooktitle.grid(row=1, column=2, sticky=W)
        textBooktitle = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.booktitle_var, width=35)
        textBooktitle.grid(row=1, column=3)
 
        lblAuther = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Auther Name”, padx=70, pady=2, bg=”powder blue”)
        lblAuther.grid(row=2, column=2, sticky=W)
        textAuther = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.auther_var, width=35)
        textAuther.grid(row=2, column=3)
 
        lblDateBorrowed = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Date Borrowed “, padx=70, pady=2, bg=”powder blue”)
        lblDateBorrowed.grid(row=3, column=2, sticky=W)
        textDateBorrowed = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.dateborrowed_var, width=35)
        textDateBorrowed.grid(row=3, column=3)
 
        lblDateDue = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Date Due: “, padx=70, pady=2, bg=”powder blue”)
        lblDateDue.grid(row=4, column=2, sticky=W)
        textDateDue = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.datedue_var, width=35)
        textDateDue.grid(row=4, column=3)
 
        lblDaysonBook = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Days on Book”, padx=70, pady=2, bg=”powder blue”)
        lblDaysonBook.grid(row=5, column=2, sticky=W)
        textDaysonBook = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.daysonbook, width=35)
        textDaysonBook.grid(row=5, column=3)
 
        lbllateretuenfine = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Late Return Fine”, padx=70, pady=2, bg=”powder blue”)
        lbllateretuenfine.grid(row=6, column=2, sticky=W)
        textlateretuenfine = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.lateratefine_var, width=35)
        textlateretuenfine.grid(row=6, column=3)
 
        lblDateoverDate = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Date over Date”, padx=70, pady=2, bg=”powder blue”)
        lblDateoverDate.grid(row=7, column=2, sticky=W)
        textDateoverDate = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.dateoverdue, width=35)
        textDateoverDate.grid(row=7, column=3)
 
        lblActualPrice = Label(DataFrameLeft, font=(“arial”, 12, “bold”), text=”Actual Price”, padx=70, pady=2, bg=”powder blue”)
        lblActualPrice.grid(row=8, column=2, sticky=W)
        textActualPrice = Entry(DataFrameLeft, font=(“arial”, 13, “bold”), textvariable=self.finallprice, width=35)
        textActualPrice.grid(row=8, column=3)
 
        # BUTTONS
        Framebutton = Frame(self.root, bd=12, relief=”ridge”, padx=20, bg=”powder blue”)
        Framebutton.place(x=0, y=470, width=1365, height=60)
 
        btnAddData = Button(Framebutton, command=self.add_data, text=”Add Data”, font=(“arial”, 12, “bold”), width=70, bg=”blue”, fg=”white”)
        btnAddData.grid(row=0, column=0)
 
        btnExit = Button(Framebutton, command=self.exit_app, text=”Exit”, font=(“arial”, 12, “bold”), width=50, bg=”blue”, fg=”white”)
        btnExit.grid(row=0, column=1)
 
        # INFORMATION FRAME
        FrameDetails = Frame(self.root, bd=12, relief=”ridge”, padx=20, bg=”powder blue”)
        FrameDetails.place(x=0, y=530, width=1365, height=161)
 
        Table_frame = Frame(FrameDetails, bd=6, relief=”ridge”, bg=”powderblue”)
        Table_frame.place(x=0, y=2, width=1310, height=131)
        xscroll = Scrollbar(Table_frame, orient=HORIZONTAL)
        yscroll = Scrollbar(Table_frame, orient=VERTICAL)
 
        self.Library_table = ttk.Treeview(Table_frame, column=(“Member Type”, “PRN No.”, “ID No.”, “First Name”, “Last Name”, “Address 1”, “Address 2”, “Post Code”, “Mobile No.”, “Book Id.”, “Book Title”, “Author Name”, “Date Borrowed”, “Date Due”, “Days on Book”, “Late Return Fine”, “Date Overdue”, “Actual Price”),
        xscrollcommand=xscroll.set, yscrollcommand=yscroll.set)
 
        xscroll.pack(side=BOTTOM, fill=X)
        yscroll.pack(side=RIGHT, fill=Y)
 
        xscroll.config(command=self.Library_table.xview)
        yscroll.config(command=self.Library_table.yview)
 
        self.Library_table.heading(“Member Type”, text=”Member Type”)
        self.Library_table.heading(“PRN No.”, text=”PRN No.”)
        self.Library_table.heading(“ID No.”, text=”ID No.”)
        self.Library_table.heading(“First Name”, text=”First Name”)
        self.Library_table.heading(“Last Name”, text=”Last Name”)
        self.Library_table.heading(“Address 1″, text=”Address 1”)
        self.Library_table.heading(“Address 2″, text=”Address 2”)
        self.Library_table.heading(“Post Code”, text=”Post Code”)
        self.Library_table.heading(“Mobile No.”, text=”Mobile No.”)
        self.Library_table.heading(“Book Id.”, text=”Book Id.”)
        self.Library_table.heading(“Book Title”, text=”Book Title”)
        self.Library_table.heading(“Author Name”, text=”Author Name”)
        self.Library_table.heading(“Date Borrowed”, text=”Date Borrowed”)
        self.Library_table.heading(“Date Due”, text=”Date Due”)
        self.Library_table.heading(“Days on Book”, text=”Days on Book”)
        self.Library_table.heading(“Late Return Fine”, text=”Late Return Fine”)
        self.Library_table.heading(“Date Overdue”, text=”Date Overdue”)
        self.Library_table.heading(“Actual Price”, text=”Actual Price”)
 
        self.Library_table[‘show’] = ‘headings’
 
        self.Library_table.column(“Member Type”, width=90)
        self.Library_table.column(“PRN No.”, width=90)
        self.Library_table.column(“ID No.”, width=90)
        self.Library_table.column(“First Name”, width=90)
        self.Library_table.column(“Last Name”, width=90)
        self.Library_table.column(“Address 1”, width=90)
        self.Library_table.column(“Address 2”, width=90)
        self.Library_table.column(“Post Code”, width=90)
        self.Library_table.column(“Mobile No.”, width=90)
        self.Library_table.column(“Book Id.”, width=90)
        self.Library_table.column(“Book Title”, width=90)
        self.Library_table.column(“Author Name”, width=90)
        self.Library_table.column(“Date Borrowed”, width=90)
        self.Library_table.column(“Date Due”, width=90)
        self.Library_table.column(“Days on Book”, width=90)
        self.Library_table.column(“Late Return Fine”, width=90)
        self.Library_table.column(“Date Overdue”, width=90)
        self.Library_table.column(“Actual Price”, width=90)
        self.fetch_data()
        self.Library_table.pack(fill=BOTH, expand=1)
        
        
    
    def add_data(self):
        conn = py.connect(host=”localhost”, user=”root”, password=”LFCOMP@105″, database=”librarymanagementsystem”)
        my_cursor = conn.cursor()
        try:
                query = “INSERT INTO newlibrary VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)”
                values = (
                    self.member_var.get(), self.prn_var.get(), self.id_var.get(), self.firstname_var.get(),
                    self.lastname_var.get(), self.address1_var.get(), self.address2_var.get(),
                    self.postcode_var.get(), self.mobile_var.get(), self.bookid_var.get(), self.booktitle_var.get(),
                    self.auther_var.get(), self.dateborrowed_var.get(), self.datedue_var.get(),
                    self.daysonbook.get(), self.lateratefine_var.get(), self.dateoverdue.get(), self.finallprice.get()
                )
                my_cursor.execute(query, values)
                # Commit the changes to the database
                conn.commit()
                print(“Record inserted successfully!”)
                self.fetch_data()
        except Exception as e:
            # Handle any exceptions that may occur during the execution
            print(f”Error: {e}”)
            # Rollback the changes in case of an error
            conn.rollback()
        finally:
            # Close the database connection
            conn.close()
        messagebox.showinfo(“Success”, “Data has been added successfully!”)
   
    def fetch_data(self):
        conn = py.connect(host=”localhost”, user=”root”, password=”LFCOMP@105″, database=”librarymanagementsystem”)
        my_cursor = conn.cursor()
        my_cursor.execute(“select  * from newlibrary”)
        rows = my_cursor.fetchall()
        if len(rows) != 0:
            self.Library_table.delete(*self.Library_table.get_children())
            for i in rows:
                self.Library_table.insert(“”, END, values=i)
            conn.commit()
        conn.close           
 
    def exit_app(self):
        exit_prompt = messagebox.askyesno(“Library Management System”, “Do you want to exit?”)
        if exit_prompt > 0:
            self.root.destroy()
    
 
 
if __name__ == “__main__”:
    root = Tk()
    obj = LibraryManagementSystem(root)
    root.mainloop()

CLASS 11 LIBRARY MANAGEMENT SYSTEM

Mohammad SarfrajLeave a comment 
from tkinter import *
from tkinter import ttk, messagebox
import pymysql as py
 
class LibraryManagementSystem:
    def __init__(self, root):
        self.root = root
        self.root.title("Library Management System")
        self.root.geometry("1400x700+0+0")
        self.member_var = StringVar()
        self.prn_var = StringVar()
        self.id_var = StringVar()
        self.firstname_var = StringVar()
        self.lastname_var = StringVar()
        self.address1_var = StringVar()
        self.address2_var = StringVar()
        self.postcode_var = StringVar()
        self.mobile_var = StringVar()
        self.bookid_var = StringVar()
        self.booktitle_var = StringVar()
        self.auther_var = StringVar()
        self.dateborrowed_var = StringVar()
        self.datedue_var = StringVar()
        self.daysonbook = StringVar()
        self.lateratefine_var = StringVar()
        self.dateoverdue = StringVar()
        self.finallprice = StringVar()
 
        lbltitle = Label(self.root, text="LIBRARY MANAGEMENT SYSTEM", bg="powder blue", fg="green", bd=20, relief="ridge", font=("Times New Roman", 50, "bold"), padx=2, pady=6)
        lbltitle.pack(side=TOP, fill=X)
        frame = Frame(self.root, bd=12, relief="ridge", padx=20, bg="powder blue")
        frame.place(x=0, y=130, width=1365, height=340)
 
        # DATA FRAME LEFT
        DataFrameLeft = LabelFrame(frame, text="LIBRARY MEMBERSHIP INFORMATION", bg="powder blue", fg="green", bd=12, relief="ridge", font=("Times New Roman", 12, "bold"))
        DataFrameLeft.place(x=0, y=5, width=1305, height=300)
 
        lblmember = Label(DataFrameLeft, bg="powder blue", text="MEMBER TYPE", font=("Times New Roman", 15, "bold"), padx=2, pady=6)
        lblmember.grid(row=0, column=0, sticky=W)
        comMember = ttk.Combobox(DataFrameLeft, font=("Times New Roman", 15, "bold"), width=30, textvariable=self.member_var, state="readonly")
        comMember["value"] = ("ADMIN STAFF", "STUDENT", "LECTURER")
        comMember.current(0)
        comMember.grid(row=0, column=1)
 
        lblPRN_no = Label(DataFrameLeft, font=("arial", 12, "bold"), text="PRN NO.", padx=2, pady=2, bg="powder blue")
        lblPRN_no.grid(row=1, column=0, sticky=W)
        textPRN_no = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.prn_var, width=35)
        textPRN_no.grid(row=1, column=1)
 
        lblTitle = Label(DataFrameLeft, font=("arial", 12, "bold"), text="ID NO.", padx=2, pady=2, bg="powder blue")
        lblTitle.grid(row=2, column=0, sticky=W)
        textTitle = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.id_var, width=35)
        textTitle.grid(row=2, column=1)
 
        lblFirstName = Label(DataFrameLeft, font=("arial", 12, "bold"), text="First Name", padx=2, pady=2, bg="powder blue")
        lblFirstName.grid(row=3, column=0, sticky=W)
        textFirstName = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.firstname_var, width=35)
        textFirstName.grid(row=3, column=1)
 
        lblLastName = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Last Name", padx=2, pady=2, bg="powder blue")
        lblLastName.grid(row=4, column=0, sticky=W)
        textLastName = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.lastname_var, width=35)
        textLastName.grid(row=4, column=1)
 
        lblAddress1 = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Address 1", padx=2, pady=2, bg="powder blue")
        lblAddress1.grid(row=5, column=0, sticky=W)
        textAddress1 = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.address1_var, width=35)
        textAddress1.grid(row=5, column=1)
 
        lblAddress2 = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Address 2", padx=2, pady=2, bg="powder blue")
        lblAddress2.grid(row=6, column=0, sticky=W)
        textAddress2 = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.address2_var, width=35)
        textAddress2.grid(row=6, column=1)
 
        lblPostcode = Label(DataFrameLeft, font=("arial", 12, "bold"), text=" Post Code", padx=2, pady=2, bg="powder blue")
        lblPostcode.grid(row=7, column=0, sticky=W)
        textPostcode = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.postcode_var, width=35)
        textPostcode.grid(row=7, column=1)
 
        lblMobile = Label(DataFrameLeft, font=("arial", 12, "bold"), text=" Mobile No.", padx=2, pady=2, bg="powder blue")
        lblMobile.grid(row=8, column=0, sticky=W)
        textMobile = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.mobile_var, width=35)
        textMobile.grid(row=8, column=1)
 
        lblBookid = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Book Id.", padx=70, pady=2, bg="powder blue")
        lblBookid.grid(row=0, column=2, sticky=W)
        textBookid = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.bookid_var, width=35)
        textBookid.grid(row=0, column=3)
 
        lblBooktitle = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Book Title", padx=70, pady=2, bg="powder blue")
        lblBooktitle.grid(row=1, column=2, sticky=W)
        textBooktitle = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.booktitle_var, width=35)
        textBooktitle.grid(row=1, column=3)
 
        lblAuther = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Auther Name", padx=70, pady=2, bg="powder blue")
        lblAuther.grid(row=2, column=2, sticky=W)
        textAuther = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.auther_var, width=35)
        textAuther.grid(row=2, column=3)
 
        lblDateBorrowed = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Date Borrowed ", padx=70, pady=2, bg="powder blue")
        lblDateBorrowed.grid(row=3, column=2, sticky=W)
        textDateBorrowed = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.dateborrowed_var, width=35)
        textDateBorrowed.grid(row=3, column=3)
 
        lblDateDue = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Date Due: ", padx=70, pady=2, bg="powder blue")
        lblDateDue.grid(row=4, column=2, sticky=W)
        textDateDue = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.datedue_var, width=35)
        textDateDue.grid(row=4, column=3)
 
        lblDaysonBook = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Days on Book", padx=70, pady=2, bg="powder blue")
        lblDaysonBook.grid(row=5, column=2, sticky=W)
        textDaysonBook = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.daysonbook, width=35)
        textDaysonBook.grid(row=5, column=3)
 
        lbllateretuenfine = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Late Return Fine", padx=70, pady=2, bg="powder blue")
        lbllateretuenfine.grid(row=6, column=2, sticky=W)
        textlateretuenfine = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.lateratefine_var, width=35)
        textlateretuenfine.grid(row=6, column=3)
 
        lblDateoverDate = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Date over Date", padx=70, pady=2, bg="powder blue")
        lblDateoverDate.grid(row=7, column=2, sticky=W)
        textDateoverDate = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.dateoverdue, width=35)
        textDateoverDate.grid(row=7, column=3)
 
        lblActualPrice = Label(DataFrameLeft, font=("arial", 12, "bold"), text="Actual Price", padx=70, pady=2, bg="powder blue")
        lblActualPrice.grid(row=8, column=2, sticky=W)
        textActualPrice = Entry(DataFrameLeft, font=("arial", 13, "bold"), textvariable=self.finallprice, width=35)
        textActualPrice.grid(row=8, column=3)
 
        # BUTTONS
        Framebutton = Frame(self.root, bd=12, relief="ridge", padx=20, bg="powder blue")
        Framebutton.place(x=0, y=470, width=1365, height=60)
 
        btnAddData = Button(Framebutton, command=self.add_data, text="Add Data", font=("arial", 12, "bold"), width=70, bg="blue", fg="white")
        btnAddData.grid(row=0, column=0)
 
        btnExit = Button(Framebutton, command=self.exit_app, text="Exit", font=("arial", 12, "bold"), width=50, bg="blue", fg="white")
        btnExit.grid(row=0, column=1)
 
        # INFORMATION FRAME
        FrameDetails = Frame(self.root, bd=12, relief="ridge", padx=20, bg="powder blue")
        FrameDetails.place(x=0, y=530, width=1365, height=161)
 
        Table_frame = Frame(FrameDetails, bd=6, relief="ridge", bg="powderblue")
        Table_frame.place(x=0, y=2, width=1310, height=131)
        xscroll = Scrollbar(Table_frame, orient=HORIZONTAL)
        yscroll = Scrollbar(Table_frame, orient=VERTICAL)
 
        self.Library_table = ttk.Treeview(Table_frame, column=("Member Type", "PRN No.", "ID No.", "First Name", "Last Name", "Address 1", "Address 2", "Post Code", "Mobile No.", "Book Id.", "Book Title", "Author Name", "Date Borrowed", "Date Due", "Days on Book", "Late Return Fine", "Date Overdue", "Actual Price"),
        xscrollcommand=xscroll.set, yscrollcommand=yscroll.set)
 
        xscroll.pack(side=BOTTOM, fill=X)
        yscroll.pack(side=RIGHT, fill=Y)
 
        xscroll.config(command=self.Library_table.xview)
        yscroll.config(command=self.Library_table.yview)
 
        self.Library_table.heading("Member Type", text="Member Type")
        self.Library_table.heading("PRN No.", text="PRN No.")
        self.Library_table.heading("ID No.", text="ID No.")
        self.Library_table.heading("First Name", text="First Name")
        self.Library_table.heading("Last Name", text="Last Name")
        self.Library_table.heading("Address 1", text="Address 1")
        self.Library_table.heading("Address 2", text="Address 2")
        self.Library_table.heading("Post Code", text="Post Code")
        self.Library_table.heading("Mobile No.", text="Mobile No.")
        self.Library_table.heading("Book Id.", text="Book Id.")
        self.Library_table.heading("Book Title", text="Book Title")
        self.Library_table.heading("Author Name", text="Author Name")
        self.Library_table.heading("Date Borrowed", text="Date Borrowed")
        self.Library_table.heading("Date Due", text="Date Due")
        self.Library_table.heading("Days on Book", text="Days on Book")
        self.Library_table.heading("Late Return Fine", text="Late Return Fine")
        self.Library_table.heading("Date Overdue", text="Date Overdue")
        self.Library_table.heading("Actual Price", text="Actual Price")
 
        self.Library_table['show'] = 'headings'
 
        self.Library_table.column("Member Type", width=90)
        self.Library_table.column("PRN No.", width=90)
        self.Library_table.column("ID No.", width=90)
        self.Library_table.column("First Name", width=90)
        self.Library_table.column("Last Name", width=90)
        self.Library_table.column("Address 1", width=90)
        self.Library_table.column("Address 2", width=90)
        self.Library_table.column("Post Code", width=90)
        self.Library_table.column("Mobile No.", width=90)
        self.Library_table.column("Book Id.", width=90)
        self.Library_table.column("Book Title", width=90)
        self.Library_table.column("Author Name", width=90)
        self.Library_table.column("Date Borrowed", width=90)
        self.Library_table.column("Date Due", width=90)
        self.Library_table.column("Days on Book", width=90)
        self.Library_table.column("Late Return Fine", width=90)
        self.Library_table.column("Date Overdue", width=90)
        self.Library_table.column("Actual Price", width=90)
        self.fetch_data()
        self.Library_table.pack(fill=BOTH, expand=1)
        
        
    
    def add_data(self):
        conn = py.connect(host="localhost", user="root", password="LFCOMP@105", database="librarymanagementsystem")
        my_cursor = conn.cursor()
        try:
                query = "INSERT INTO newlibrary VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
                values = (
                    self.member_var.get(), self.prn_var.get(), self.id_var.get(), self.firstname_var.get(),
                    self.lastname_var.get(), self.address1_var.get(), self.address2_var.get(),
                    self.postcode_var.get(), self.mobile_var.get(), self.bookid_var.get(), self.booktitle_var.get(),
                    self.auther_var.get(), self.dateborrowed_var.get(), self.datedue_var.get(),
                    self.daysonbook.get(), self.lateratefine_var.get(), self.dateoverdue.get(), self.finallprice.get()
                )
                my_cursor.execute(query, values)
                # Commit the changes to the database
                conn.commit()
                print("Record inserted successfully!")
                self.fetch_data()
        except Exception as e:
            # Handle any exceptions that may occur during the execution
            print(f"Error: {e}")
            # Rollback the changes in case of an error
            conn.rollback()
        finally:
            # Close the database connection
            conn.close()
        messagebox.showinfo("Success", "Data has been added successfully!")
   
    def fetch_data(self):
        conn = py.connect(host="localhost", user="root", password="LFCOMP@105", database="librarymanagementsystem")
        my_cursor = conn.cursor()
        my_cursor.execute("select  * from newlibrary")
        rows = my_cursor.fetchall()
        if len(rows) != 0:
            self.Library_table.delete(*self.Library_table.get_children())
            for i in rows:
                self.Library_table.insert("", END, values=i)
            conn.commit()
        conn.close            
 
    def exit_app(self):
        exit_prompt = messagebox.askyesno("Library Management System", "Do you want to exit?")
        if exit_prompt > 0:
            self.root.destroy()
    
 
 
if __name__ == "__main__":
    root = Tk()
    obj = LibraryManagementSystem(root)
    root.mainloop()