D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
tresboutique.in
/
tresadmin
/
Filename :
banners.php
back
Copy
<?php include 'config.php'; // Handle deletion of a banner if (isset($_GET['delete_id'])) { $deleteId = intval($_GET['delete_id']); $query = "DELETE FROM banners WHERE banner_id = $deleteId"; if (mysqli_query($conn, $query)) { echo '<script>alert("Banner deleted successfully."); window.location.href = "banners.php";</script>'; } else { echo '<script>alert("Error deleting banner: ' . mysqli_error($conn) . '");</script>'; } } // Fetch banners $query = "SELECT * FROM banners"; $result = mysqli_query($conn, $query); ?> <!DOCTYPE html> <html lang="en"> <head> <?php require('style.php'); ?> </head> <body> <div class="page-wrapper compact-wrapper" id="pageWrapper"> <div class="page-body-wrapper"> <!-- Page Sidebar Start --> <?php require('sidebar.php'); ?> <!-- Page Sidebar End --> <div class="page-body"> <div class="container-fluid"> <div class="page-title"> <h3>Banners</h3> </div> </div> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div class="card"> <div class="card-header"> <h5>Banner List</h5> <a href="add_banner.php" class="btn btn-primary float-end">Add Banner</a> </div> <div class="card-body"> <table class="table table-bordered table-striped"> <thead> <tr> <th>ID</th> <th>Name</th> <th>Image</th> <th>Link</th> <th>Actions</th> </tr> </thead> <tbody> <?php if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { echo "<tr> <td>{$row['banner_id']}</td> <td>{$row['banner_name']}</td> <td><img src='uploads/banners/{$row['banner_image']}' alt='{$row['banner_name']}' style='width: 100px; height: 50px;'></td> <td><a href='{$row['banner_link']}' target='_blank'>{$row['banner_link']}</a></td> <td> <a href='edit_banner.php?id={$row['banner_id']}' class='btn btn-success btn-sm'>Edit</a> <a href='banners.php?delete_id={$row['banner_id']}' onclick='return confirm(\"Are you sure you want to delete this banner?\")' class='btn btn-danger btn-sm'>Delete</a> </td> </tr>"; } } else { echo "<tr><td colspan='5' class='text-center'>No banners found</td></tr>"; } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> </div> <?php require('footer.php'); ?> </body> </html>