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

How to use PHP to develop an employee attendance exception alarm system?

WBOY

Release： 2023-09-25 10:22:01

Original

636 people have browsed it

How to use PHP to develop an employee attendance exception alarm system?

As the size of an enterprise grows and the number of employees increases, how to manage employee attendance has become an important issue. The attendance of employees is directly related to the normal operation and efficiency of the enterprise. In order to solve this problem, we can use PHP language to develop an employee attendance exception alarm system.

The employee attendance abnormality alarm system can monitor employee attendance in real time. When an abnormality occurs, alarm information will be sent to relevant personnel in a timely manner so that corresponding measures can be taken quickly.

The following is a sample code using PHP to develop an employee attendance exception alarm system:

Design the database table structure

We first need to design the database table structure To store employee attendance information. We can create a table named "attendance" with the following fields:

id: the unique identifier of the attendance record
employee_id: the unique identifier of the employee
check_in_time: Check-in time at work
check_out_time: Check-in time at work
status: Attendance status (normal, late, early departure, etc.)

Create PHP File to connect to the database

We can create a file named "db_connect.php" to connect to the database and encapsulate some common database operation functions. The following is a code example of the file:

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
}

// 封装查询函数
function query($sql) {
    global $conn;
    $result = $conn->query($sql);
    if ($result === false) {
        die("查询失败: " . $conn->error);
    }
    return $result;
}

// 关闭数据库连接
function close() {
    global $conn;
    $conn->close();
}

Copy after login

Writing employee attendance information entry page

We can create a file named "check_in_out.php" for employee clock-in information entry. The following is a code example of the file:

<?php
require 'db_connect.php';

// 获取员工ID和打卡时间等信息，并插入到数据库中
if (isset($_POST['employee_id']) && isset($_POST['check_in_time']) && isset($_POST['check_out_time'])) {
    $employee_id = $_POST['employee_id'];
    $check_in_time = $_POST['check_in_time'];
    $check_out_time = $_POST['check_out_time'];
    
    $sql = "INSERT INTO attendance (employee_id, check_in_time, check_out_time) VALUES ('$employee_id', '$check_in_time', '$check_out_time')";
    query($sql);
}
?>

<!DOCTYPE html>
<html>
<head>
    <title>员工考勤信息录入</title>
</head>
<body>
    <h1>员工考勤信息录入</h1>
    <form action="" method="POST">
        <label for="employee_id">员工ID：</label>
        <input type="text" name="employee_id" required><br>
        <label for="check_in_time">上班打卡时间：</label>
        <input type="datetime-local" name="check_in_time" required><br>
        <label for="check_out_time">下班打卡时间：</label>
        <input type="datetime-local" name="check_out_time" required><br>
        <input type="submit" value="提交">
    </form>
</body>
</html>

<?php
close();
?>

Copy after login

Writing an attendance exception alarm page

We can create a file named "alert.php" for employee attendance exceptions alarm. The following is a code example of the file:

<?php
require 'db_connect.php';

// 查询考勤异常的员工信息
$sql = "SELECT * FROM attendance WHERE status != '正常'";
$result = query($sql);
?>

<!DOCTYPE html>
<html>
<head>
    <title>考勤异常报警</title>
</head>
<body>
    <h1>考勤异常报警</h1>
    <?php if ($result->num_rows > 0): ?>
        <table>
            <tr>
                <th>员工ID</th>
                <th>上班打卡时间</th>
                <th>下班打卡时间</th>
                <th>考勤状态</th>
            </tr>
            <?php while($row = $result->fetch_assoc()): ?>
                <tr>
                    <td><?= $row['employee_id'] ?></td>
                    <td><?= $row['check_in_time'] ?></td>
                    <td><?= $row['check_out_time'] ?></td>
                    <td><?= $row['status'] ?></td>
                </tr>
            <?php endwhile; ?>
        </table>
    <?php else: ?>
        <p>目前没有考勤异常的员工。</p>
    <?php endif; ?>
</body>
</html>

<?php
close();
?>

Copy after login

The above is an example of an employee attendance exception alarm system developed using PHP. You can expand and optimize functions according to actual needs. Hope this article is helpful to you!

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