1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / rinkumehandiartist / domains / rinkumehandiartist.in / private_html / admin /
Filename : gallery_list.php
back
<?php 
  include 'header.php'; 
  include 'include/connection.php';

  // Prepare and execute the query to fetch gallery items
  $query = $conn->prepare("SELECT * FROM gallery ORDER BY id DESC");
  $query->execute();
  $result = $query->fetchAll(PDO::FETCH_ASSOC); // Fetch all rows as associative arrays

  // Count the number of rows in the result
  $row = count($result);
?>

<style>
  .kbox {
    padding: 0 15px !important;
  }
</style>

<div class="content-wrapper">
    <section class="content-header">
        <?php
        // Display any session message (if available)
        if (isset($_SESSION['amsg'])) {
            echo $_SESSION['amsg'];
            unset($_SESSION['amsg']);
        }
        ?>
        <h3 class="box-title">Gallery List</h3>
    </section>

    <section class="content">
        <div class="row">    
            <div class="col-md-12">
                <div class="box box-info">
                    <div class="box-header with-border"></div>
                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>                  
                                <th>SNo.</th>
                                <th>Image</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php     
                            if ($row > 0) {
                                $i = 1; // Initialize serial number
                                foreach ($result as $value) {
                                    ?>
                                    <tr>
                                        <td><?= $i; ?></td>
                                        <td>
                                            <img src="upload/gallery/<?= htmlspecialchars($value['img']); ?>" alt="Gallery Image" width="70px" height="50px">
                                        </td>
                                        <td>
                                            <a onclick="return confirm('Are you sure you want to delete this item?');" href="backend/gallery_delete.php?gid=<?= $value['id']; ?>" class="btn fa fa-trash actionDelete"></a>
                                        </td>
                                    </tr>
                                    <?php
                                    $i++;
                                }
                            } else {
                                // Show a message if no images are found
                                echo '<tr><td colspan="3">No images found in the gallery.</td></tr>';
                            }
                            ?>                  
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </section>
</div>

<?php include 'footer.php'; ?>