How to use PHP to develop employee attendance system?

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.

1. Preparation
   Before you start, you need to ensure that you have installed PHP and MySQL and have the relevant development environment.
2. 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

);

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

);

3. 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);

}

// 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);

}

// 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);

}

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

<title>员工信息管理</title>

<h2>员工信息管理</h2>

<!-- 添加员工表单 -->
<h3>添加员工</h3>
<form method="post" action="#">
    <input type="text" name="name" placeholder="姓名" required>
    <input type="text" name="position" placeholder="职位" required>
    <input type="submit" name="add_employee" value="添加员工">
</form>

<!-- 员工列表 -->
<h3>员工列表</h3>
<table>
    <tr>
        <th>ID</th>
        <th>姓名</th>
        <th>职位</th>
        <th>操作</th>
    </tr>
    <?php while($row = mysqli_fetch_assoc($result)): ?>
    <tr>
        <td><?php echo $row['id']; ?></td>
        <td><?php echo $row['name']; ?></td>
        <td><?php echo $row['position']; ?></td>
        <td>
            <form method="post" action="#">
                <input type="hidden" name="employee_id" value="<?php echo $row['id']; ?>">
                <input type="text" name="name" value="<?php echo $row['name']; ?>">
                <input type="text" name="position" value="<?php echo $row['position']; ?>">
                <input type="submit" name="edit_employee" value="编辑">
                <input type="submit" name="delete_employee" value="删除">
            </form>
        </td>
    </tr>
    <?php endwhile; ?>
</table>

4. 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);

}

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

<title>考勤记录管理</title>

<h2>考勤记录管理</h2>

<!-- 添加考勤记录表单 -->
<h3>添加考勤记录</h3>
<form method="post" action="#">
    <select name="employee_id">
        <?php
        $sql = "SELECT * FROM employee";
        $result = mysqli_query($conn, $sql);
        while($row = mysqli_fetch_assoc($result)){
            echo "<option value='".$row['id']."'>".$row['name']."</option>";
        }
        ?>
    </select>
    <input type="date" name="date" required>
    <input type="time" name="check_in" required>
    <input type="time" name="check_out" required>
    <input type="submit" name="add_attendance" value="添加考勤记录">
</form>

<!-- 考勤记录列表 -->
<h3>考勤记录列表</h3>
<table>
    <tr>
        <th>ID</th>
        <th>姓名</th>
        <th>日期</th>
        <th>上班时间</th>
        <th>下班时间</th>
    </tr>
    <?php while($row = mysqli_fetch_assoc($result)): ?>
    <tr>
        <td><?php echo $row['id']; ?></td>
        <td><?php echo $row['name']; ?></td>
        <td><?php echo $row['date']; ?></td>
        <td><?php echo $row['check_in']; ?></td>
        <td><?php echo $row['check_out']; ?></td>
    </tr>
    <?php endwhile; ?>
</table>

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!