EMS_database_mysql_python

🧑‍💼 EMS_database_mysql_python is a desktop-based Employee Management System built with Python, CustomTkinter, and MySQL.
It provides a user-friendly interface to manage employee records, including adding, updating, deleting, and searching employee data.

---

🚀 Features

✅ Login System

• Secure login with MySQL root password validation.

✅ Employee Data Management

• Add new employees with details:
  • ID
  • Name
  • Phone
  • Role
  • Gender
  • Salary
• Update existing records.
• Delete individual or all records.
• View all employees in a modern Treeview table.

✅ Search Functionality

• Search employees by:
  • ID
  • Name
  • Phone
  • Role
  • Gender
  • Salary

✅ Modern GUI

• Built with CustomTkinter for a sleek, modern look.
• Image banners for a professional touch.

---

📂 Project Structure

EMS_database_mysql_python/
│
├── banner.png # Banner image for login screen
├── empbanner.jpg # Banner image for main EMS screen
├── login.py # Login screen logic and UI
├── ems.py # Main EMS GUI and functionality
├── database.py # MySQL database connection and operations
└── README.md # Project documentation

---

💻 Requirements

• Python 3.x
• MySQL Server
• Python Libraries:
  • customtkinter
  • pillow
  • pymysql

Install the required libraries:

pip install customtkinter pillow pymysql

⚙️ How to Run

.Start your MySQL server.
.Clone this repo:

https://github.com/qasim032/EMS_database_mysql_python.git

.Run the login page:

python login.py

Enter:
Username: root
Password: your MySQL root password
.

.

.

.

---

👨‍💻 Author

Syed Muhammad Qasim
Feel free to connect on LinkedIn or explore more projects on GitHub.