校友会管理系统在医科大学中的应用

<?php

// 假设我们有一个校友会管理系统，该系统需要管理医科大学中的校友信息。

// 数据库连接

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "alumni_management";

// 创建连接

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接

if ($conn->connect_error) {

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

}

// 添加校友信息

function addAlumni($name, $graduationYear, $email, $phone) {

global $conn;

$sql = "INSERT INTO alumni (name, graduation_year, email, phone)

VALUES ('$name', '$graduationYear', '$email', '$phone')";

if ($conn->query($sql) === TRUE) {

echo "新记录插入成功";

} else {

echo "Error: " . $sql . "<br>" . $conn->error;

}

}

// 查询校友信息

function getAlumniInfo($id) {

数字迎新管理系统

global $conn;

$sql = "SELECT * FROM alumni WHERE id=$id";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

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

echo "姓名：" . $row["name"]. "<br>";

echo "毕业年份：" . $row["graduation_year"]. "<br>";

echo "邮箱：" . $row["email"]. "<br>";

echo "电话：" . $row["phone"]. "<br>";

}

} else {

echo "0 结果";

}

}

// 更新校友信息

function updateAlumni($id, $name, $graduationYear, $email, $phone) {

global $conn;

$sql = "UPDATE alumni SET name='$name', graduation_year='$graduationYear', email='$email', phone='$phone' WHERE id=$id";

if ($conn->query($sql) === TRUE) {

echo "记录更新成功";

} else {

echo "Error updating record: " . $conn->error;

}

}

// 删除校友信息

function deleteAlumni($id) {

global $conn;

$sql = "DELETE FROM alumni WHERE id=$id";

if ($conn->query($sql) === TRUE) {

echo "记录删除成功";

} else {

echo "Error deleting record: " . $conn->error;

}

}

// 关闭连接

$conn->close();

?>