通过单击按钮 PHP PDO（使用分页）和 MySQL 删除行

Question

当我单击删除按钮时，没有任何变化，并且不会删除记录。我在哪里做错了？我尝试了一些解决方案，但仍然无法解决。如果我能得到帮助会很好。  //thats the indexcards.php    while ($row = $sql->fetch(PDO::FETCH_ASSOC)){     echo'<tr>    <td>'.$row["ModuleID"] .'</td>    <td>'.$row["ModuleName"]. '</td>     <td>'.$row["IndexcardSuggestionID"]. '</td>     <td>'.$row["FrontContent"]. '</td>    <td>'.$row["BackContent"]. '</td>     <td> <a href=../Delete/delete.php?id=". row[\"IndexcardSuggestionID\"]. "\'>DELETE</a></td>    <td><input type="button" name="accept" value="Accept"></td>    <td><input type="button" name="conditionally" value="Conditionally"></td>     </tr>';   // And thats the delete.php    <?phpsession_start();include_once '../../config/connection.php';$database = new Database();$db = $database->getConnection();$id = $_GET['id']; $sql = "DELETE FROM IndexcardSuggestions WHERE IndexcardSuggestionsID = $id"; header('Location: ../Suggestions/indexcards.php');  ?>

Answer 1

您没有正确传递 ID。请注意，您不能在单引号内使用 PHP 变量，所有内容都被视为字符串。此外，如评论中所述，您的代码容易受到MySQL injection的攻击。

echo'<tr>

        <td>'.$row["ModuleID"] .'</td>

        <td>'.$row["ModuleName"]. '</td>

        <td>'.$row["IndexcardSuggestionID"]. '</td>

        <td>'.$row["FrontContent"]. '</td>

        <td>'.$row["BackContent"]. '</td>

        <td> <a href=../Delete/delete.php?id=".' . $row["IndexcardSuggestionID"]. '"\'>DELETE</a></td>

        <td><input type="button" name="accept" value="Accept"></td>

        <td><input type="button" name="conditionally" value="Conditionally"></td>

        </tr>';