我想在PHP文件中写这条SQL行(UPDATEuser
SETlastname
='zehri',adress
='tunisie'WHEREuser
。iduser
= 5;)
发布于 2018-05-30 11:55:06
$stmt = $conn->prepare("UPDATE user SET lastname = 'zehri', adress = 'tunisie' WHERE iduser = 5");
$stmt->execute();
我建议你使用prepared语句(Sql注入问题)
$name = "zehri";
$adress = "tunisie";
$id = 5;
$stmt = $conn->prepare("UPDATE user SET lastname = ?, adress = ? WHERE iduser = ?");
$stmt->bind_param("ssi", $name, $address,$id);
$stmt->execute();
发布于 2018-05-30 13:09:23
可以在一个函数中编写你的SQL,或者只是调用$sql
来执行脚本
$sql=UPDATE user SET lastname = 'zehri', adress = 'tunisie' WHERE user.iduser = 5;
https://stackoverflow.com/questions/-100005272
复制相似问题