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/chikhalikar.com/public_html

Free Space:

8.28 TB

🔧 Quick Actions

✏️ Editing: explore.php

<?php
require_once 'config.php';

$page_title = 'Explore Local Directory in Chikhali | ' . APP_NAME;

// --- Search & Filter Parameters (5.2) ---
$search_query = trim($_GET['q'] ?? '');
$category_filter = $_GET['cat'] ?? '';
$sort_order = $_GET['sort'] ?? 'featured'; // 'featured' or 'latest'

// --- Pagination (5.2) ---
$per_page = 12;
$current_page = max(1, (int)($_GET['page'] ?? 1));
$offset = ($current_page - 1) * $per_page;

// --- SQL Query Construction ---
$where_clauses = ["status = 'approved'"];
$bindings = [];

// Search Query (5.2)
if (!empty($search_query)) {
    // Add full_name, business_name, slug, category, address LIKE %q%
    $where_clauses[] = "(
        full_name LIKE ? OR 
        business_name LIKE ? OR 
        slug LIKE ? OR 
        category LIKE ? OR 
        address LIKE ?
    )";
    $like_query = '%' . $search_query . '%';
    // Bind five times for the five LIKE clauses
    $bindings = array_merge($bindings, [$like_query, $like_query, $like_query, $like_query, $like_query]);
}

// Category Filter (5.2)
if (!empty($category_filter)) {
    $where_clauses[] = "category = ?";
    $bindings[] = $category_filter;
}

$where_sql = count($where_clauses) > 0 ? "WHERE " . implode(" AND ", $where_clauses) : "";

// Ordering (5.2)
if ($sort_order === 'latest') {
    $order_sql = "ORDER BY created_at DESC";
} else {
    // Default or 'featured'
    $order_sql = "ORDER BY featured DESC, created_at DESC";
}

// --- 1. Get Total Count for Pagination ---
try {
    $count_stmt = $pdo->prepare("SELECT COUNT(*) FROM profiles " . $where_sql);
    $count_stmt->execute($bindings);
    $total_profiles = $count_stmt->fetchColumn();
    $total_pages = ceil($total_profiles / $per_page);
} catch (PDOException $e) {
    error_log("Explore Count DB Error: " . $e->getMessage());
    $total_profiles = 0;
    $total_pages = 0;
    $db_error = true;
}

// --- 2. Fetch Paginated Profiles ---
$profiles = [];
if ($total_profiles > 0) {
    try {
        $limit_sql = "LIMIT :limit OFFSET :offset";
        $sql = "SELECT slug, full_name, business_name, photo_url, category, headline, address, featured FROM profiles {$where_sql} {$order_sql} {$limit_sql}";
        
        $stmt = $pdo->prepare($sql);
        
        // Bind LIMIT/OFFSET last (must use bindValue for LIMIT/OFFSET in PDO)
        $stmt->bindValue(':limit', $per_page, PDO::PARAM_INT);
        $stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
        
        // Bind the dynamic parameters (search/filter)
        foreach ($bindings as $key => $value) {
            // Parameter index starts at 1
            $stmt->bindValue($key + 1, $value, is_int($value) ? PDO::PARAM_INT : PDO::PARAM_STR);
        }

$stmt->execute();
        $profiles = $stmt->fetchAll();
        
    } catch (PDOException $e) {
        error_log("Explore Fetch DB Error: " . $e->getMessage());
        $profiles = [];
        $db_error = true;
    }
}

// --- Fetch all categories for filter dropdown ---
try {
    $category_options = $pdo->query("SELECT DISTINCT category FROM profiles WHERE status = 'approved' AND category IS NOT NULL ORDER BY category ASC")->fetchAll(PDO::FETCH_COLUMN);
} catch (PDOException $e) {
    $category_options = [];
}

// --- HTML Template Inclusion ---
include 'templates/main_template.php';
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: explore.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation