经典MYsql数据库更新 插入等操作 接收post 解析json

<?php
$res = file_get_contents('php://input');  
var_dump($res);//返回值

//下面是解析json
$data = json_decode($res, true);
$zhifu_money = $data['originalprice'];//实际支付金额
$chongshi_money = $data['price'];//实际充值金额
$haoma = $data['thirduid'];//用户账号
$dingdanhao=$data['orderId'];//充值订单号*/
$dingdanhao=substr($dingdanhao, 0 , 25);//数据库支持25位 所以取25位
$SHIJIAN=time();//获取时间  10位数字

$servername = "localhost";
$username = "mysql22085";
$password = "6P3sSQN6j";
$dbname = "mysql220851_db";

 
// 创建连接  查询数据
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
} 
echo "ok";

$sql = "SELECT * FROM xy_user where user_name = '$haoma'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
        //echo "id: " . $row["user_id"]. " qian: " . $row['user_money']. " " . $row['user_name']. "<br>";
        $user_id=$row["user_id"];//用户id
        $yuanshi_money=$row['user_money'];//原始金额
        $xin_money=$chongshi_money+$yuanshi_money;

        
        echo $user_id;
    }
} else {
    echo "0 结果";
}

//更新充值后用户金额

mysqli_query($conn,"UPDATE xy_user set user_money = '$xin_money' where user_name = '$haoma'");

//插入充值记录数据
$shuoming=$haoma ;//. " " . $chongshi_money充值说明  号码加金额

$sql = "INSERT INTO xy_order_pay (order_id, order_outid, order_name,order_money,order_state,order_payment,order_payment_name,order_atime,order_ptime,order_pstate,user_id,user_name)
VALUES ('$dingdanhao', '20210203220014915', '$shuoming', '$chongshi_money','success', 'wechat', 'wx', '$SHIJIAN', '$SHIJIAN', '1', '$user_id', '$haoma')";
 
if ($conn->query($sql) === TRUE) {
    echo "新记录插入成功";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

//插入充值日志

$sql = "INSERT INTO xy_moneylog (moneylog_type,moneylog_in,moneylog_out,moneylog_now,moneylog_atime,moneylog_text,user_id,user_name)
VALUES ('add', '$chongshi_money', '0', '$xin_money','$SHIJIAN','wechat pay', '$user_id', '$haoma')";

if ($conn->query($sql) === TRUE) {
    echo "新记录插入成功";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>