sql查询与更新 测试OK

<?PHP
$haoma = "18771431684";
$jine="80";

 

$con = mysql_connect("localhost","myscvZYEi24","mgkQQt6fC9duHf4f1I7");//mysql方式链接数据库

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

$a    =    mysql_select_db("myscvZYEi24", $con);

$sql    =    "select * from xy_user where user_name = '$haoma'";

$result = mysql_query($sql);

while($row = mysql_fetch_array($result))

{

echo $row['user_money'] . " " . $row['user_id']. " " . $row['user_name'];

echo "
";

}

mysql_close($con);

echo "ok"

//user_money       decimal(10,1)    精确小数型数据
//user_name       varchar(20)     字符型数据
?>

 

 

 

 

更新

 

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

//下面是解析json
$data = json_decode($res, true);

    
    

//下面是保存￥res到目录下的newfile.txt文件  确认是否接受到东西
$content = $data['originalprice'].$data['thirduid'];

$jine = $data['originalprice'];//实际支付金额

$haoma = $data['thirduid'];//用户账号

$file1 = 'newfile.txt';

$fp = fopen($file1, 'w');

fwrite($fp, $haoma);

fclose($fp);

//保存文本

echo "ok";

 

$con=mysqli_connect("localhost","myscvZYEi24","mgkQQt6fC9duHf4f1I7","myscvZYEi24");//创建MySQL连接
// 检测连接
if (mysqli_connect_errno())
{
    echo "连接失败: " . mysqli_connect_error();
        
}

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

mysqli_close($con);
?>