php实现员工信息
员工信息管理系统实现
PHP结合MySQL可以高效实现员工信息管理功能。以下是关键实现步骤和代码示例：
数据库设计
创建员工信息表employees的基本SQL：
CREATE TABLE employees (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
department VARCHAR(50),
position VARCHAR(50),
salary DECIMAL(10,2),
hire_date DATE,
email VARCHAR(100) UNIQUE,
phone VARCHAR(20)
);数据库连接
建立MySQL连接：
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "employee_db";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}添加员工信息
表单处理示例：
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$name = $_POST['name'];
$department = $_POST['department'];
$position = $_POST['position'];
$salary = $_POST['salary'];
$sql = "INSERT INTO employees (name, department, position, salary)
VALUES ('$name', '$department', '$position', $salary)";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}查询员工信息
显示所有员工记录：
$sql = "SELECT * FROM employees";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "<table><tr><th>ID</th><th>Name</th><th>Department</th><th>Position</th><th>Salary</th></tr>";
while($row = $result->fetch_assoc()) {
echo "<tr><td>".$row["id"]."</td><td>".$row["name"]."</td><td>".$row["department"]."</td><td>".$row["position"]."</td><td>".$row["salary"]."</td></tr>";
}
echo "</table>";
} else {
echo "0 results";
}更新员工信息
编辑功能实现：
if (isset($_POST['update'])) {
$id = $_POST['id'];
$name = $_POST['name'];
$department = $_POST['department'];
$sql = "UPDATE employees SET name='$name', department='$department' WHERE id=$id";
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
}删除员工记录
删除功能实现：
if (isset($_GET['delete'])) {
$id = $_GET['delete'];
$sql = "DELETE FROM employees WHERE id=$id";
if ($conn->query($sql) === TRUE) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . $conn->error;
}
}安全注意事项
使用预处理语句防止SQL注入：
$stmt = $conn->prepare("INSERT INTO employees (name, department) VALUES (?, ?)");
$stmt->bind_param("ss", $name, $department);
$stmt->execute();以上代码示例构成了一个基础的员工信息管理系统核心功能。实际开发中应增加输入验证、错误处理和用户身份验证等功能。
