php - 如何一次取消链接多个图像？

Question

我有这段代码，它会从我的数据库中删除具有类别名称的图像，但它只会从我的图像文件夹中取消链接一张图像，但我需要它一次取消链接多张图像，任何人都可以帮助这里是我的代码示例。

if(isset($_GET['delete'])) {

    $delete_id = $_GET['delete'];

    $sql = "SELECT image FROM images WHERE category = '$delete_id'";

    $query = mysqli_query($connection,$sql) or die (mysqli_error());

    while ($row = mysqli_fetch_array($query)){

        $image = $row['image'];

        $location_full_image = "../images/$image";

        $location_thumb_image = "../images/thumbnails/$image";

        @unlink($location_full_image); 

        @unlink($location_thumb_image); 

        $sql = "DELETE FROM images WHERE category = '$delete_id'";

        $query = mysqli_query($connection,$sql) or die (mysqli_error());

    } 

}

Answer 1

尝试下面的代码并确保您从包含图像名称的数据库中获取正确的列。

 if(isset($_GET['delete'])) {

$delete_id = $_GET['delete'];

$sql = "SELECT image FROM images WHERE category = '$delete_id'";

$query = mysqli_query($connection,$sql) or die (mysqli_error());

while ($row = mysqli_fetch_array($query)){

    $image = $row['image'];

    @unlink('../images/'.$image); 

    @unlink('../images/thumbnails/'.$image); 

    $sql = "DELETE FROM images WHERE category = '$delete_id'";

    $query = mysqli_query($connection,$sql) or die (mysqli_error());

} 

}