전사적자원관리(ERP) 시스템에 PHP를 활용하여 개발된 직원 성과평가 보고서 모듈 적용

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "erp_system";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("数据库连接失败：" . $conn->connect_error);
}

// 获取表单提交的数据
$employee_id = $_POST['employee_id'];
$completion_score = $_POST['completion_score'];
$quality_score = $_POST['quality_score'];
$teamwork_score = $_POST['teamwork_score'];

// 插入数据到数据库
$sql = "INSERT INTO employee_performance (employee_id, completion_score, quality_score, teamwork_score)
VALUES ('$employee_id', '$completion_score', '$quality_score', '$teamwork_score')";

if ($conn->query($sql) === TRUE) {
    echo "员工绩效考核信息添加成功";
} else {
    echo "添加失败：" . $conn->error;
}

$conn->close();
?>

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "erp_system";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("数据库连接失败：" . $conn->connect_error);
}

// 查询员工绩效考核信息
$sql = "SELECT * FROM employee_performance";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
        echo "员工ID: " . $row["employee_id"]. " - 工作完成情况得分: " . $row["completion_score"]. " - 工作质量得分: " . $row["quality_score"]. " - 团队合作得分: " . $row["teamwork_score"]. "<br>";
    }
} else {
    echo "没有员工绩效考核信息";
}

$conn->close();
?>