PRO.py

import tkinter as tk
from tkinter import ttk, filedialog, messagebox
from pymongo import MongoClient
import gridfs
from PIL import Image, ImageTk

client = MongoClient("mongodb://localhost:27017/")
db = client["college_db"]
collection = db["students"]
fs = gridfs.GridFS(db)

root = tk.Tk()
root.title("Student Management System")
root.geometry("820x560")
root.configure(bg="#eef2f7")
root.resizable(False, False)

photo_path = None

style = ttk.Style()
style.theme_use("clam")
style.configure("TFrame", background="#eef2f7")
style.configure("Card.TFrame", background="white", relief="raised")
style.configure("TLabel", background="white", font=("Segoe UI", 10))
style.configure("Header.TLabel", background="#1f2937", foreground="white", font=("Segoe UI", 16, "bold"))
style.configure("TButton", font=("Segoe UI", 10), padding=8)
style.map("TButton", background=[("active", "#2563eb")])

def choose_photo():
    global photo_path
    photo_path = filedialog.askopenfilename(filetypes=[("Image Files", "*.jpg *.png *.jpeg")])
    if photo_path:
        img = Image.open(photo_path).resize((150, 150))
        photo = ImageTk.PhotoImage(img)
        photo_label.config(image=photo)
        photo_label.image = photo


def save_student():
    data = {
        "prn": entry_prn.get(),
        "name": entry_name.get(),
        "course": combo_course.get(),
        "year": combo_year.get(),
        "division": combo_div.get(),
        "mobile": entry_mobile.get(),
        "email": entry_email.get()
    }

    if "" in data.values() or not photo_path:
        messagebox.showerror("Error", "Please fill all fields")
        return

    with open(photo_path, "rb") as f:
        photo_id = fs.put(f, filename=data["prn"])

    data["photo_id"] = photo_id
    collection.insert_one(data)
    messagebox.showinfo("Success", "Student saved successfully")
    clear_fields()


def retrieve_student():
    prn = entry_prn.get()
    student = collection.find_one({"prn": prn})

    if not student:
        messagebox.showerror("Error", "Student not found")
        return

    entry_name.delete(0, tk.END)
    entry_mobile.delete(0, tk.END)
    entry_email.delete(0, tk.END)

    entry_name.insert(0, student["name"])
    entry_mobile.insert(0, student["mobile"])
    entry_email.insert(0, student["email"])

    combo_course.set(student["course"])
    combo_year.set(student["year"])
    combo_div.set(student["division"])

    img_data = fs.get(student["photo_id"]).read()
    with open("temp.jpg", "wb") as f:
        f.write(img_data)

    img = Image.open("temp.jpg").resize((150, 150))
    photo = ImageTk.PhotoImage(img)
    photo_label.config(image=photo)
    photo_label.image = photo


def clear_fields():
    for e in [entry_prn, entry_name, entry_mobile, entry_email]:
        e.delete(0, tk.END)
    combo_course.set("")
    combo_year.set("")
    combo_div.set("")
    photo_label.config(image="")

header = ttk.Label(root, text="  Student Management System", style="Header.TLabel", anchor="w")
header.pack(fill="x", ipady=10)

content = ttk.Frame(root, padding=20)
content.pack(fill="both", expand=True)

card_form = ttk.Frame(content, style="Card.TFrame", padding=20)
card_form.grid(row=0, column=0, padx=10, pady=10, sticky="n")

fields = [
    ("PRN", None),
    ("Full Name", None),
    ("Course", None),
    ("Year", None),
    ("Division", None),
    ("Mobile", None),
    ("Email", None)
]

label_prn = ttk.Label(card_form, text="PRN")
label_prn.grid(row=0, column=0, sticky="w", pady=6)
entry_prn = ttk.Entry(card_form, width=28)
entry_prn.grid(row=0, column=1, pady=6)

label_name = ttk.Label(card_form, text="Full Name")
label_name.grid(row=1, column=0, sticky="w", pady=6)
entry_name = ttk.Entry(card_form, width=28)
entry_name.grid(row=1, column=1, pady=6)

label_course = ttk.Label(card_form, text="Course")
label_course.grid(row=2, column=0, sticky="w", pady=6)
combo_course = ttk.Combobox(card_form, values=["BCA", "MCA", "BSc", "MSc"], width=26, state="readonly")
combo_course.grid(row=2, column=1, pady=6)

label_year = ttk.Label(card_form, text="Year")
label_year.grid(row=3, column=0, sticky="w", pady=6)
combo_year = ttk.Combobox(card_form, values=["FY", "SY", "TY"], width=26, state="readonly")
combo_year.grid(row=3, column=1, pady=6)

label_div = ttk.Label(card_form, text="Division")
label_div.grid(row=4, column=0, sticky="w", pady=6)
combo_div = ttk.Combobox(card_form, values=["A", "B", "C"], width=26, state="readonly")
combo_div.grid(row=4, column=1, pady=6)

label_mobile = ttk.Label(card_form, text="Mobile")
label_mobile.grid(row=5, column=0, sticky="w", pady=6)
entry_mobile = ttk.Entry(card_form, width=28)
entry_mobile.grid(row=5, column=1, pady=6)

label_email = ttk.Label(card_form, text="Email")
label_email.grid(row=6, column=0, sticky="w", pady=6)
entry_email = ttk.Entry(card_form, width=28)
entry_email.grid(row=6, column=1, pady=6)

btn_frame = ttk.Frame(card_form)
btn_frame.grid(row=7, column=0, columnspan=2, pady=15)

ttk.Button(btn_frame, text="Save", command=save_student).grid(row=0, column=0, padx=6)
ttk.Button(btn_frame, text="Retrieve", command=retrieve_student).grid(row=0, column=1, padx=6)
ttk.Button(btn_frame, text="Clear", command=clear_fields).grid(row=0, column=2, padx=6)

card_photo = ttk.Frame(content, style="Card.TFrame", padding=20)
card_photo.grid(row=0, column=1, padx=10, pady=10, sticky="n")

ttk.Label(card_photo, text="Student Photo", font=("Segoe UI", 11, "bold")).pack(pady=5)
photo_label = ttk.Label(card_photo)
photo_label.pack(pady=10)

ttk.Button(card_photo, text="Upload Photo", command=choose_photo).pack(pady=5)

root.mainloop()