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);