Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u184721437

Directory:

/home/u184721437/public_html/public_html/b2bmarket/api

Free Space:

7.11 TB

🔧 Quick Actions

✏️ Editing: api_menu.php

<?php
include("../function.php");
header("Content-Type: application/json");

$data = [];

$catQuery = mysqli_query($conn,
    "SELECT id, title, image1 
     FROM menu_category_tbl 
     WHERE status=1"
);
while ($cat = mysqli_fetch_assoc($catQuery)) {
    $subcategories = [];
    $categoryProductCount = 0;
    $subQuery = mysqli_query($conn,
        "SELECT id, title, image1 
         FROM menu_subcategory_tbl 
         WHERE status=1 AND cat_id='{$cat['id']}'"
    );

while ($sub = mysqli_fetch_assoc($subQuery)) {

$items = [];
        $subProductCount = 0;

$itemQuery = mysqli_query($conn,
            "SELECT id, title, title_ar, image1, content 
             FROM items_tbl 
             WHERE status=1 
             AND cat_id='{$cat['id']}'
             AND subcat_id='{$sub['id']}'"
        );

while ($item = mysqli_fetch_assoc($itemQuery)) {
            $items[] = [
                "item_id"  => $item['id'],
                "title"    => $item['title'],
                "title_ar" => $item['title_ar'],
                "image"    => $base_url . "images/Upload/menu/" . $item['image1'],
                "content"  => strip_tags($item['content'])
            ];

$subProductCount++;
            $categoryProductCount++;
        }
        if ($subProductCount > 0) {
            $subcategories[] = [
                "subcat_id"        => $sub['id'],
                "subcat_title"     => $sub['title'],
                "subcat_image"     => $base_url . "images/Upload/menu/" . $sub['image'],
                "total_products"   => $subProductCount,
                "items"            => $items
            ];
        }
    }

if ($categoryProductCount > 0) {
        $data[] = [
            "category_id"      => $cat['id'],
            "category_title"   => $cat['title'],
            "category_image"   => $base_url . "images/Upload/menu/" . $cat['image'],
            "total_products"   => $categoryProductCount,
            "subcategories"    => $subcategories
        ];
    }
}

echo json_encode([
    "status" => true,
    "data"   => $data
], JSON_PRETTY_PRINT);

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: api_menu.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation