PHP 中MySQL 连接，查询，更新操作

最新推荐文章于 2022-10-19 13:44:34 发布

kunpengku

最新推荐文章于 2022-10-19 13:44:34 发布

阅读量671

点赞数

分类专栏：开发中小事 PHP

本文链接：https://blog.csdn.net/u012063703/article/details/42177491

版权

开发中小事同时被 2 个专栏收录

74 篇文章 0 订阅

订阅专栏

PHP

18 篇文章 0 订阅

订阅专栏

$this->con = mysql_connect("10.10.0.1:3306","test","test1234");
if (!$this->con){
	die('Could not connect: ' . mysql_error());
}       
$this->db_selected = mysql_select_db("test",$this->con);
mysql_query("set names utf8");

$sql = "select * from kaifu_num where kaifu_id = $kaifu_id limit 1";
$result = mysql_query($sql, $this->con);
if( !$result )
{
	print 'error'.mysql_error();
}
$row = mysql_fetch_array($result);
if (empty($row))
{
	exit("{\"errno\":\"102\",\"errmsg\":\"502\"}");
} 
$num = $row['num'];


$sql = "update kaifu_num set uid = '$user_id' where id = $num_id ";
$result = mysql_query($sql, $this->con);
if( !$result )
{
	print 'error'.mysql_error();
}