PHPize Online / SQLize Online  /  SQLtest Online

<?php function get_categories($pdo) { $stmt = $pdo->prepare("SELECT * FROM `categories`"); $stmt->execute(); return $stmt->fetchAll(PDO::FETCH_ASSOC); } function get_prices_by_category($pdo, $category_id) { $stmt = $pdo->prepare("SELECT * FROM `prices` WHERE category_id = ?"); $stmt->execute([$category_id]); return $stmt->fetchAll(PDO::FETCH_ASSOC); } $categories = get_categories($pdo); foreach ($categories as $category) { echo '<h3>'.$category['title'].'</h3> <div class="cblock">'; $prices = get_prices_by_category($pdo, $category['id']); foreach ($prices as $price) { echo '<div class="pricelist-row"> <div class="service">' . $price["title"] . '</div> <div class="price">от ' . $price["price"] . ' руб/' . $price["type"] . '</div> </div>'; } echo '</div>'; }