update 没报错,但数据没更新
数据库名: game_download 表名:basic 想更新字段名:click_count
有如下语句:
@ $db=new mysqli('localhost','download','download123','game_download'); //实例化对象,建立连接
$db->query("set names 'GBK' ");
if(mysqli_connect_error()) //检测连接是否有误
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$id=$_GET['id'];
$query = "SELECT * FROM `basic` WHERE id =".$id;
$result=$db->query($query);
$row=$result->fetch_assoc();
$click_count=$row['click_count']+1;
$update="UPDATE `basic` SET click_count=".$click_count."WHERE id=".$id;
$db->query($update);