通过单击按钮 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

    <?php

session_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>&nbsp; &nbsp; &nbsp; &nbsp; <td>'.$row["ModuleID"] .'</td>&nbsp; &nbsp; &nbsp; &nbsp; <td>'.$row["ModuleName"]. '</td>&nbsp; &nbsp; &nbsp; &nbsp; <td>'.$row["IndexcardSuggestionID"]. '</td>&nbsp; &nbsp; &nbsp; &nbsp; <td>'.$row["FrontContent"]. '</td>&nbsp; &nbsp; &nbsp; &nbsp; <td>'.$row["BackContent"]. '</td>&nbsp; &nbsp; &nbsp; &nbsp; <td> <a href=../Delete/delete.php?id=".' . $row["IndexcardSuggestionID"]. '"\'>DELETE</a></td>&nbsp; &nbsp; &nbsp; &nbsp; <td><input type="button" name="accept" value="Accept"></td>&nbsp; &nbsp; &nbsp; &nbsp; <td><input type="button" name="conditionally" value="Conditionally"></td>&nbsp; &nbsp; &nbsp; &nbsp; </tr>';