Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/aasthapadghanhospital.com/public_html

Free Space:

8.32 TB

🔧 Quick Actions

✏️ Editing: fetch_gallery.php

<?php
include 'db_connect.php';

$limit = 12; // Number of images per batch
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$category = isset($_GET['category']) ? $_GET['category'] : 'all';
$offset = ($page - 1) * $limit;

// Prepare Query
if ($category == 'all') {
    $sql = "SELECT * FROM gallery ORDER BY id DESC LIMIT $limit OFFSET $offset";
    $count_sql = "SELECT COUNT(*) as total FROM gallery";
} else {
    $category = $conn->real_escape_string($category);
    $sql = "SELECT * FROM gallery WHERE category = '$category' ORDER BY id DESC LIMIT $limit OFFSET $offset";
    $count_sql = "SELECT COUNT(*) as total FROM gallery WHERE category = '$category'";
}

// Get Images
$result = $conn->query($sql);
$images = [];
while ($row = $result->fetch_assoc()) {
    // Set default title if empty
    $row['title'] = !empty($row['title']) ? $row['title'] : $row['category'];
    $images[] = $row;
}

// Get Total Count (to know if we should hide the Load More button)
$total_result = $conn->query($count_sql);
$total_rows = $total_result->fetch_assoc()['total'];
$has_more = ($offset + $limit) < $total_rows;

// Return JSON
header('Content-Type: application/json');
echo json_encode(['images' => $images, 'has_more' => $has_more]);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: fetch_gallery.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation