php抽奖插件

<?php
function random_prize($prizes) {
    $rand = mt_rand(0, count($prizes) - 1);
    return $prizes[$rand];
}

$prizes = array('一等奖', '二等奖', '三等奖', '谢谢参与');
echo random_prize($prizes);
?>

<?php
// 假设使用MySQL数据库
$mysqli = new mysqli("localhost", "username", "password", "database");

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

$userId = 123; // 用户ID
$sql = "SELECT * FROM `lottery_records` WHERE `user_id` = ? AND `status` = 'won' FOR UPDATE";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("i", $userId);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
    echo "您已经中过奖了！";
} else {
    // 进行抽奖逻辑
    // ...
    $sql = "INSERT INTO `lottery_records` (`user_id`, `prize`, `status`) VALUES (?, ?, 'won')";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param("is", $userId, $prize);
    $stmt->execute();
    echo "恭喜您中奖了！";
}

$mysqli->close();
?>