관리-도구

편집 파일: all-package.php

<!DOCTYPE html>
<html lang="en" dir="ltr">

<head>
    <?php include('include/head_admin.php');
    if (isset($_GET['type']) && $_GET['type'] != '') {
        $type = get_safe_value($con, $_GET['type']);
        if ($type == 'status') {
            $operation = get_safe_value($con, $_GET['operation']);
            $id = get_safe_value($con, $_GET['id']);
            if ($operation == 'active') {
                $status = '1';
            } else {
                $status = '0';
            }
            $update_status_sql = "update package set status='$status' where id='$id'";
            mysqli_query($con, $update_status_sql);
        }

if ($type == 'delete') {
            $id = get_safe_value($con, $_GET['id']);
            $select_sql = "SELECT image FROM package WHERE id='$id'";
            $result = mysqli_query($con, $select_sql);

if ($result) {
                $row = mysqli_fetch_assoc($result);
                $image_array = json_decode($row['image'], true); // Decode JSON array

// Step 2: Delete record from the database
                $delete_sql = "DELETE FROM package WHERE id='$id'";
                mysqli_query($con, $delete_sql);

// Step 3: Unlink the image files from the storage
                $uploadsDirectory = '../media/package/';

foreach ($image_array as $filename) {
                    $filePath = $uploadsDirectory . $filename;

// Check if the file exists before attempting to delete it
                    if (file_exists($filePath)) {
                        unlink($filePath); // Delete the file
                        echo "Image file $filename deleted successfully<br>";
                    } else {
                        echo "Image file $filename not found in the storage<br>";
                    }
                }
                header('location:all-package.php');
            }
        }
    }

$sql = "select * from package order by `id` desc";
    $res = mysqli_query($con, $sql);
    ?>
</head>

<div class="page-wrapper compact-wrapper" id="pageWrapper">
        
        <?php include('include/header_admin.php'); ?>

<div class="page-body-wrapper">
            
            <?php include('include/sidebar_admin.php'); ?>

<div class="page-body">
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="card card-table">
                                <div class="card-body">
                                    <div class="title-header option-title d-sm-flex d-block">
                                        <h5>Packages List</h5>
                                        <div class="right-options">
                                            <ul>
                                                
                                                <li>
                                                    <a class="btn btn-solid" href="add-package.php">Add Package</a>
                                                </li>
                                            </ul>
                                        </div>
                                    </div>
                                    <div>
                                        <div class="table-responsive">
                                            <table class="table all-package theme-table table-package" id="table_id">
                                                <thead>
                                                    <tr>
                                                        <th>#</th>
                                                        <th>Image</th>
                                                        <th>Category</th>
                                                        <th>Name</th>
                                                        <th>Option</th>
                                                    </tr>
                                                </thead>

<tbody>
                                                    <?php
                                                    $i = 1;
                                                    while ($row = mysqli_fetch_assoc($res)) {
                                                        $image = json_decode($row['image']);
                                                    ?>
                                                        <tr>
                                                            <td><?php echo $i++ ?></td>
                                                            <td>
                                                                <div class="table-image">
                                                                    <img src="../media/package/<?= $image[0] ?>" class="img-fluid" alt="">
                                                                </div>
                                                            </td>
                                                            <?php
                                                            $category = $row['category'];
                                                            $sql1 = "SELECT * FROM `category` WHERE `status` = '1' AND `id` = '$category'";
                                                            $res1 = mysqli_query($con, $sql1);
                                                            $row1 = mysqli_fetch_assoc($res1);
                                                            ?>
                                                            <td><?php echo $row1['name'] ?></td>
                                                            <td><?php echo $row['name'] ?></td>

</tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<?php include('include/footer_admin.php'); ?>
            </div>
        </div>
    </div>

<?php include('include/foot_admin.php'); ?>
</body>

</html>