<?php
  $dsn = 'mysql:host=localhost;dbname=basvulk_basvulk';
    $username = 'root';
    $password = '';

    try {
        $db = new PDO($dsn, $username, $password);

    } catch (PDOException $e) {
        $error_message = $e->getMessage();
        echo 'error';
        include('../errors/database_error.php');
        exit();
    }

    function list_all_products($query_to_execute) {
        mysql_set_charset('UTF8');
        global $db;
        $db->exec('set names utf8');
        $query = $query_to_execute;
        $statement = $db->prepare($query);
        $statement->execute();
        $products = $statement->fetchAll();
        $statement->closeCursor();
        return $products;
    }
    global $prods;

    $prods = list_all_products('SELECT * FROM categories WHERE type="vipal"');
    require_once 'src/siteEN/site_head.php';
    render_head('Лепенки за винтили');
?>

<?php foreach ($prods as $prod) : ?>
  <div>
    <h3><?php echo $prod['cat_name_bg'] ?></h3>
    <ul>
      <?php
      $sub = list_all_products('SELECT * FROM products WHERE product_cat='.$prod['cat_id']);
       foreach ($sub as $sub_cat) {
        echo '<li>'.$sub_cat['product_name_bg'].'</li>';
       }
    ?>
    </ul>

  </div>
<?php endforeach; ?>