广东省招生管理信息系统的开发与实现

<?php

// 示例代码：用户登录验证

function validateLogin($username, $password) {

// 连接数据库

$conn = new mysqli("localhost", "root", "password", "enrollment_system");

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// 预处理语句防止SQL注入

$stmt = $conn->prepare("SELECT * FROM users WHERE username=? AND password=?");

$stmt->bind_param("ss", $username, $password);

// 执行查询

$stmt->execute();

$result = $stmt->get_result();

if ($result->num_rows > 0) {

return true;

} else {

return false;

}

大专排课软件源码

}

// 示例代码：添加新学生信息

function addStudent($name, $id, $major, $grade) {

$conn = new mysqli("localhost", "root", "password", "enrollment_system");

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$stmt = $conn->prepare("INSERT INTO students (name, id, major, grade) VALUES (?, ?, ?, ?)");

$stmt->bind_param("siss", $name, $id, $major, $grade);

if ($stmt->execute() === TRUE) {

echo "New record created successfully";

} else {

echo "Error: " . $stmt->error;

}

$stmt->close();

$conn->close();

}

// 示例代码：查询学生信息

function getStudentById($studentId) {

$conn = new mysqli("localhost", "root", "password", "enrollment_system");

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$stmt = $conn->prepare("SELECT * FROM students WHERE id=?");

$stmt->bind_param("s", $studentId);

$stmt->execute();

$result = $stmt->get_result();

if ($result->num_rows > 0) {

while ($row = $result->fetch_assoc()) {

echo "ID: " . $row["id"] . " - Name: " . $row["name"] . " - Major: " . $row["major"] . " - Grade: " . $row["grade"];

}

} else {

echo "No results found";

}

$stmt->close();

$conn->close();

}

?>