改下$sql ="UPDATE sss SET";
$sql .=" name=$f_name,";
$sql .="address = $f_address,";
$sql .="tel = $f_tel";
$sql .=" WHERE id='$f_id'";
$sql .=" name=$f_name,";
$sql .="address = $f_address,";
$sql .="tel = $f_tel";
$sql .=" WHERE id='$f_id'";
$sql .=" name='$f_name',";
$sql .="address ='$f_address',";
$sql .="tel = '$f_tel'";
$sql .=" WHERE id='$f_id'";
这个没有错,我就是这样写的,但还是不对,修改不了数据
$sql .=" name='$f_name',";
$sql .="address ='$f_address',";
$sql .="tel = '$f_tel'";
$sql .=" WHERE id='$f_id'";
我这样也写过,还是修改不了。
<?php
$f_name = $_POST['f_name'];
$f_address = $_POST['f_address'];
$f_tel = $_POST['f_tel'];
$f_id = $_POST['f_id'];
if(!empty($f_name))
{
function db_connect()
{
$db =@ new mysqli("127.0.0.1","root","","wangliuwei");
if(mysqli_connect_errno())
{
echo"数据库连接失败!<br>\n";
echo mysqli_connect_error();
exit;
}
return $db;
}
$db = db_connect();
$sql= "UPDATE sss SET";
$sql.="name='$f_name',";
$sql.="address = '$f_address',";
$sql.="tel = '$f_tel' ";
$sql.="WHERE id='$f_id'";
$rs =$db->query($sql);
if($rs)
echo '成功';
else
echo '失败';
$db->close();
}
?>
$sql .=" name='$f_name',";
$sql .="address ='$f_address',";
$sql .="tel = '$f_tel'";
$sql .=" WHERE id='$f_id'";
echo $sql;//将输出结果MYSQL上执行,看能执行不?
显示的是这样的结果
name(varchar);
address(varchar);
tel(int);
update sss set name='wanglove',address = 'hehehehe',tel = 1234 WHERE id='2';
你的tel字段是什么类型,varchar类型的话也要加上''。
update sss set name='wanglove',address = 'hehehehe',tel = 1234 WHERE id='2';
错误在这个地方了
UPDATE sss SETname='wanglove',address = 'hehehehe',tel = 1234 WHERE id='2'失败
↑
这里要有空格