mysql语句

<?php/** * Created by PhpStorm. * User: Administrator * Date: 2017/10/9 0009 * Time: 下午 3:46 */require 'connect.php';session_start();//$select = $_POST['select'];$select = 60;$openid = $_SESSION['openid'];//第一种，概率一样function same_prob($select){    global $con, $openid;    $judge = 0;    $randNum = mt_rand(1, 100);             //抽取随机数    if ($randNum <= $select) {        //抓中哪个，id多少        $goods_array = array('10'=>10,'20'=>20,'30'=>30,'40'=>40,'50'=>50,'60'=>60,'70'=>70,'80'=>80,'90'=>90,'100'=>100);        $prize = array_rand($goods_array);        //修改数据库        mysqli_query($con,"UPDATE  user_info SET balance = balance + $prize - 1 WHERE openid = '$openid'");        /*$sql = mysqli_query($con,"SELECT balance FROM user_info WHERE openid = '$openid'");        $result = mysqli_fetch_array($sql);        echo $result['balance'];*/        $judge = $prize;    } else {        //未抓中        mysqli_query($con,"UPDATE  user_info SET balance = balance - 1 WHERE openid = '$openid'");    }    echo $judge;}//第二种，概率不一样function diff_prob($select){    global $con, $openid;    $judge = 0;    $randNum = mt_rand(1, 100);             //抽取随机数    if ($randNum <= $select)   //抓中    {        $goods_array = array('10'=>10,'20'=>20,'30'=>30,'40'=>40,'50'=>50,'60'=>60,'70'=>70,'80'=>80,'90'=>90,'100'=>100);        $proSum = array_sum($goods_array);  //求和        foreach ($goods_array as $key => $value)        {            $randNum = mt_rand(1, $proSum);            if ($randNum <= (110-$value)) //抓中某一个            {                $judge = $key;                mysqli_query($con,"UPDATE  user_info SET balance = balance + $key - 1 WHERE openid = '$openid'");                break;            }else            {                $proSum -= (110-$value);            }        }        //$prize = array_rand($goods_array);        //修改数据库        //mysqli_query($con,"UPDATE  user_info SET balance = balance + $prize - 1 WHERE openid = '$openid'");        /*$sql = mysqli_query($con,"SELECT balance FROM user_info WHERE openid = '$openid'");        $result = mysqli_fetch_array($sql);        echo $result['balance'];*/    } else {        $judge = 0;  //未抓中        mysqli_query($con,"UPDATE  user_info SET balance = balance - 1 WHERE openid = '$openid'");    }    echo $judge;}same_prob($select);//diff_prob($select);