我希望表中的每一行都有一個洗掉按鈕，例如當單擊第 1 行中的按鈕時，洗掉第 1 行。
如果你知道如何而不是洗掉，那么當我按下按鈕時，表中的值會發生變化。例如，當單擊洗掉 btn 時，表中的值“OK”更改為“DELETED”。
該代碼適用于放入 delete.php 檔案中的特定 id。
我對資料庫安全性不感興趣，我只是想找到一種讓它作業的方法。
索引.php
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "userform";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT name, email, code, status, lname, checkin, checkout, mnumber, totalprice, rescode FROM usertable";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo '
<table>
<tr>
<td>Fullname</td>
<td>', $row['name'] . $row['lname'], '</td>
</tr>
<br>
<tr>
<td>Email address</td>
<td>', $row['email'], '</td>
</tr>
<br>
<tr>
<td>Reservation ID</td>
<td>', $row['rescode'], '</td>
</tr>
<br>
<tr>
<td>Check-in</td>
<td>', $row['checkin'], '</td>
</tr>
<br>
<tr>
<td>Check-out</td>
<td>', $row['checkout'], '</td>
</tr>
<br>
<tr>
<td>Mobile number</td>
<td>', $row['mnumber'], '</td>
</tr>
<br>
<tr>
<td>Total price</td>
<td>', $row['totalprice'], '</td>
<td><a href="delete.php">Cancel</a></td>
</tr>
</table>';
}
} else {
echo "0 results";
}
$conn->close();
?>
<script>
洗掉.php
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "userform";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT name, email, code, status, lname, checkin, checkout, mnumber, totalprice, rescode FROM usertable";
$result = $conn->query($sql);
$sql = "DELETE FROM usertable WHERE id='10'";
if ($conn->query($sql) === TRUE) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . $conn->error;
}
$conn->close();
?>
uj5u.com熱心網友回復：
詢問
這個查詢：
$sql = "SELECT name, email, code, status, lname, checkin, checkout, mnumber, totalprice, rescode FROM usertable";
$result = $conn->query($sql);
應該
$sql = "SELECT id, name, email, code, status, lname, checkin, checkout, mnumber, totalprice, rescode FROM usertable";
$result = $conn->query($sql);
洗掉鏈接
這個html代碼
<td><a href="delete.php">Cancel</a></td>
應該
<td><a href="delete.php?id=' . $row['id'] . '">Cancel</a></td>
請...檢查您的代碼：您使用“，”而不是“。”來連接字串。
最后
此 SQL 代碼
$sql = "DELETE FROM usertable WHERE id='10'";
應該
$sql = "DELETE FROM usertable WHERE id='" . $_GET['id'] . "'";
uj5u.com熱心網友回復：
試試這個：在 index.php 中，
- 在sql中添加'id'。$sql = "SELECT id, name, email, code, status, lname, checkin, checkout, mnumber, totalprice, rescode FROM usertable";
- 比在取消鏈接中傳遞 id，即 href="delete.php?id=".$row['id']
在 delete.php 中，添加這一行 $id= $GET['id']; 并通過 $id 洗掉查詢， $sql = "DELETE FROM usertable WHERE id=$id";
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/411783.html
標籤：
上一篇：在插入觸發器后更新另一個表的列值