一站式网上办事大厅

// 数据库连接配置

$host = 'localhost';

$db_name = 'university_db';

$username = 'root';

学生信息管理系统

$password = '';

try {

$pdo = new PDO("mysql:host=$host;dbname=$db_name", $username, $password);

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

} catch (PDOException $e) {

die("Database connection failed: " . $e->getMessage());

}

// 查询学生信息

function fetchStudent($id, $pdo) {

$stmt = $pdo->prepare('SELECT * FROM students WHERE id = :id');

$stmt->bindParam(':id', $id);

$stmt->execute();

return $stmt->fetch(PDO::FETCH_ASSOC);

}

// 更新学生信息

function updateStudent($id, $data, $pdo) {

$columns = implode(', ', array_keys($data));

$values = ':' . implode(', :', array_keys($data));

$sql = "UPDATE students SET $columns WHERE id = :id";

$stmt = $pdo->prepare($sql);

foreach ($data as $key => &$value) {

$stmt->bindValue(":$key", $value);

}

$stmt->bindParam(':id', $id);

$stmt->execute();

}

?>