<?php include 'header.php'; 

 $query_brands = $pdo->prepare("SELECT * FROM `category` ORDER BY `row_order` ASC");
	$query_brands->execute();
	$result_brands = $query_brands->fetchAll(PDO::FETCH_ASSOC);

 $total_brands=$query_brands->rowCount();
 
?>

        <!--<section class="inner-section single-banner" style="background: url(images/single-banner.jpg) no-repeat center;">-->
        <!--    <div class="container">-->
        <!--        <h2>brand list</h2>-->
                
        <!--    </div>-->
        <!--</section>-->
        
        
        
        <section class="about-choose" style="margin-top: 23px;"> 
            <div class="container">
                <div class="row">
                       <div class="col-11 col-md-9 col-lg-7 col-xl-6 mx-auto">
                          <div class="section-heading">
                             <h2>Brand Partners</h2>
                          </div>
                       </div>
                    </div>
                <div class="row row-cols-2 row-cols-md-3 row-cols-lg-4 row-cols-xl-5 isotope-items">
                    <?php if($total_brands > 0) { foreach($result_brands as $brands_datas) { ?>
                    
                    <div class="col all vegetables">
                        <div class="brand-wrap">
                            <div class="brand-media"><img src="admin/<?= $brands_datas['image'] ?>" alt="brand">
                                <div class="brand-overlay"></div>
                            </div>
                            <div class="brand-meta">
                                <h4><?= $brands_datas['name'] ?></h4>
                                <p><?= $brands_datas['subtitle'] ?></p>
                            </div>
                        </div>
                    </div>
                    
                    <?php } }else{ 
                    echo '<h4> No Brands </h4>';
                    } ?>
                   
                </div>
            </div>
        </section>


<?php  include 'footer.php'; ?>