PHP carousel lottery interface example, php carousel lottery_PHP tutorial

/*session_start();
if(!isset($_SESSION['zaszh_user_id'])){
echo json_encode(array('status'=>'error','msg'=>'Connection timed out, please reopen the page.'));
exit;
}
$user_id = $_SESSION['zaszh_user_id'];*/

$user_id = 1; // For testing

// Carousel area
$arr_area = array(
'0' => array('min_angle'=>1,'max_angle'=>45,'prize'=>'Xiaomi'),
'1' => array('min_angle'=>46,'max_angle'=>90,'prize'=>'Polaroid'),
'2' => array('min_angle'=>91,'max_angle'=>135,'prize'=>'10 yuan phone fee'),
'3' => array('min_angle'=>136,'max_angle'=>180,'prize'=>'5 yuan phone fee'),
'4' => array('min_angle'=>181,'max_angle'=>225,'prize'=>'Thank you for participating'),
'5' => array('min_angle'=>226,'max_angle'=>270,'prize'=>'Thank you for participating'),
'6' => array('min_angle'=>271,'max_angle'=>315,'prize'=>'Thank you for participating'),
'7' => array('min_angle'=>316,'max_angle'=>360,'prize'=>'Thank you for participating')
);

// Selected area
$area_selected = array();
// Randomly draw
$num_rand = mt_rand(1,10);
switch($num_rand){
// Xiaomi
Case 1: $area_selected = $arr_area[0]; break;
// Polaroid
Case 2: $area_selected = $arr_area[1]; break;
// 10 yuan phone fee
Case 3: $area_selected = $arr_area[2]; break;
// 5 yuan phone fee
Case 4: $area_selected = $arr_area[3]; break;
//Thank you for participating
default:
          switch(mt_rand(1,4)){ 
                case 1: $area_selected = $arr_area[4]; break;
case 2: $area_selected = $arr_area[5]; break;
case 3: $area_selected = $arr_area[6]; break;
case 4: $area_selected = $arr_area[7]; break;
                                                                                                              break;
}
echo $area_selected['prize'];

require('connect_database.php');
// Deduct points for answering questions
$mysqli->query("update zaszh_user set answer_points=answer_points-5 where id='{$user_id}' and answer_points>=5");
if($mysqli->affected_rows){
// There are points
// Record points consumption
$mysqli->query("insert into zaszh_answer_points_consume(user_id,points_consume,consume_for,create_date) values('{$user_id}',5,'lottery',unix_timestamp(now()))");
Switch($area_selected['prize']){
case 'Xiaomi':
                 $mysqli->query("update zaszh_prize_surplus set surplus=surplus-1 where prize='Xiaomi' and surplus>0");
If($mysqli->affected_rows){
                                                                                                                                                                                               $mysqli->query("insert into zaszh_award(user_id,prize,create_date) values('{$user_id}','Xiaomi',unix_timestamp(now()))");
If($mysqli->affected_rows){
echo json_encode(array('status'=>'success','msg'=>'Xiaomi'));
                                                                                                              // Failed to win
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             break;
case 'Polaroid':
                 $mysqli->query("update zaszh_prize_surplus set surplus=surplus-1 where prize='Polaroid' and surplus>0");
If($mysqli->affected_rows){
                                                                                                                                                                                having having having remaining
                     $mysqli->query("insert into zaszh_award(user_id,prize,create_date) values('{$user_id}','Polaroid',unix_timestamp(now()))");
If($mysqli->affected_rows){
echo json_encode(array('status'=>'success','msg'=>'Polaroid'));
                                                                                                              // Failed to win
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             break;
          case '10 yuan phone bill':
                  $mysqli->query("update zaszh_telephone_charge_surplus set charge_surplus=charge_surplus-10 where date=substring(now(),1,10) and charge_surplus>=10");
If($mysqli->affected_rows){
                                                                                                                                                                               having having having having remaining
                    $mysqli->query("insert into zaszh_award(user_id,prize,create_date) values('{$user_id}','10 yuan phone fee',unix_timestamp(now()))");
If($mysqli->affected_rows){
                                                                                                                         echo json_encode(array('status'=>'success','msg'=>'10 yuan phone fee'));
                                                                                                              // Failed to win
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   break;
           case '5 yuan call fee':
                  $mysqli->query("update zaszh_telephone_charge_surplus set charge_surplus=charge_surplus-5 where date=substring(now(),1,10) and charge_surplus>=5");
If($mysqli->affected_rows){
                                                                                                                                                                                             $mysqli->query("insert into zaszh_award(user_id,prize,create_date) values('{$user_id}','5 yuan phone fee',unix_timestamp(now()))");
If($mysqli->affected_rows){
                                            echo json_encode(array('status'=>'success','msg'=>'5 yuan phone fee'));
                                                                                                               // Failed to win
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        break;
default:
echo json_encode(array('status'=>'success','msg'=>'Thank you for participating'));
}  
}else{
// No points
echo json_encode(array('status'=>'error','msg'=>'You have insufficient points.'));
}
$mysqli->close();


I hope this article will be helpful to everyone’s PHP programming design.