提问人:Aland Ramirez Araiza 提问时间:10/21/2023 最后编辑:Adrian MoleAland Ramirez Araiza 更新时间:10/23/2023 访问量:43
如何根据表中记录的 ID 删除多个图像?
How can I delete multiple images based on an ID of a record from a table?
问:
我有一个系统可以发布带有图像的文章,但是在删除文章时,它只删除了一张图像,而不是从该文章中上传的所有图像。
<?php
include('assets/system/core.php');
$id = $_GET['id'];
$consulta = mysqli_query($db, "SELECT * FROM images WHERE id2 = '$id' ");
$registro = mysqli_fetch_assoc($consulta);
$ruta = $registro['file_name'];
unlink("uploads/".$ruta);
$query = mysqli_query($db,"DELETE FROM amenidades WHERE id = '$id'");
$query2 = mysqli_query($db,"DELETE FROM images WHERE id2 = '$id'");
$query3 = mysqli_query($db,"DELETE FROM propiedades WHERE id = '$id'");
$query4 = mysqli_query($db,"DELETE FROM visit_days WHERE id = '$id'");
$query4 = mysqli_query($db,"DELETE FROM comments WHERE prpdad_id = '$id'");
header("LOCATION: ".$web_settings['weblink']."mispropiedades.php");
如何从数据库中删除与记录对应的所有图像?
答: 暂无答案
评论
$query4