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: deals_sections.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 deal sections
    $dealSections = $pdo->query("
        SELECT id, title, subtitle, brand_header as brandHeader, 
               end_datetime as endDateTime, bg_gradient as bgGradient
        FROM deal_sections
        ORDER BY created_at DESC
    ")->fetchAll(PDO::FETCH_ASSOC);

$response = ['dealSections' => []];

foreach ($dealSections as $section) {
        // Get brands for this section
        $brandsStmt = $pdo->prepare("
            SELECT brand_name FROM deal_section_brands 
            WHERE deal_section_id = ?
            ORDER BY id
        ");
        $brandsStmt->execute([$section['id']]);
        $brands = $brandsStmt->fetchAll(PDO::FETCH_COLUMN);

// Get timer for this section
        $timerStmt = $pdo->prepare("
            SELECT hours, minutes, seconds FROM deal_timers 
            WHERE deal_section_id = ?
        ");
        $timerStmt->execute([$section['id']]);
        $timer = $timerStmt->fetch(PDO::FETCH_ASSOC);

// Get categories for this section
        $categoriesStmt = $pdo->prepare("
            SELECT 
                name, image_path as image, discount_text as discount,
                link_url as link, is_today as isToday, stock_status as stockStatus,
                stock_label as stockLabel, fast_delivery as fastDelivery,
                express_delivery as expressDelivery
            FROM deal_section_categories
            WHERE deal_section_id = ?
            ORDER BY id
        ");
        $categoriesStmt->execute([$section['id']]);
        $categories = $categoriesStmt->fetchAll(PDO::FETCH_ASSOC);

// Format the section data
        $formattedSection = [
            'id' => $section['id'],
            'title' => $section['title'],
            'subtitle' => $section['subtitle'],
            'brandHeader' => $section['brandHeader'],
            'brands' => $brands,
            'endDateTime' => $section['endDateTime'],
            'bgGradient' => $section['bgGradient'],
            'timer' => $timer ?: ['hours' => '00', 'minutes' => '00', 'seconds' => '00'],
            'categories' => array_map(function($category) {
                return [
                    'name' => $category['name'],
                    'image' => $category['image'],
                    'discount' => $category['discount'],
                    'link' => $category['link'],
                    'isToday' => (bool)$category['isToday'],
                    'stockStatus' => $category['stockStatus'],
                    'stockLabel' => $category['stockLabel'],
                    'fastDelivery' => (bool)$category['fastDelivery'],
                    'expressDelivery' => (bool)$category['expressDelivery']
                ];
            }, $categories)
        ];

$response['dealSections'][] = $formattedSection;
    }

echo json_encode($response, JSON_PRETTY_PRINT);

} 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: deals_sections.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation