<section class="shop-page-section">
    <div class="auto-container">
        <div class="row clearfix">
            <div class="col-lg-4 col-md-12 col-sm-12 sidebar-side">
                <div class="shop-sidebar default-sidebar">

                    <div class="sidebar-widget sidebar-category">
                        <div class="widget-title">
                            <h3><?= $lan['mehsul-kateqoriya'] ?></h3>
                        </div>
                        <?php
                        $sidebar_cek = $db->query("SELECT * FROM mehsullar WHERE veziyyeti='0' AND lan='{$dilsec["id"]}' ORDER BY sira ASC LIMIT 8")->fetchAll(PDO::FETCH_ASSOC);
                        if ($sidebar_cek) { // Eğer sidebar'da gösterilecek haber varsa
                        ?>
                            <div class="widget-content">
                                <?php foreach ($sidebar_cek as $sidebar_goster) { ?>
                                    <ul class="category-list clearfix">
                                        <li><a href="<?= $sidebar_goster["seo"] ?>"><i class="far fa-long-arrow-right"></i><?= $sidebar_goster["adi"] ?></a></li>

                                    </ul>
                                <?php } ?>
                            </div>
                        <?php } ?>
                    </div>


                </div>
            </div>
            <div class="col-lg-8 col-md-12 col-sm-12 content-side">
                <div class="our-shop">

                    <div class="row clearfix">
                        <?php
                        $cek = $db->query("select * from mehsullar where veziyyeti='0' and lan='{$dilsec["id"]}' order by sira asc")->fetchAll(PDO::FETCH_ASSOC);
                        foreach ($cek as $goster) {
                        ?>
                            <div class="col-lg-6 col-md-6 col-sm-12 shop-block">
                                <div class="shop-block-one wow fadeInUp animated" data-wow-delay="00ms" data-wow-duration="1500m">
                                    <div class="inner-box">
                                        <figure class="image-box"><img src="imgupload/<?= $goster["resim"] ?>" alt=""></figure>
                                        <div class="lower-content">
                                            <div class="shape" style="background-image: url(assets/images/shape/shape-7.png);"></div>

                                            <h4><a href="<?= $goster["seo"] ?>"><?= $goster["adi"] ?></a></h4>
                                            <h6><?= $goster["fiyat"] ?><?php if ($goster["kur"] == 0) {
                                                                            echo '₼';
                                                                        } else if ($goster["kur"] == 1) {
                                                                            echo '$';
                                                                        } else {
                                                                            echo "€";
                                                                        } ?></h6>
                                            <p><?= $goster["onaciklama"] ?></p>
                                            <div class="btn-box">
                                                <a href="<?= $goster["seo"] ?>" class="theme-btn btn-two"><?= $lan['mehsullar-etrafli'] ?></a>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        <?php } ?>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>