📁 File Manager
Editing:
/home/wedigitalindia/www/jaybalajiassociates.com/admin/viewslider.php
<?php declare(strict_types=1); // ======================================== // 1. SESSION AND DATABASE // ======================================== if (session_status() !== PHP_SESSION_ACTIVE) { session_start(); } require_once "connection.php"; // ======================================== // 2. ADMIN AUTHENTICATION // ======================================== if ( !isset($_SESSION['admin_id']) || !is_int($_SESSION['admin_id']) || $_SESSION['admin_id'] <= 0 || ($_SESSION['start'] ?? false) !== true ) { header("Location: login.php"); exit; } // ======================================== // 3. CSRF TOKEN // ======================================== if (empty($_SESSION['csrf_token'])) { $_SESSION['csrf_token'] = bin2hex(random_bytes(32)); } // ======================================== // 4. SAFE IMAGE URL FUNCTION // ======================================== function getSliderImageUrl(?string $filename): ?string { if ( empty($filename) || basename($filename) !== $filename || !preg_match( '/\A[a-zA-Z0-9._-]+\.(jpg|jpeg|png|webp)\z/i', $filename ) ) { return null; } return "./assets/images/slider/" . rawurlencode($filename); } // ======================================== // 5. FETCH SLIDER RECORDS // ======================================== $query = "SELECT id, Image, PImage FROM slider ORDER BY id DESC"; $sql = mysqli_query($con, $query); if (!$sql) { error_log("Slider Fetch Error: " . mysqli_error($con)); http_response_code(500); exit("Unable to load slider records."); } include("header.php"); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>View Slider</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="shortcut icon" href="../images/logo.png"> <!-- Bootstrap CSS --> <link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet"> <!-- Icons CSS --> <link href="assets/css/icons.min.css" rel="stylesheet"> <!-- App CSS --> <link href="assets/css/app.min.css" id="app-style" rel="stylesheet"> <style> .slider-image { width: 150px; height: 110px; object-fit: contain; border: 1px solid #ddd; border-radius: 6px; padding: 5px; background: #fff; } .search-box { max-width: 300px; } .action-buttons { display: flex; gap: 6px; flex-wrap: wrap; } .table td { vertical-align: middle; } </style> </head> <body data-sidebar="dark"> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <!-- ======================================== PAGE TITLE ========================================= --> <div class="row"> <div class="col-12"> <div class="page-title-box d-sm-flex align-items-center justify-content-between"> <h4 class="mb-sm-0 font-size-18"> View Slider </h4> </div> </div> </div> <!-- ======================================== SLIDER TABLE ========================================= --> <div class="row"> <div class="col-lg-12"> <div class="card"> <div class="card-body"> <!-- SEARCH AND ADD BUTTON --> <div class="row mb-2"> <div class="col-sm-6 mt-3"> <div class="search-box me-2 d-inline-block"> <div class="position-relative"> <input type="text" class="form-control" autocomplete="off" id="searchInput" placeholder="Search..." onkeyup="searchTable()"> <i class="bx bx-search-alt search-icon"></i> </div> </div> </div> <div class="col-sm-6 mt-3"> <div class="text-sm-end"> <a href="addslider.php" class="btn btn-success btn-rounded waves-effect waves-light mb-2"> <i class="mdi mdi-plus me-1"></i> Add Slider </a> </div> </div> </div> <!-- ======================================== TABLE ========================================= --> <div class="table-responsive"> <table class="table align-middle table-nowrap table-hover dt-responsive nowrap w-100" id="userList-table"> <thead class="table-light"> <tr> <th scope="col"> S.No </th> <th scope="col"> Desktop Image </th> <th scope="col"> Phone Image (Optional) </th> <th scope="col" style="width:200px"> Action </th> </tr> </thead> <tbody id="sliderTableBody"> <?php $serial = 1; if (mysqli_num_rows($sql) > 0): while ($row = mysqli_fetch_assoc($sql)): $sliderId = (int)$row['id']; $desktopImage = getSliderImageUrl( $row['Image'] ); $phoneImage = getSliderImageUrl( $row['PImage'] ); ?> <tr> <!-- SERIAL NUMBER --> <td> <?php echo $serial++; ?> </td> <!-- DESKTOP IMAGE --> <td> <?php if ($desktopImage): ?> <img src="<?php echo htmlspecialchars( $desktopImage, ENT_QUOTES, 'UTF-8' ); ?>" class="slider-image" alt="Desktop slider image" loading="lazy"> <?php else: ?> <span class="badge bg-danger"> No valid image </span> <?php endif; ?> </td> <!-- PHONE IMAGE --> <td> <?php if ($phoneImage): ?> <img src="<?php echo htmlspecialchars( $phoneImage, ENT_QUOTES, 'UTF-8' ); ?>" class="slider-image" alt="Phone slider image" loading="lazy"> <?php else: ?> <span class="badge bg-secondary"> Not set </span> <?php endif; ?> </td> <!-- ACTION BUTTONS --> <td> <div class="action-buttons"> <!-- EDIT BUTTON --> <a href="editslider.php?id=<?php echo $sliderId; ?>" class="btn btn-primary btn-rounded"> <i class="far fa-edit"></i> Edit </a> <!-- DELETE FORM (POST + CSRF) --> <form method="POST" action="deleteslider.php" onsubmit="return confirm('Are you sure you want to delete this slider?');"> <input type="hidden" name="id" value="<?php echo $sliderId; ?>"> <input type="hidden" name="csrf_token" value="<?php echo htmlspecialchars( $_SESSION['csrf_token'], ENT_QUOTES, 'UTF-8' ); ?>"> <button type="submit" name="delete" value="1" class="btn btn-danger btn-rounded"> <i class="fas fa-trash"></i> Delete </button> </form> </div> </td> </tr> <?php endwhile; else: ?> <tr> <td colspan="4" class="text-center"> <div class="py-4"> <i class="mdi mdi-image-off font-size-24 text-muted"></i> <p class="text-muted mb-0"> No slider data found. </p> </div> </td> </tr> <?php endif; ?> </tbody> </table> </div> <!-- END TABLE RESPONSIVE --> </div> </div> </div> </div> </div> </div> <!-- FOOTER --> <?php include("footer.php"); ?> </div> <!-- ======================================== JAVASCRIPT ========================================= --> <script src="assets/libs/jquery/jquery.min.js"></script> <script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script> <script src="assets/js/app.js"></script> <script> // ======================================== // SEARCH SLIDER TABLE // ======================================== function searchTable() { let input = document.getElementById("searchInput"); let filter = input.value.toLowerCase(); let table = document.getElementById("userList-table"); let rows = table.getElementsByTagName("tbody")[0] .getElementsByTagName("tr"); for (let i = 0; i < rows.length; i++) { let rowText = rows[i].textContent.toLowerCase(); if (rowText.includes(filter)) { rows[i].style.display = ""; } else { rows[i].style.display = "none"; } } } </script> </body> </html>
Save
Cancel