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.28 TB

🔧 Quick Actions

✏️ Editing: top_selection.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);

// Step 1: Get all product IDs from top_selection table
    $topSelectionStmt = $pdo->query("SELECT product_id FROM top_selection ORDER BY created_at DESC");
    $topProductIds = $topSelectionStmt->fetchAll(PDO::FETCH_COLUMN);

if (empty($topProductIds)) {
        echo json_encode([
            'status' => 'success',
            'data' => [],
            'message' => 'No products in top selections'
        ]);
        exit;
    }

// Step 2: Fetch complete product details for these IDs
    $placeholders = implode(',', array_fill(0, count($topProductIds), '?'));
    $productsStmt = $pdo->prepare("
        SELECT 
            p.*,
            (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 primary_image
        FROM products p
        WHERE p.id IN ($placeholders)
        AND (p.status = 'published' OR p.status = 'active')
    ");
    $productsStmt->execute($topProductIds);
    $products = $productsStmt->fetchAll(PDO::FETCH_ASSOC);

// Format the response
    $formattedProducts = array_map(function($product) {
        return [
            'id' => (int)$product['id'],
            'title' => $product['title'],
            'description' => $product['description'],
            'price' => number_format($product['price'], 2),
            'compare_price' => $product['compare_price'] ? number_format($product['compare_price'], 2) : null,
            'image' => $product['primary_image'] ?? json_decode($product['product_images'])[0] ?? null,
            'stock' => (int)$product['stock'],
            'created_at' => $product['created_at']
        ];
    }, $products);

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

} 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_selection.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation