Edit File - del_multi_image.php

<?php
// Database configuration
//$dbHost     = "localhost";
//$dbUsername = "root";
//$dbPassword = "";

$dbHost     = "127.0.0.1:3306";
$dbUsername = "u318955861_brgs";
$dbPassword = "Brgs@3210@";
$dbName     = "u318955861_brgs";

// Create database connection
$db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);

// Check connection
if ($db->connect_error) {
    die("Connection failed: " . $db->connect_error);
}
?>

<?php if(!empty($statusMsg)){ ?>
<div class="alert alert-success"><?php echo $statusMsg; ?></div>
<?php } ?>
<?php
//include("cgi/config.php");

if(isset($_POST['bulk_delete_submit'])){ 
    // If id array is not empty 
    if(!empty($_POST['checked_id'])){ 
        // Get all selected IDs and convert it to a string 
        $idStr = implode(',', $_POST['checked_id']); 
         
        // Delete records from the database 
        $delete = $db->query("DELETE FROM image_category WHERE s_no IN ($idStr)"); 
         
        // If delete is successful 
        if($delete){ 
           echo "<script> alert('Deleted'); 
window.location.replace('image_bank.php');
</script>";
        }else{ 
            $statusMsg = 'Some problem occurred, please try again.'; 
        } 
    }else{ 
echo "<script> alert('Deleted'); 
window.location.replace('image_bank.php');
</script>";
    } 
}

//category_image  image_bank.php
?>

Kembali