Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/ecom

Free Space:

10.24 TB

🔧 Quick Actions

✏️ Editing: top_banner.php

<?php
header("Content-Type: application/json");
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: GET");

// Database configuration
$host = 'localhost';
$dbname = 'u329947844_ranjith';
$username = 'u329947844_ranjith';
$password = 'Ariharan@2025';

try {
    // Create PDO connection
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// Fetch all banners
    $bannersStmt = $pdo->query("SELECT * FROM top_banners ORDER BY created_at DESC");
    $banners = $bannersStmt->fetchAll(PDO::FETCH_ASSOC);

$response = [];
    
    foreach ($banners as $banner) {
        $bannerData = [
            'id' => (int)$banner['id'],
            'backgroundImage' => $banner['background_style'],
            'title' => $banner['title'],
            'subtitle' => $banner['subtitle'],
            'description' => $banner['description'],
            'button' => [
                'text' => $banner['button_text'],
                'url' => $banner['button_url']
            ],
            'products' => []
        ];

// Fetch 4 products matching the banner's category_id
        if (!empty($banner['category_id'])) {
            // Try three different methods to find products
            $products = [];
            
            // Method 1: Using category_products table
            $stmt = $pdo->prepare("
                SELECT p.id, p.title, p.price, p.compare_price, 
                (SELECT image_path FROM product_variant_images pvi 
                 JOIN product_variants pv ON pvi.variant_id = pv.id 
                 WHERE pv.product_id = p.id LIMIT 1) as image
                FROM products p
                JOIN category_products cp ON p.id = cp.product_id
                WHERE cp.category_id = :category_id
                AND (p.status = 'published' OR p.status = 'active')
                LIMIT 4
            ");
            $stmt->execute([':category_id' => $banner['category_id']]);
            $products = $stmt->fetchAll(PDO::FETCH_ASSOC);
            
            // Method 2: Fallback to direct product category field if no results
            if (empty($products)) {
                $stmt = $pdo->prepare("
                    SELECT p.id, p.title, p.price, p.compare_price,
                    (SELECT image_path FROM product_variant_images pvi 
                     JOIN product_variants pv ON pvi.variant_id = pv.id 
                     WHERE pv.product_id = p.id LIMIT 1) as image
                    FROM products p
                    WHERE p.category LIKE CONCAT('%\"', :category_id, '\"%')
                    AND (p.status = 'published' OR p.status = 'active')
                    LIMIT 4
                ");
                $stmt->execute([':category_id' => $banner['category_id']]);
                $products = $stmt->fetchAll(PDO::FETCH_ASSOC);
            }
            
            // Method 3: Final fallback to any products if still no results
            if (empty($products)) {
                $stmt = $pdo->query("
                    SELECT p.id, p.title, p.price, p.compare_price,
                    (SELECT image_path FROM product_variant_images pvi 
                     JOIN product_variants pv ON pvi.variant_id = pv.id 
                     WHERE pv.product_id = p.id LIMIT 1) as image
                    FROM products p
                    WHERE (p.status = 'published' OR p.status = 'active')
                    LIMIT 4
                ");
                $products = $stmt->fetchAll(PDO::FETCH_ASSOC);
            }

// Format products
            foreach ($products as $product) {
                $bannerData['products'][] = [
                    'id' => (int)$product['id'],
                    'title' => $product['title'],
                    'price' => number_format($product['price'], 2),
                    'originalPrice' => $product['compare_price'] ? number_format($product['compare_price'], 2) : null,
                    'image' => $product['image'] ?? 'default-product.jpg'
                ];
            }
        }

$response[] = $bannerData;
    }

echo json_encode([
        'status' => 'success',
        'data' => $response
    ]);

} catch (PDOException $e) {
    http_response_code(500);
    echo json_encode([
        'status' => 'error',
        'message' => 'Database error: ' . $e->getMessage()
    ]);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: top_banner.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation