setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec('CREATE TABLE p(sku TEXT, name TEXT, category TEXT, price REAL, stock INT)');
$f = fopen(__DIR__ . '/catalogue.csv', 'r'); fgetcsv($f, null, ',', '"', ''); $ins = $db->prepare('INSERT INTO p VALUES (?,?,?,?,?)');
while ($r = fgetcsv($f, null, ',', '"', '')) $ins->execute($r);
$q = trim((string)($_GET['q'] ?? '')); $cat = (string)($_GET['cat'] ?? ''); $page = max(1, (int)($_GET['page'] ?? 1));
$where = []; $args = [];
if ($q !== '') { $where[] = "name LIKE ? ESCAPE '\\'"; $args[] = '%' . addcslashes($q, '%_\\') . '%'; }
if ($cat !== '') { $where[] = 'category = ?'; $args[] = $cat; }
$sqlWhere = $where ? 'WHERE ' . implode(' AND ', $where) : '';
$c = $db->prepare("SELECT COUNT(*) FROM p $sqlWhere"); $c->execute($args); $total = (int)$c->fetchColumn();
$pages = max(1, (int)ceil($total / PER_PAGE)); $page = min($page, $pages);
$s = $db->prepare("SELECT * FROM p $sqlWhere ORDER BY name LIMIT " . PER_PAGE . ' OFFSET ' . (($page - 1) * PER_PAGE)); $s->execute($args);
$rows = $s->fetchAll(PDO::FETCH_ASSOC); $cats = $db->query('SELECT DISTINCT category FROM p ORDER BY 1')->fetchAll(PDO::FETCH_COLUMN);
function h(string $s): string { return htmlspecialchars($s, ENT_QUOTES); }
function link_to(int $p): string { return '?' . http_build_query(array_filter(['q' => $_GET['q'] ?? '', 'cat' => $_GET['cat'] ?? '', 'page' => $p])); }
?>
Catalogue search · Sample Store
Sample Store catalogue
result · page of
No products match. Try a shorter search.
| SKU | Product | Category | Price | Stock |
|---|
| | | $ | |