---------------------------------Xeberler---------------

<?php
$cek = $db->query("select * from xeberler where veziyyeti='0' and lan='{$dilsec["id"]}' order by sira asc")->fetchAll(PDO::FETCH_ASSOC);
foreach ($cek as $goster) {
?>
    imgupload/<?= $goster["resim"] ?>
    <?= $sidebar_goster["eklenme_tarihi"] ?>
    <?= $goster["eklenme_tarihi"] ?>
    <?= $goster["seo"] ?>
    <?= $goster["adi"] ?>
    <?= $goster["onaciklama"] ?>

<?php } ?>

sol ve ya sag side bar kodu

<div class="sidebar-widget sidebar-category">
    <div class="widget-title">
        <h3><?= $lan['mehsul-kateqoriya'] ?></h3>
    </div>
    <?php
    $sidebar_cek = $db->query("SELECT * FROM xeberler 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 class="col-lg-4">
                    <aside class="sidebar-area">
                        <?php
    $sidebar_cek = $db->query("SELECT * FROM xeberler 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 widget_categories  ">
                            <h3 class="widget_title"><?= $lan['diger-blog'] ?> </h3>
                            <ul>
                                <?php foreach ($sidebar_cek as $sidebar_goster) { ?>
                                <li>
                                    <a href="<?= $sidebar_goster["seo"] ?>"><?= $sidebar_goster["adi"] ?></a>

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


---------------------------------xidmetler---------------

<?php
$cek = $db->query("select * from xidmetler where veziyyeti='0' and lan='{$dilsec["id"]}' order by sira asc")->fetchAll(PDO::FETCH_ASSOC);
foreach ($cek as $goster) {
?>

    imgupload/<?= $goster["resim"] ?>
    imgupload/<?= $goster["icon"] ?>
    <?= $sidebar_goster["eklenme_tarihi"] ?>
    <?= $goster["seo"] ?>
    <?= $goster["adi"] ?>
    <?= $goster["onaciklama"] ?>

<?php } ?>

sol ve ya sag side bar kodu

<div class="sidebar-widget sidebar-category">
    <div class="widget-title">
        <h3><?= $lan['mehsul-kateqoriya'] ?></h3>
    </div>
    <?php
    $sidebar_cek = $db->query("SELECT * FROM xidmetler 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>


---------------------------------Sertifikatlar---------------

<?php
$cek = $db->query("select * from sertifikatlar where veziyyeti='0' and lan='{$dilsec["id"]}' order by sira asc")->fetchAll(PDO::FETCH_ASSOC);
foreach ($cek as $goster) {
?>

    imgupload/<?= $goster["resim"] ?>
    imgupload/<?= $goster["icon"] ?>
    <?= $sidebar_goster["eklenme_tarihi"] ?>
    <?= $goster["seo"] ?>
    <?= $goster["adi"] ?>
    <?= $goster["onaciklama"] ?>

<?php } ?>


---------------------------------layiheler---------------

<?php
$cek = $db->query("select * from layiheler where veziyyeti='0' and lan='{$dilsec["id"]}' order by sira asc")->fetchAll(PDO::FETCH_ASSOC);
foreach ($cek as $goster) {
?>

    imgupload/<?= $goster["resim"] ?>
    imgupload/<?= $goster["icon"] ?>
    <?= $sidebar_goster["eklenme_tarihi"] ?>
    <?= $goster["seo"] ?>
    <?= $goster["adi"] ?>
    <?= $goster["onaciklama"] ?>

<?php } ?>

sol ve ya sag side bar kodu

<div class="sidebar-widget sidebar-category">
    <div class="widget-title">
        <h3><?= $lan['mehsul-kateqoriya'] ?></h3>
    </div>
    <?php
    $sidebar_cek = $db->query("SELECT * FROM layiheler 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>

bu kod ise leyiheler kateqoriyasini getirir layiheler kodundan evvel ve ya sonra

                        <div class="gallery-filters case-menu">
                            <ul>
                                <li><a data-filter="*" href="#" class="current">All Project</a></li>
                                <?php
                            $cek=$db->query("select * from layihe_kateqoriya where veziyyeti='0' and lan='{$dilsec["id"]}' order by sira asc")->fetchAll(PDO::FETCH_ASSOC);
                            foreach($cek as $goster){
                            ?>
                                <li><a data-filter=".<?=$goster["seo"]?>" href="#"><?=$goster["adi"]?></a></li>
                                <!-- <li><a data-filter=".criminal" href="#">Criminal</a></li>
                                <li><a data-filter=".family" href="#">Family Matter</a></li>
                                <li><a data-filter=".real" href="#">Real Estate</a></li> -->
                                <?php }?>
                            </ul>
                        </div>
                        <div class="case-grids gallery-container clearfix">
                            <?php
                            $cek=$db->query("select * from layiheler where veziyyeti='0' and lan='{$dilsec["id"]}' order by sira asc")->fetchAll(PDO::FETCH_ASSOC);
                            foreach($cek as $goster){
                                $kat=$db->query("select * from layihe_kateqoriya where id='{$goster["kategori"]}'")->fetch(PDO::FETCH_ASSOC);
                            ?>
                            <div class="grid real <?=$kat["seo"]?>">
                                <div class="img-holder">
                                    <img src="imgupload/<?=$goster["resim"]?>" alt="<?=$goster["adi"]?>">
                                    <div class="hover-content">
                                        <a class="theme-btn-s2" href="<?=$goster["seo"]?>"><?=$goster["adi"]?></a>
                                    </div>
                                </div>
                                
                            </div>
                            <?php }?>
                        </div>



------------------------------------sual cavab------------------

<div class="accordion" id="accordionExample">
    <?php
    $cek = $db->query("SELECT * FROM cvs WHERE veziyyeti='0' AND lan='{$dilsec["id"]}' ORDER BY sira ASC")->fetchAll(PDO::FETCH_ASSOC);
    foreach ($cek as $index => $goster) {
        $collapseId = "collapse" . $index;
        $headingId = "heading" . $index;
    ?>
        <div class="accordion-item">
            <h3 class="accordion-header" id="<?= $headingId ?>">
                <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse"
                    data-bs-target="#<?= $collapseId ?>" aria-expanded="false"
                    aria-controls="<?= $collapseId ?>">
                    <?= $goster["adi"] ?>
                </button>
            </h3>
            <div id="<?= $collapseId ?>" class="accordion-collapse collapse"
                aria-labelledby="<?= $headingId ?>" data-bs-parent="#accordionExample">
                <div class="accordion-body">
                    <p><?= $goster["aciklama"] ?></p>
                </div>
            </div>
        </div>
    <?php } ?>
</div>


--------------------------------------mehsullar-------------------

<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>



Sidebardaki kateoqriyalari cekme

<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>



---------------------detals sehifesi baglama-----------

imgupload/<?= $sehifeler["resim"] ?>
<?= $sehifeler["adi"] ?>
<?= nl2br($sehifeler["aciklama"]) ?>
<?= $lan['haqqimizda-dahacox'] ?>