Project: Employee Management System using PHP and MySQL with Source Code

About Employee Management System

Employee Management System is Simple web application develop in PHP MySQL, using Bootstrap, HTML, CSS JavaScript, Modal, and Ajax, the system contains of admin and user, the admin can manage employee like approve leave, add user, and also check status of employee, the user is represent as employee manage by the admin but the user have own profile and changes their information and changes password.

Features of the Project

• Admin Dashboard
• Home
• Employee login
• Admin Login
• Add Employee
• View Employee
• Assign Project
• Status Project
• Salary Table
• Employee Leave
• Projects
• Apply Leave

Admin Dashboard

Home, Employee login, Admin Login, Add Employee, View Employee, Assign Project, Status Project, Salary Table, Employee Leave,

Home

SEQ, Employee ID, Name, Points.

Add Employee

First Name, Last Name, Email, Birthday, Gender, Address, Department, Degree, Salary, Profile Picture.

Employee ID, Picture, Name, Email, Birthday, Gender, Contact, NID, Address, Department, Degree, Point, Option, Edit, Delete

Assign Project

Employee ID, Project Name, Month, Day, Year.

Project Status

Project ID, Employee ID, Project Name, Due Date, Submission Date, Mark, Status.

Salary Table

Employee ID, Name, Base Salary, Bonus, Total Salary.

Employee ID, Token, Name, Start Date, End Date, Total Days, Reason Status, Approve, Cancel.

User Dashboard

Home, Profile, My Projects, Apply Leave.

My Projects

Project ID, Project Name, Due Date, Sub Date, Mark, Status, Option.

Employee Leave

Employee ID, Name, Start Date, End Date, Total Days, Reason, Status.

Employee Management System

• Name of Project:     Employee Management System
• Language Used:     PHP
• Database Used:     MySQL
• Design Interface: Bootstrap JavaScript, HTML, Ajax, JQuery,
• Browser:                 Opera Mozilla Google Chrome IE8,
• Software:                WAMP/ XAMPP/ LAMP/MAMP

Screenshots

How To Run??

Above all, to run this project you must have installed a virtual server i.e XAMPP on your PC. Employee Management System in PHP and MySQL with source code is free to download, Use for educational purposes only!

Follow the following steps after Starting Apache and MySQL in XAMPP:

1st Step: Firstly, Extract the file
2nd Step: After that, Copy the main project folder
3rd Step: So, you need to Paste in xampp/htdocs/

Further, Now Connecting Database

4th Step: So, for now, Open a browser and go to URL “http://localhost/phpmyadmin/”
5th Step: After that, Click on the databases tab
6th Step: So, Create a database naming “ems” and then click on the import tab
7th Step: Certainly, Click on browse file and select “ems.sql” file which is inside the “db” folder
8th Step: Meanwhile, click on Go button.

After Creating Database,

9th Step: Moreover, Open a browser and go to URL “http://localhost/Employee_Management_System”

**LOGIN DETAILS**

Admin
user: admin@gmail.com
pass: admin

User
user: john@gmail.com
pass: 1234

Related Projects: Online Apartment Visitor Management System, Online Recruitment Management System in PHP MySQL