python

Student Management System Project in Python Mysql

This tutorial will teach you  to make the Student Management System Project step by step. The following  system will use to manage the Student Management.

User Login

import mysql.connector
from tkinter import *
from tkinter import messagebox
from subprocess import call

def Ok():
    mysqldb = mysql.connector.connect(host="localhost", user="root", password="", database="studentmanagement")
    mycursor = mysqldb.cursor()
    uname = e1.get()
    password = e2.get()

    sql = "select * from user where uname = %s and password = %s"
    mycursor.execute(sql, [(uname), (password)])
    results = mycursor.fetchall()

    if results:
        root.destroy()
        call(["python", "Mainn.py"])
        return True
    else :
        messagebox.showinfo("","Incorrent Username and Password")
        return False



root = Tk()
root.title("Student Management Login")
root.geometry("300x200")
global e1
global e2

Label(root, text="Student Management System",font=("Arial", 15, "bold"), bg="#00376b", fg="#FFFCF9").place(x=10, y=10)
Label(root, text="UserName").place(x=10, y=60)
Label(root, text="Password").place(x=10, y=80)

e1 = Entry(root)
e1.place(x=140, y=60)

e2 = Entry(root)
e2.place(x=140, y=80)
e2.config(show="*")

Button(root, text="Login", command=Ok ,height = 2, width = 13).place(x=150, y=120)

root.mainloop()


User Main

from tkinter import *
from tkinter import messagebox
from subprocess import call

root = Tk()
root.title("Main")
root.geometry("500x500")
global e1
global e2

def Ok():
    call(["python", "AddStudent.py"])

Label(root, text="Welcome").place(x=10, y=10)
Button(root, text="Add Student", command=Ok, height= 3, width= 12).place(x=10,y=100)


root.mainloop()

 

 

 

admin

Recent Posts

Creating Grocery Inventory App Using React

Introduction to Grocery Inventory Apps Managing grocery inventory can be a daunting task, but with…

33 minutes ago

Fish Inventory Shop Management System in Angular

This article explain how to make a Fish Inventory Management App in Angular.this app explain…

6 days ago

Fish Inventory Management with React

Introduction to Fish Inventory Management In the aquaculture industry, managing fish inventory is crucial for…

1 week ago

Java GUI CRUD for Beginners

Introduction to Java GUI CRUD Java is a powerful programming language widely used for building…

1 week ago

Creating Beautiful Login Form Design Using React

Introduction to Login Form Design Designing an effective and beautiful login form is crucial for…

2 weeks ago

Creating Responsive Login Form with React

Introduction In today creating a responsive login form is essential for providing a seamless user…

2 weeks ago