Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html

Free Space:

9.31 TB

🔧 Quick Actions

✏️ Editing: verify_fix.php

<?php
include 'db.php';

function testCategory($conn, $category_id) {
    echo "Testing Category ID: $category_id\n";
    
    // Logic from accessories.php
    $category_ids = [$category_id];
    $sub_query = "SELECT id FROM categories WHERE parent_id = ?";
    $sub_stmt = $conn->prepare($sub_query);
    $sub_stmt->bind_param("i", $category_id);
    $sub_stmt->execute();
    $sub_res = $sub_stmt->get_result();
    while ($sub_row = $sub_res->fetch_assoc()) {
        $category_ids[] = (int)$sub_row['id'];
    }
    
    echo "Resolved Category IDs: " . implode(', ', $category_ids) . "\n";
    
    $cat_placeholders = implode(',', array_fill(0, count($category_ids), '?'));
    $query = "SELECT COUNT(*) as total FROM products WHERE category_id IN ($cat_placeholders)";
    $stmt = $conn->prepare($query);
    $stmt->bind_param(str_repeat('i', count($category_ids)), ...$category_ids);
    $stmt->execute();
    $res = $stmt->get_result();
    $total = $res->fetch_assoc()['total'];
    
    echo "Total Products Found: $total\n\n";
}

testCategory($conn, 4); // All Accessories
testCategory($conn, 5); // Charger (Subcategory)
testCategory($conn, 1); // Mobile Phone (Parent but no subcategories in my check_db output)
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: verify_fix.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation