在线人员管理系统 - 前后台代码实现 - 常规

<!DOCTYPE html>
<html>
<head>
	<title>人员管理系统</title>
	<meta charset="UTF-8">
	<link rel="stylesheet" type="text/css" href="style.css">
	<script type="text/javascript" src="jquery.min.js"></script>
	<script type="text/javascript" src="echarts.min.js"></script>
</head>
<body>
	<header>
		<h1>人员管理系统</h1>
	</header>
	<nav>
		<ul>
			<li><a href="#" id="add">添加人员</a></li>
			<li><a href="#" id="search">查询人员</a></li>
			<li><a href="#" id="attendance">出勤情况</a></li>
			<li><a href="#" id="chart">图表分析</a></li>
			<li><a href="#" id="export">导出数据</a></li>
			<li><a href="#" id="logout">退出登录</a></li>
		</ul>
	</nav>
	<main>
		<div id="content"></div>
	</main>
	<footer>
		<p>&copy; 2021 人员管理系统</p>
	</footer>
	<script type="text/javascript" src="common.js"></script>
</body>
</html>
<?php
session_start();

// 数据库连接配置
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASS', '');
define('DB_NAME', 'personnel');

// 连接数据库
$conn = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);

// 检查连接是否成功
if (!$conn) {
	die('连接失败: ' . mysqli_connect_error());
}

// 设置字符集
mysqli_set_charset($conn, 'utf8');

// 登录验证
function login($username, $password) {
	global $conn;
	$sql = "SELECT * FROM users WHERE username='{$username}' AND password='{$password}' ";
	$result = mysqli_query($conn, $sql);
	if (mysqli_num_rows($result) == 1) {
		$row = mysqli_fetch_assoc($result);
		$_SESSION['username'] = $row['username'];
		$_SESSION['is_admin'] = $row['is_admin'];
		return true;
	} else {
		return false;
	}
}

// 添加人员信息
function addPerson($name, $gender, $age, $phone) {
	global $conn;
	$sql = "INSERT INTO persons (name, gender, age, phone) VALUES ('{$name}', '{$gender}', {$age}, '{$phone}')";
	return mysqli_query($conn, $sql);
}

// 删除人员信息
function deletePerson($id) {
	global $conn;
	$sql = "DELETE FROM persons WHERE id={$id}";
	return mysqli_query($conn, $sql);
}

// 修改人员信息
function updatePerson($id, $name, $gender, $age, $phone) {
	global $conn;
	$sql = "UPDATE persons SET name='{$name}', gender='{$gender}', age={$age}, phone='{$phone}' WHERE id={$id}";
	return mysqli_query($conn, $sql);
}

// 查询人员信息
function searchPerson($name, $gender, $age, $phone, $orderby) {
	global $conn;
	$sql = "SELECT * FROM persons WHERE 1=1";
	if ($name != '') {
		$sql .= " AND name='{$name}'";
	}
	if ($gender != '') {
		$sql .= " AND gender='{$gender}'";
	}
	if ($age != '') {
		$sql .= " AND age={$age}";
	}
	if ($phone != '') {
		$sql .= " AND phone='{$phone}'";
	}
	if ($orderby != '') {
		$sql .= " ORDER BY {$orderby}";
	}
	$result = mysqli_query($conn, $sql);
	$data = array();
	while ($row = mysqli_fetch_assoc($result)) {
		$data[] = $row;
	}
	return $data;
}

// 记录人员出勤情况
function recordAttendance($id, $type, $date, $reason) {
	global $conn;
	$sql = "INSERT INTO attendance (person_id, type, date, reason) VALUES ({$id}, '{$type}', '{$date}', '{$reason}')";
	return mysqli_query($conn, $sql);
}

// 统计人员出勤情况
function countAttendance() {
	global $conn;
	$sql = "SELECT type, COUNT(*) AS count FROM attendance GROUP BY type";
	$result = mysqli_query($conn, $sql);
	$data = array();
	while ($row = mysqli_fetch_assoc($result)) {
		$data[] = $row;
	}
	return $data;
}

// 导出数据
function exportData($name, $gender, $age, $phone, $orderby) {
	global $conn;
	$sql = "SELECT * FROM persons WHERE 1=1";
	if ($name != '') {
		$sql .= " AND name='{$name}'";
	}
	if ($gender != '') {
		$sql .= " AND gender='{$gender}'";
	}
	if ($age != '') {
		$sql .= " AND age={$age}";
	}
	if ($phone != '') {
		$sql .= " AND phone='{$phone}'";
	}
	if ($orderby != '') {
		$sql .= " ORDER BY {$orderby}";
	}
	$result = mysqli_query($conn, $sql);
	$output = '';
	$num_fields = mysqli_num_fields($result);
	for ($i = 0; $i < $num_fields; $i++) {
		$field_info = mysqli_fetch_field_direct($result, $i);
		$output .= "'" . $field_info->name . "',";
	}
	$output .= "\n";
	while ($row = mysqli_fetch_assoc($result)) {
		for ($i = 0; $i < $num_fields; $i++) {
			$output .= "'" . $row[array_keys($row)[$i]] . "',";
		}
		$output .= "\n";
	}
	return $output;
}

// 退出登录
function logout() {
	session_unset();
	session_destroy();
}

// 检查登录状态
function checkLogin() {
	if (!isset($_SESSION['username']) || !isset($_SESSION['is_admin'])) {
		header('Location: login.php');
		exit();
	}
	if ($_SESSION['is_admin'] != 1) {
		die('非管理员用户无法访问该页面');
	}
}

// 关闭数据库连接
function closeConnection() {
	global $conn;
	mysqli_close($conn);
}
?>