我在“profile_server.php”中有以下代码,但没有将任何内容写入数据库,我无法弄清楚原因。我感谢您的帮助 :
if(isset($_POST['submit'])){
$id = $_SESSION['id']; // Retrieved from previous session
//Declaring variables
$country = mysqli_real_escape_string($db, $_POST['country']);
$province = mysqli_real_escape_string($db, $_POST['province']);
$city = mysqli_real_escape_string($db, $_POST['city']);
$sql_u_details = $db->prepare ("UPDATE user_details
SET (country, province, city)
VALUES (?, ?, ?)
WHERE id = ? ");
$sql_u_details->bind_param("ssss", $country, $province, $city, $id);
$sql_u_details->execute();
mysqli_query($db, $sql_u_details);
}
将您的 sql 语句更改为以下内容:
$sql_u_details = $db->prepare ("UPDATE user_details
SET country = ?, province = ?, city = ?
WHERE id = ?");
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句