How to implement employee overtime management function in PHP?

How to implement employee overtime management function in PHP?

Overtime management is an important human resources management task in an enterprise. In order to better manage employees' overtime, you can use the PHP programming language to implement a simple and practical employee overtime management system.

1. Database design

First, you need to design a database to store employees’ overtime information. For this purpose, you can create an employee overtime table, which contains the following fields:

1. id: the unique identifier of overtime information, using an auto-incrementing primary key;
2. employee_id: the employee's unique identifier , used to associate data in the employee table;
3. date: overtime date, stored using date type;
4. hours: overtime duration, stored using floating point type;
5. reason: reason for working overtime, stored using text type.

2. Implementation of employee overtime management system

1. Create database connection

First, you need to create a database connection so that you can use the PHP code to interact with the database. You can use the mysqli extension to create a connection. The sample code is as follows:

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

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

Please replace "your_username", "your_password" and "your_database_name" with the correct database username, password and database name.

2. Add overtime records

Next, implement a form for employees to add overtime records. The form contains input items such as date, overtime hours, and reasons for overtime, and is submitted to the background for processing. The sample code is as follows:

<form action="add_overtime.php" method="post">
    <label for="date">加班日期:</label>
    <input type="date" id="date" name="date" required><br><br>
  
    <label for="hours">加班时长:</label>
    <input type="number" id="hours" name="hours" min="0" max="24" step="0.5" required><br><br>
  
    <label for="reason">加班原因:</label>
    <textarea id="reason" name="reason" required></textarea><br><br>
  
    <input type="submit" value="提交">
</form>

3. Processing the submission of overtime records

On the server side, you can create a file named "add_overtime.php" to handle the submission of the form. This file is responsible for writing employees' overtime records into the database. The sample code is as follows:

<?php
$date = $_POST['date'];
$hours = $_POST['hours'];
$reason = $_POST['reason'];

$sql = "INSERT INTO overtime (employee_id, date, hours, reason) VALUES (1, '$date', '$hours', '$reason')";

if ($conn->query($sql) === TRUE) {
    echo "加班记录添加成功";
} else {
    echo "加班记录添加失败: " . $conn->error;
}

$conn->close();
?>

Please note that "employee_id" in the above code needs to be replaced with the actual employee identifier.

4. Display employees’ overtime records

Finally, you can create a page to display employees’ overtime records. By querying the database, employees' overtime information is obtained, and a table is dynamically generated on the page for display. The sample code is as follows:

<?php
$sql = "SELECT * FROM overtime WHERE employee_id = 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    echo "<table><tr><th>加班日期</th><th>加班时长</th><th>加班原因</th></tr>";
    
    while($row = $result->fetch_assoc()) {
        echo "<tr><td>".$row["date"]."</td><td>".$row["hours"]."</td><td>".$row["reason"]."</td></tr>";
    }
    
    echo "</table>";
} else {
    echo "该员工没有加班记录";
}

$conn->close();
?>

The above code will generate a table with header and overtime records.

3. Summary

By using the PHP programming language, a simple and practical employee overtime management system can be implemented. By storing employees' overtime information in the database and realizing form submission and information display, employees' overtime status can be easily managed. At the same time, developers can expand and optimize functions according to actual needs.

The above is the detailed content of How to implement employee overtime management function in PHP?. For more information, please follow other related articles on the PHP Chinese website!