| Server IP : 3.111.61.48 / Your IP : 216.73.216.67 Web Server : Apache System : Linux ip-10-0-5-176 6.8.0-1057-aws #60~22.04.1-Ubuntu SMP Wed May 27 08:16:59 UTC 2026 x86_64 User : ubuntu ( 1000) PHP Version : 8.2.31 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/vhost/itms.arukustech.com/public/api/ |
Upload File : |
<?php
require_once __DIR__ . '/../../app/db.php';
$pdo = db();
$category = $_GET['category'] ?? "";
$brand = $_GET['brand'] ?? "";
$response = ["brands" => [], "models" => []];
if ($category) {
// Get brands
$stmt = $pdo->prepare("
SELECT DISTINCT brand FROM inventory_items
WHERE category_id=? AND status='available'
ORDER BY brand ASC
");
$stmt->execute([$category]);
$response["brands"] = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
if ($category && $brand) {
// Get models
$stmt = $pdo->prepare("
SELECT DISTINCT model FROM inventory_items
WHERE category_id=? AND brand=? AND status='available'
ORDER BY model ASC
");
$stmt->execute([$category, $brand]);
$response["models"] = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
echo json_encode($response);