main.py
from tkinter import *
from search_book import *
from delete_book import *
from checkout_book import *
from add_book import add_book
root = Tk()
root.geometry("900x900")
root.title("Library Managment System")
##photo = PhotoImage(file = "imgs/book.png")
##root.iconphoto(False, photo)
top_label = Canvas(width=500, height=100, bg="Black", )
top_label.pack()
top_label.create_text(190,40,fill="white",font="Times 20 italic bold", text="Library Management System by Timware")
add_book_btn = Button(text="ADD A BOOK", width=50, height=5, bg="black", font="Courier 16", foreground="White", command=add_book(None))
add_book_btn.pack()
del_book_btn = Button(text="DELETE A BOOK", width=50, height=5, bg="black", font="Courier 16", foreground="White")
del_book_btn.pack()
search_book_btn = Button(text="SEARCH FOR A BOOK", width=50, height=5, bg="black", font="Courier 16", foreground="White")
search_book_btn.pack()
issue_book_btn = Button(root, text="ISSUE A BOOK", width=50, height=5, bg="black", font="Courier 16", foreground="White")
issue_book_btn.pack()
root.mainloop()
add_book.py
from tkinter import *
from tkinter import messagebox
from pyautogui import prompt
from pyautogui import password
import mysql.connector
def add_book(event):
if __name__ == '__main__':
global password
username = prompt("Username", "Enter your database username")
password = password("Password", "Enter your database password")
try:
global conn
conn = mysql.connector.connect(host="localhost", user=username, passwd=password, db="Library")
except:
messagebox.showerror("Incorrect username or password", "Access denied")
exit()
form = Tk()
form.geometry("500x200")
form.title("Add A New Book")
top_lbl = Label(form, text="Add A Book", font="Courier 26").grid(column=4)
title_lbl = Label(form, text="Title: ", font = "Courier 8")
title_lbl.grid(row = 6, column = 3)
global title_entry
title_entry = Entry(form)
title_entry.grid(row = 6, column=4)
author_lbl = Label(form, text="Author: ", font = "Courier 8")
author_lbl.grid(row = 7, column = 3)
global author_entry
author_entry = Entry(form)
author_entry.grid(row = 7, column=4)
id_lbl = Label(form, text="ISBN: ", font = "Courier 8")
id_lbl.grid(row=9, column=3)
global id_entry
id_entry = Entry(form)
id_entry.grid(row=9, column=4)
submit_btn = Button(text="SUBMIT", command=submit)
submit_btn.grid(row=10, column=4)
def submit():
title = title_entry.get()
author = author_entry.get()
ISBN = id_entry.get()
cur = conn.cursor()
cur.execute("INSERT INTO Books (ISBN, ITLE, AUTHOR) VALUES (%s, %s, %s);", (ISBN, title, author))
conn.commit()
messagebox.showinfo("Created", "Book has been added to the database")