php - PHP无法从表中删除记录

我正在尝试从疫苗细节表中删除记录，我试图在phpmyadmin中运行delete语句，它运行得很好。但是当我尝试在代码中使用delete语句时，它不会删除记录。

<?php
include('connect-db.php');

if (isset($_GET['id']) && is_numeric($_GET['id']))
{
    $id = $_GET['id'];
    $result = mysql_query("DELETE FROM vaccinedetail WHERE id=$id") or die(mysql_error());
    header("Location: start.php");
}
else
{
    header("Location: displaytype.php");
}
?>

。

<table border='1' cellpadding='10'>
    <tr>
        <th>ID</th>
        <th>Vaccine ID</th>
        <th>疫苗名稱 (繁體)</th>
        <th>疫苗名称 (简体)</th>
        <th>Vaccine Name (Eng)</th>
        <th>Total no of injection</th>
        <th>Nth Injection</th>
        <th>Next Injection Skip</th>
        <th></th>
    </tr>

<?php
include('connect-db.php');

$result = mysql_query("SELECT vaccinedetail.id,vaccinedetail.vaccineid,vaccinedetail.vaccinename1,vaccinedetail.vaccinename2,vaccinedetail.vaccinename3, vaccinedetail.totalnoofinjection,vaccinedetail.nthinjection,vaccinedetail.skip FROM vaccinedetail WHERE vaccinedetail.vaccineid = '" . $_POST['vaccineid'] . "'") or die(mysql_error());
// ^^^ show the specifc type of vaccine taht match the vaccine type in the typeserach.php
?>

<?php
while($row = mysql_fetch_array( $result )) {
?>

    <tr>
        <td><input type="text" name = "id[]" value="<?php echo $row['id'] ?>"</td>
        <td><input type="text" name = "vaccineid[]" value="<?php echo $row['vaccineid'] ?>"</td>
        <td><input type="text" name = "vaccinename1[]" value="<?php echo $row['vaccinename1'] ?>"</td>
        <td><input type="text" name = "vaccinename2[]" value="<?php echo $row['vaccinename2'] ?>"</td>
        <td><input type="text" name = "vaccinename3[]" value="<?php echo $row['vaccinename3'] ?>"</td>
        <td><input type="text" name = "totalnoofinjection[]" value="<?php echo $row['totalnoofinjection'] ?>"</td>
        <td><input type="text" name = "nthinjection[]" value="<?php echo $row['nthinjection'] ?>"</td>
        <td><input type="text" name = "skip[]" value="<?php echo $row['skip'] ?>"</td>

        <!--<td><a href="editdisplaytype.php?id=' . $row['id'] . '"><img src="edit.png" width="20px"></a>-->
        <td><a href="deletedisplaytype.php?id=' . $row['id'] . '"><img src="delete.jpg" width="20px"></a></td>
    </tr>
<?php
}
?>
</table>

最佳答案

您没有在URL上正确传递id。

注意：请不要使用mysql_，它们已被弃用。使用mysqli_或PDO。

更改：

<td><a href="deletedisplaytype.php?id=' . $row['id'] . '"><img src="delete.jpg" width="20px"></a></td>

至：

<td><a href="deletedisplaytype.php?id=<?php echo $row['id'];?>"><img src="delete.jpg" width="20px"></a></td>

否则，代码看起来正确。

关于php - PHP无法从表中删除记录，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/44718093/