所以我想用 php 更新 mysql 數據庫中的多行，這段代碼只更新最后一行。我需要添加什么才能更新所有行？ <?php$servername = "localhost";$username = "root";$password = "";$dbname = "cases";$conn = new mysqli($servername, $username, $password, $dbname);if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);} $Famas_Doomkitty_mn = 1,54; $Famas_Doomkitty_ft = 1,46; $Famas_Doomkitty_mnst = 2,57; $Famas_Doomkitty_ftst = 2,42;$sql = "UPDATE esports2013skins SET FAMASDoomkitty='$Famas_Doomkitty_mn' WHERE id=2";$sql = "UPDATE esports2013skins SET FAMASDoomkitty='$Famas_Doomkitty_ft' WHERE id=3";$sql = "UPDATE esports2013skins SET FAMASDoomkitty='$Famas_Doomkitty_mnst' WHERE id=7";$sql = "UPDATE esports2013skins SET FAMASDoomkitty='$Famas_Doomkitty_ftst' WHERE id=8";if ($conn->query($sql) === TRUE) { echo "Record updated successfully";} else { echo "Error updating record: " . $conn->error;}$conn->close();?>
1 回答
互換的青春
TA貢獻1797條經驗 獲得超6個贊
您可以嘗試使用數組和 foreach，如下所示：
$sql_querys = [
"UPDATE esports2013skins SET FAMASDoomkitty='$Famas_Doomkitty_mn' WHERE id=2",
"UPDATE esports2013skins SET FAMASDoomkitty='$Famas_Doomkitty_ft' WHERE id=3",
"UPDATE esports2013skins SET FAMASDoomkitty='$Famas_Doomkitty_mnst' WHERE id=7",
"UPDATE esports2013skins SET FAMASDoomkitty='$Famas_Doomkitty_ftst' WHERE id=8"
];
foreach($sql_querys as $sql){
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
}
- 1 回答
- 0 關注
- 179 瀏覽
添加回答
舉報
0/150
提交
取消