轉盤分 8 個區塊,每區對應獎品與角度範圍。接口需:
WHERE surplus > 0)lottery_get.php<?php
$user_id = 1; // 測試用,實際從 Session 獲取
// 獎品區塊配置:角度範圍 + 獎品名
$arr_area = [
0 => ['min_angle'=>1, 'max_angle'=>45, 'prize'=>'小米手機'],
1 => ['min_angle'=>46, 'max_angle'=>90, 'prize'=>'拍立得'],
2 => ['min_angle'=>91, 'max_angle'=>135, 'prize'=>'10元話費'],
3 => ['min_angle'=>136, 'max_angle'=>180, 'prize'=>'5元話費'],
4 => ['min_angle'=>181, 'max_angle'=>225, 'prize'=>'謝謝參與'],
5 => ['min_angle'=>226, 'max_angle'=>270, 'prize'=>'謝謝參與'],
6 => ['min_angle'=>271, 'max_angle'=>315, 'prize'=>'謝謝參與'],
7 => ['min_angle'=>316, 'max_angle'=>360, 'prize'=>'謝謝參與'],
];
// 加權隨機:1~10 對應不同獎品權重
$num_rand = mt_rand(1, 10);
switch ($num_rand) {
case 1: $area = $arr_area[0]; break; // 小米 10%
case 2: $area = $arr_area[1]; break; // 拍立得 10%
case 3: $area = $arr_area[2]; break; // 10元 10%
case 4: $area = $arr_area[3]; break; // 5元 10%
default: // 60% 謝謝參與
$sub = mt_rand(1, 4);
$area = $arr_area[3 + $sub];
}
// 扣除積分(原子操作)
require 'connect_database.php';
$mysqli->query("UPDATE zaszh_user SET answer_points = answer_points - 5 WHERE id = $user_id AND answer_points >= 5");
if ($mysqli->affected_rows) {
// 記錄積分消耗
$mysqli->query("INSERT INTO zaszh_answer_points_consume (user_id, points_consume, consume_for, create_date) VALUES ($user_id, 5, 'lottery', UNIX_TIMESTAMP())");
// 處理中獎邏輯
$prize = $area['prize'];
switch ($prize) {
case '小米手機':
$mysqli->query("UPDATE zaszh_prize_surplus SET surplus = surplus - 1 WHERE prize = '小米手機' AND surplus > 0");
if ($mysqli->affected_rows) {
$mysqli->query("INSERT INTO zaszh_award (user_id, prize, create_date) VALUES ($user_id, '小米手機', UNIX_TIMESTAMP())");
echo json_encode(['status'=>'success', 'msg'=>'小米手機']);
} else {
echo json_encode(['status'=>'success', 'msg'=>'謝謝參與']); // 庫存不足轉為安慰獎
}
break;
// ... 其他獎品同理
default:
echo json_encode(['status'=>'success', 'msg'=>'謝謝參與']);
}
} else {
echo json_encode(['status'=>'error', 'msg'=>'積分不足']);
}
$mysqli->close();
?>
mt_rand(1,10) 映射不同案例,靈活控制各獎品概率UPDATE ... SET surplus = surplus - 1 WHERE surplus > 0 保證並發安全(user_id, create_date) 防刷