21,886
社区成员
发帖
与我相关
我的任务
分享
id(int);
name(varchar);
address(varchar);
tel(int);
$sql ="UPDATE sss SET";
$sql .=" name='$f_name',";
$sql .="address ='$f_address',";
$sql .="tel = '$f_tel'";
$sql .=" WHERE id='$f_id'";
echo $sql;//将输出结果MYSQL上执行,看能执行不?
<?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();
}
?>