CREATE TABLE alumni (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

major VARCHAR(100),

graduation_year YEAR

);

CREATE TABLE contact_info (

id INT AUTO_INCREMENT PRIMARY KEY,

alumni_id INT,

email VARCHAR(100),

phone VARCHAR(20),

FOREIGN KEY (alumni_id) REFERENCES alumni(id)

);

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

$name = $_POST['name'];

$major = $_POST['major'];

學(xué)生綜合服務(wù)門(mén)戶

$graduationYear = $_POST['graduation_year'];

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

if ($conn->connect_error) {

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

}

$sql = "INSERT INTO alumni (name, major, graduation_year) VALUES ('$name', '$major', '$graduationYear')";

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

echo "New record created successfully";

} else {

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

}

$conn->close();

}

?>

session_start();

if (!isset($_SESSION['loggedin']) || $_SESSION['loggedin'] !== true) {

header("location: login.php");

exit;

}

$id = $_SESSION['id'];

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

$newEmail = $_POST['email'];

$newPhone = $_POST['phone'];

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

$stmt = $conn->prepare("UPDATE contact_info SET email=?, phone=? WHERE alumni_id=?");

$stmt->bind_param("ssi", $newEmail, $newPhone, $id);

$stmt->execute();

$stmt->close();

$conn->close();

}

?>