我想在PHP文件中写这条SQL行:
(UPDATE user
SET lastname
='zehri',adress
='tunisie'WHERE user.iduser
= 5;)
发布于 2018-05-30 16:14:20
$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();
https://stackoverflow.com/questions/-100004617
复制相似问题