'id ASC',
'price_asc' => 'price ASC',
'price_desc' => 'price DESC',
'rating_desc' => 'rating DESC',
];
$sort_key = $_GET['sort'] ?? 'default';
if (!array_key_exists($sort_key, $sort_options)) {
$sort_key = 'default';
}
$order_by_clause = $sort_options[$sort_key];
// koniec logiky triedenia
// logika vyhľadávania produktov
$search_term = trim($_GET['search'] ?? '');
$where_clauses = [];
$params = []; // parametre pre prepared statement
if (!empty($search_term)) {
$where_clauses[] = "name LIKE ?";
$params[] = "%{$search_term}%"; // pridá % pre LIKE vyhľadávanie
}
// koniec logiky vyhľadávania
// načítanie produktov z databázy (iba s dostupným skladom)
$products = [];
try {
$sql = "SELECT p.id, p.name, p.price, p.product_gallery, p.rating FROM products p WHERE (SELECT COALESCE(SUM(ps.quantity), 0) FROM product_stock ps WHERE ps.product_id = p.id) > 0";
// pridá WHERE pre vyhľadávanie
if (!empty($where_clauses)) {
$sql .= " AND " . implode(' AND ', array_map(function($c) { return str_replace('name ', 'p.name ', $c); }, $where_clauses));
}
$sql .= " ORDER BY " . str_replace(['id', 'name', 'price', 'rating'], ['p.id', 'p.name', 'p.price', 'p.rating'], $order_by_clause);
$stmt = $pdo->prepare($sql); // pripraví statement
$stmt->execute($params); // vykoná s parametrami
$products = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
// chyba pri načítaní produktov
error_log("Database error fetching products: " . $e->getMessage());
$_SESSION['error_message'] = "Error loading products. Please try again later.";
}
// zobrazenie správ o úspechu/chybe
if (isset($_SESSION['success_message'])) {
echo '' . htmlspecialchars($_SESSION['success_message']) . '
';
unset($_SESSION['success_message']);
}
if (isset($_SESSION['error_message'])) {
echo '' . htmlspecialchars($_SESSION['error_message']) . '
';
unset($_SESSION['error_message']);
}
?>
All Products - ShoeBox
' . htmlspecialchars($_SESSION['success_message']) . '';
unset($_SESSION['success_message']);
}
if (isset($_SESSION['error_message'])) {
echo '
' . htmlspecialchars($_SESSION['error_message']) . '
';
unset($_SESSION['error_message']);
}
?>
All Products
No products found.
![<?= htmlspecialchars($product['name']) ?>](<?= image_url_src(product_main_image($product['product_gallery'] ?? null)) ?>)
€
1
2
3
4
→
