Generate monthly or weekly attendance summaries instantly. đź› Features of the System
Download the project zip file (link below) and extract it into your htdocs folder (usually located at C:/xampp/htdocs ). 2. Create the Database Generate monthly or weekly attendance summaries instantly
Overview of total employees, present today, and pending leave requests. Create the Database Overview of total employees, present
To run this project, you will need a standard or WAMP server environment: Language: PHP (version 7.4 or 8.x) Database: MySQL Frontend: HTML5, CSS3 (Bootstrap), and JavaScript (jQuery) Server: Apache 🗄️ Database Design Attendance: Logs user_id
Open in your browser ( localhost/phpmyadmin ). Create a new database named attendance_db and import the provided .sql file included in the source code folder. 3. Configure Connection
$conn = new mysqli("localhost", "root", "", "attendance_db"); Use code with caution. 4. Run the Project
A clean database is essential. Here are the core tables required: Stores login credentials and roles (Admin/Employee). Employees: Stores detailed personal information. Attendance: Logs user_id , date , time_in , and time_out . Leaves: Tracks leave_type , status , and dates . 📥 Source Code Installation Guide