prepare("SELECT * FROM category WHERE status = 0 ORDER BY name ASC");
$stmt->execute();
$categories = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Fetch stores
$stmt = $pdo->prepare("SELECT * FROM store WHERE status = 0 ORDER BY name ASC");
$stmt->execute();
$stores = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Optional icons/colors for categories
$cat_styles = [
'Grocery'=>['icon'=>'fa-shopping-cart','color'=>'#28a745'],
'Café'=>['icon'=>'fa-coffee','color'=>'#6f4e37'],
'Fast Food'=>['icon'=>'fa-hamburger','color'=>'#e83e8c'],
'Pizza Store'=>['icon'=>'fa-pizza-slice','color'=>'#dc3545'],
'Restaurant'=>['icon'=>'fa-utensils','color'=>'#ffc107'],
'Juice Bar'=>['icon'=>'fa-wine-glass','color'=>'#17a2b8'],
'Healthy'=>['icon'=>'fa-leaf','color'=>'#20c997'],
'Traditional food'=>['icon'=>'fa-bowl-food','color'=>'#fd7e14'],
'Auto spare parts'=>['icon'=>'fa-car','color'=>'#6c757d'],
'PHARMACY'=>['icon'=>'fa-pills','color'=>'#6610f2'],
'Supper Market'=>['icon'=>'fa-store','color'=>'#007bff'],
'Butcher'=>['icon'=>'fa-drumstick-bite','color'=>'#dc3545'],
'Liquor Store'=>['icon'=>'fa-glass-whiskey','color'=>'#6f42c1'],
'CARS'=>['icon'=>'fa-car-side','color'=>'#343a40'],
'Others'=>['icon'=>'fa-ellipsis-h','color'=>'#6c757d']
];
?>
Store Carousel
![<?php echo htmlspecialchars($store['name']); ?>](https://admin.lincmate.com/upload/store/<?php echo htmlspecialchars($store_img); ?>)