I new to php, need so help with my script.
In my scrip I can display on page records from database and images. I can do multi delete the checked records from database. I am stack with how to add code to delete the checked images from the directory folder. I know will be best to delete images first and then the record from the directory. Where to stat?
Thanks for help
Image File path sample:
foto/data/20210615-01c2-f9-image.jpg.bak
20210615-01c2 stored as AutoID column
image.jpg stored as Foto column
f9 is name of field form when the record is created. not stored in any table column.
my script
<!-- Item data list -->
<form name="bulk_action_form" action="" method="post" onSubmit="return delete_confirm();"/>
<input type="submit" class="btn btn-danger" name="bulk_delete_submit" value="Delete Selected"/>
<table class="bordered">
<thead>
<tr>
<th><input type="checkbox" id="select_all" value=""/></th>
<th>Date</th>
<th>Item</th>
<th>ID</th>
</tr>
</thead>
<tbody>
<?php
// Include the database configuration file
include_once 'dbConfig.php';
// Get item from the database
$query = $db->query("SELECT * FROM `datawaznosci` ORDER BY `datawaznosci`.`Data` ASC LIMIT 200;");
// List all records
if($query->num_rows > 0){
while($row = $query->fetch_assoc()){
?>
<tr>
<td><input type="checkbox" name="checked_id[]" class="checkbox" value="<?php echo $row['id']; ?>"/></td>
<td><?php echo $row['Date']; ?></td>
<td><img src="foto/data/<?php echo $row['AutoID']; ?>-f9-<?php echo $row['Foto']; ?>.bak" ></td>
<td><?php echo $row['id']; ?><br><?php echo $row['AutoID']; ?></td>
</tr>
<?php } }else{ ?>
<tr><td colspan="5">No recored</td></tr>
<?php } ?>
</tbody>
</table>
<input type="submit" class="btn btn-danger" name="bulk_delete_submit" value="Delete Selected"/>
</form>
The action file
if(isset($_POST['bulk_delete_submit'])){
if(!empty($_POST['checked_id'])){
$idStr = implode(',', $_POST['checked_id']);
$delete = $db->query("DELETE FROM datawaznosci WHERE id IN ($idStr)");
if($delete){
$statusMsg = 'Selected items deteled';
}else{
$statusMsg = 'Error, try later';
}
}else{
$statusMsg = 'Select minimum one item to delete.';
}
}
source https://stackoverflow.com/questions/68957974/multi-delete-record-from-database-and-image-file-from-directory
Comments
Post a Comment