<?php

// 学生工作管理系统试用及实现

// 引入数据库连接文件

include 'db_connect.php';

// 创建一个函数来检查用户是否已登录

function is_logged_in() {

session_start();

if (!isset($_SESSION['user_id'])) {

header('Location: login.php');

exit;

}

}

// 检查用户是否已经登录

is_logged_in();

// 查询数据库获取所有学生信息

统一通信平台

$sql = "SELECT * FROM students";

$result = mysqli_query($conn, $sql);

// 显示学生信息

while ($row = mysqli_fetch_assoc($result)) {

echo "姓名: " . $row['name'] . " | 学号: " . $row['student_id'] . "
";

}

// 添加新的学生信息

if ($_SERVER["REQUEST_METHOD"] == "POST") {

$name = $_POST['name'];

$student_id = $_POST['student_id'];

$sql = "INSERT INTO students (name, student_id) VALUES ('$name', '$student_id')";

if (mysqli_query($conn, $sql)) {

echo "新记录插入成功";

} else {

echo "Error: " . $sql . "
" . mysqli_error($conn);

}

}

?>

<form method="post" action="manage_students.php">

姓名: <input type="text" name="name"><br>

学号: <input type="text" name="student_id"><br>

<input type="submit" value="添加">

</form>