How to achieve simultaneous access to employee attendance data by multiple users in PHP?

How to achieve simultaneous access to employee attendance data by multiple users in PHP?

In an enterprise, employee attendance data is very important. In order to facilitate management, software systems are usually used to record and view this data. As a commonly used server-side scripting language, PHP is very suitable for implementing such functions. This article will introduce how to use PHP to achieve simultaneous access to employee attendance data by multiple users.

Requirement analysis:

1. A user is required to log in to the system, which can be logged in through user name and password.
2. Each user can only access their own attendance data and cannot access other users' data.

Solution:

1. Database design:
   We need a database to store employee attendance data and user information. Create two tables, one is used to store employee attendance data, including employee ID, date, attendance status and other information; the other is used to store user information, including user name, password, user ID, etc.

2. User login system:
   Implement a user login system. After the user enters the user name and password, compare it with the user information stored in the database. If the verification is passed, the user ID Stored in the session, it means that the user is logged in.

   The sample code is as follows:

   <?php
   session_start();
   
   // 连接数据库
   $conn = mysqli_connect("localhost", "root", "password", "attendance_system");
   
   if(isset($_POST['login'])) {
    $username = $_POST['username'];
    $password = $_POST['password'];
   
    $query = "SELECT * FROM users WHERE username='$username' AND password='$password'";
    $result = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($result);
   
    if(mysqli_num_rows($result) == 1) {
        $_SESSION['user_id'] = $row['user_id'];
        header("Location: dashboard.php");
        exit();
    } else {
        echo "用户名或密码错误";
    }
   }
   ?>
   
   <form method="post" action="">
    <input type="text" name="username" placeholder="用户名">
    <input type="password" name="password" placeholder="密码">
    <input type="submit" name="login" value="登录">
   </form>

3. Access permission control:
   When a user performs an operation (such as viewing his or her attendance data), it is necessary to verify whether the user is logged in. And can only access your own data. You can add the following code to each page that requires verification:

<?php
session_start();

if(!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

$user_id = $_SESSION['user_id'];
// 进一步验证用户是否有权访问该数据
?>

4. Display attendance data:
   On the page after login, the user's attendance can be obtained from the database based on the user ID data and display it.

<?php
session_start();

if(!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

$user_id = $_SESSION['user_id'];

// 连接数据库
$conn = mysqli_connect("localhost", "root", "password", "attendance_system");

// 根据用户ID获取该用户的考勤数据
$query = "SELECT * FROM attendance WHERE user_id='$user_id'";
$result = mysqli_query($conn, $query);

// 显示考勤数据
while($row = mysqli_fetch_assoc($result)) {
    echo "日期：" . $row['date'] . "<br>";
    echo "考勤状态：" . $row['status'] . "<br>";
    echo "<br>";
}
?>

In this way, we can achieve simultaneous access and management of employee attendance data by multiple users. Each user can only access their own data, ensuring data security and privacy.

Summary:
This article introduces how to achieve simultaneous access of multiple users to employee attendance data in PHP. Through user login system and access permission control, we can achieve user authentication and data access control. Hope these sample codes and solutions can help you implement your own attendance data management system.

The above is the detailed content of How to achieve simultaneous access to employee attendance data by multiple users in PHP?. For more information, please follow other related articles on the PHP Chinese website!