我在嘗試使用PHP中創建刪除表單以使用提供給客人的ID刪除數據時遇到問題。我是這種東西的新手。這是錯誤：Error: DELETE FROM MyGuests WHERE id= LIMIT 1You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 1這是我的刪除.php：<?phpinclude_once('mysql.php');$ins= "DELETE FROM MyGuests WHERE id=$id LIMIT 1";if ($conn->query($ins) === TRUE) { echo "Record deleted successfully";} else { echo "Error: " . $ins . "<br>" . $conn->error;}?><!DOCTYPE html><html><body><a href='index.php'>Home</a><br><h2>Delete User</h2><form action="/delete.php" method="post"> Guest ID:<br> <input type="text" name="id" > <br><br> <input type="submit" value="Submit"></form> </body></html>
創建刪除 php 表單
慕田峪4524236
2022-09-03 17:43:21
