Home > Article > Backend Development > How to use PHP to develop an employee attendance exception alarm system?

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

WBOYOriginal: 2023-09-25 09:57:40609browse

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();
}

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();
?>

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();
?>

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!

php 封装标识符 alert 数据库

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：How to implement a simple online chat room using PHPNext article：How to implement a simple online chat room using PHP

See more

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

Related articles