CREATE TABLE students (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

major VARCHAR(50),

phone VARCHAR(15)

);

]]>

function registerEvent($eventId, $studentId) {

// 查询学生是否已注册该活动

$query = "SELECT * FROM events WHERE id = ? AND students_registered LIKE '%{$studentId}%'";

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

$stmt->execute([$eventId]);

if ($stmt->rowCount() > 0) {

return "您已报名此活动，请勿重复提交。";

}

// 更新已注册学生名单

$updateQuery = "UPDATE events SET students_registered = CONCAT(students_registered, ',', ?) WHERE id = ?";

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

$stmt->execute([$studentId, $eventId]);

return "报名成功！";

}

]]>

class NotificationService {

public static function sendNotification($message, $recipients) {

foreach ($recipients as $recipient) {

// 假设这里使用Redis作为消息队列

Redis::publish('notifications', json_encode([

'to' => $recipient,

'message' => $message

]));

}

}

}

]]>