How to use PHP to develop employee attendance system?-PHP Tutorial-php.cn

How to use PHP to develop employee attendance system?

With the continuous advancement of technology, more and more companies are beginning to use employee attendance systems to manage employee attendance records. Using PHP language to develop an attendance system can quickly and efficiently meet the needs of enterprises. This article will introduce how to use PHP to develop a simple employee attendance system and provide specific code examples.

Preparation
Before you start, you need to ensure that you have installed PHP and MySQL and have the relevant development environment.
Database design
In order to store employee attendance data, we need to design a database. Two tables can be created, one is the employee information table and the other is the attendance record table. The employee information table contains the basic information of employees, such as ID, name, position, etc.; the attendance record table is used to record employees' daily attendance, including date, working time, off-duty time, etc.

The employee information table is designed as follows:
CREATE TABLE employee (

id INT(11) PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, position VARCHAR(50) NOT NULL

Copy after login

);

The attendance record table is designed as follows:
CREATE TABLE attendance (

id INT(11) PRIMARY KEY AUTO_INCREMENT, employee_id INT(11) NOT NULL, date DATE NOT NULL, check_in TIME NOT NULL, check_out TIME NOT NULL

Copy after login

);

Employee Information Management
First, we need to create an employee information management interface to facilitate adding, editing and deleting employee information. The following is a sample code:

$conn = mysqli_connect("localhost", "username", "password", "database name");

// Add employee information
if(isset($_POST['add_employee'])){

$name = $_POST['name']; $position = $_POST['position']; $sql = "INSERT INTO employee (name, position) VALUES ('$name', '$position')"; mysqli_query($conn, $sql);

Copy after login

}

// Edit employee information
if(isset( $_POST['edit_employee'])){

$employee_id = $_POST['employee_id']; $name = $_POST['name']; $position = $_POST['position']; $sql = "UPDATE employee SET name='$name', position='$position' WHERE id='$employee_id'"; mysqli_query($conn, $sql);

Copy after login

}

// Delete employee information
if(isset($_POST['delete_employee'])){

$employee_id = $_POST['employee_id']; $sql = "DELETE FROM employee WHERE id='$employee_id'"; mysqli_query($conn, $sql);

Copy after login

}

// Get the employee list
$sql = "SELECT * FROM employee";
$result = mysqli_query($conn, $sql);
?>

员工信息管理

Copy after login

员工信息管理
  添加员工
     
  员工列表
   ID  姓名  职位  操作

Copy after login

Attendance record management
Next, we need to create an attendance record management interface to facilitate recording employees' work and off-duty times. The following is a sample code:

$conn = mysqli_connect("localhost", "username", "password", "database name");

// Add attendance record
if(isset($_POST['add_attendance'])){

$employee_id = $_POST['employee_id']; $date = $_POST['date']; $check_in = $_POST['check_in']; $check_out = $_POST['check_out']; $sql = "INSERT INTO attendance (employee_id, date, check_in, check_out) VALUES ('$employee_id', '$date', '$check_in', '$check_out')"; mysqli_query($conn, $sql);

Copy after login

}

// Get attendance record list
$sql = "SELECT * FROM attendance JOIN employee ON attendance.employee_id = employee.id";
$result = mysqli_query($conn, $sql);
?>

考勤记录管理

Copy after login

考勤记录管理
  添加考勤记录
       
  考勤记录列表
   ID  姓名  日期  上班时间  下班时间

Copy after login

The above is the detailed content of How to use PHP to develop employee attendance system?. For more information, please follow other related articles on the PHP Chinese website!