prepare("SELECT COUNT(*) FROM `service`"); $totalStmt->execute(); $totalProducts = $totalStmt->fetchColumn(); $totalPages = ceil($totalProducts / $limit); // Get products for the current page ?>

Our Products

Product Categories
    prepare("SELECT * FROM `category` WHERE `id` != 1 ORDER BY `id` DESC"); $categoryStmt->execute(); $categories = $categoryStmt->fetchAll(); foreach ($categories as $category) { ?>
prepare("SELECT * FROM `service` LIMIT :limit OFFSET :offset"); $proStmt->bindValue(':limit', $limit, PDO::PARAM_INT); $proStmt->bindValue(':offset', $offset, PDO::PARAM_INT); $proStmt->execute(); $products = $proStmt->fetchAll(); foreach ($products as $product): ?>
<?= $product['name'] ?>

Explore More