我在“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);}
1 回答
烙印99
TA貢獻1829條經驗 獲得超13個贊
將你的sql語句改成如下：
$sql_u_details = $db->prepare ("UPDATE user_details
SET country = ?, province = ?, city = ?
WHERE id = ?");- 1 回答
- 0 關注
- 116 瀏覽
添加回答
舉報
0/150
提交
取消