基于PHP的校友系统设计方案与实现

-- 创建用户表

CREATE TABLE users (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL UNIQUE,

password VARCHAR(255) NOT NULL,

email VARCHAR(100),

phone VARCHAR(15)

);

-- 创建校友关系表

CREATE TABLE alumni_relations (

id INT AUTO_INCREMENT PRIMARY KEY,

user_id INT NOT NULL,

friend_id INT NOT NULL,

status ENUM('pending', 'accepted') DEFAULT 'pending',

FOREIGN KEY (user_id) REFERENCES users(id),

FOREIGN KEY (friend_id) REFERENCES users(id)

);

-- 创建消息表

CREATE TABLE messages (

id INT AUTO_INCREMENT PRIMARY KEY,

sender_id INT NOT NULL,

receiver_id INT NOT NULL,

content TEXT NOT NULL,

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

FOREIGN KEY (sender_id) REFERENCES users(id),

FOREIGN KEY (receiver_id) REFERENCES users(id)

);

session_start();

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

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

$username = $_POST['username'];

$password = $_POST['password'];

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

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

$stmt->execute();

$result = $stmt->get_result();

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

if (password_verify($password, $row['password'])) {

$_SESSION['user_id'] = $row['id'];

echo "登录成功！";

} else {

echo "密码错误！";

统一消息

}

} else {

echo "用户名不存在！";

}

$stmt->close();

}

?>