✏ EDIT: items_list.php<?php
// Returns a filtered list of items. A search query may be supplied
// via the q parameter. Only active items are returned.

require_once __DIR__ . '/bootstrap.php';

$q = isset($_GET['q']) ? trim($_GET['q']) : '';

try {
    if ($q !== '') {
        $stmt = $pdo->prepare('SELECT id, name, description, price_per_unit, available_qty FROM items WHERE is_active = 1 AND name LIKE ? ORDER BY created_at DESC');
        $stmt->execute(['%' . $q . '%']);
    } else {
        $stmt = $pdo->prepare('SELECT id, name, description, price_per_unit, available_qty FROM items WHERE is_active = 1 ORDER BY created_at DESC');
        $stmt->execute();
    }
    $items = $stmt->fetchAll();
    respond($items);
} catch (PDOException $e) {
    respond(null, 'Database error');
}

 [✗] CANCEL

[~] Kerym Chaeceran