
<section class="projects projects__space">
        <div class="container">
            <div class="projects__shape">
                <img src="./assets/imgs/projects/shape.png" alt="image not found">
            </div>
            <div class="row">
                <div class="col-xl-3">

                    <div class="projects__nav-tabs">
                        <nav class="nav" id="nav-tab-3" role="tablist">
                            <button class="nav-link active" id="all-projects-tab" data-bs-toggle="tab" data-bs-target="#all-projects" type="button" role="tab" aria-controls="all-projects" aria-selected="true">All Projects</button>
        
                            <button class="nav-link" id="architecture-1-tab" data-bs-toggle="tab" data-bs-target="#architecture-1" type="button" role="tab" aria-controls="architecture-1" aria-selected="false">Architecture</button>
        
                            
        
                        </nav>
                    </div>

                   
                </div>

                <div class="col-xl-9">

                    <div class="tab-content" id="nav-tabContent-5">
                        <div class="tab-pane fade show active" id="all-projects" role="tabpanel">
                            <div class="projects__wrapper">
                                <div class="projects__item">
                                    <div class="has--overlay"></div>
                                    <div class="has--overlay-2"></div>
                                    <div class="projects__media">
                                        <img src="./assets/imgs/projects/projects-1.jpg" alt="imgs not found">
                                    </div>
            
                                    <div class="projects__text-top">
                                        <h2>01</h2>
                                        <span>Architecture – Luxury Living</span>
                                        <h6><a href="blog-details.html">Modern Family House</a></h6>
                                    </div>
                                    <div class="projects__text-bottom">
                                        <h2>01</h2>
                                        <span>Architecture – Luxury Living</span>
                                        <h6><a href="blog-details.html">Modern Family House</a></h6>
                                    </div>
            
                                    <a class="projects__arrow" href="protfolio-details.html">
                                        <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                                            <path d="M1 8.00018H15" stroke="#906E50" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"/>
                                            <path d="M8 1.00018L15 8.00018L8 15.0002" stroke="#906E50" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"/>
                                        </svg>                                        
                                    </a>
                                </div>
                                
        
                            </div>
                        </div>
                        <div class="tab-pane fade" id="architecture-1" role="tabpanel" aria-labelledby="architecture-1-tab">
                            <div class="projects__wrapper">
                                <div class="projects__item">
                                    <div class="has--overlay"></div>
                                    <div class="has--overlay-2"></div>
                                    <div class="projects__media">
                                        <img src="./assets/imgs/projects/projects-1.jpg" alt="imgs not found">
                                    </div>
            
                                    <div class="projects__text-top">
                                        <h2>01</h2>
                                        <span>Architecture – Luxury Living</span>
                                        <h6><a href="blog-details.html">Modern Family House</a></h6>
                                    </div>
                                    <div class="projects__text-bottom">
                                        <h2>01</h2>
                                        <span>Architecture – Luxury Living</span>
                                        <h6><a href="blog-details.html">Modern Family House</a></h6>
                                    </div>
            
                                    <a class="projects__arrow" href="protfolio-details.html">
                                        <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                                            <path d="M1 8.00018H15" stroke="#906E50" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"/>
                                            <path d="M8 1.00018L15 8.00018L8 15.0002" stroke="#906E50" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"/>
                                        </svg>                                        
                                    </a>
                                </div>
                                
        
                            </div>
                        </div>
                        
                    </div>
                   
                </div>
            </div>
        </div>
    </section>
















bu ise duzeldilmis kodudur

<section class="projects projects__space">
    <div class="container">
        <div class="projects__shape">
            <img src="./assets/imgs/projects/shape.png" alt="image not found">
        </div>
        <div class="row">
            <div class="col-xl-3">
                <div class="projects__nav-tabs">
                    <nav class="nav" id="nav-tab-3" role="tablist">
                        <button class="nav-link active" id="all-projects-tab" data-bs-toggle="tab" data-bs-target="#all-projects" type="button" role="tab" aria-controls="all-projects" aria-selected="true"><?= $lan['layiheler-hamisina-bax'] ?></button>
                        <?php
                        $kateqoriyanicek = $db->query("SELECT * FROM layihe_kateqoriya WHERE veziyyeti='0' AND lan='{$dilsec["id"]}' ORDER BY sira ASC")->fetchAll(PDO::FETCH_ASSOC);
                        foreach ($kateqoriyanicek as $goster) {
                        ?>
                            <button class="nav-link" id="<?= $goster["seo"] ?>-tab" data-bs-toggle="tab" data-bs-target="#<?= $goster["seo"] ?>" type="button" role="tab" aria-controls="<?= $goster["seo"] ?>" aria-selected="false"><?= $goster["adi"] ?></button>
                        <?php
                        }
                        ?>
                    </nav>
                </div>
            </div>

            <div class="col-xl-9">
                <div class="tab-content" id="nav-tabContent-5">
                    <div class="tab-pane fade show active" id="all-projects" role="tabpanel">
                        <div class="projects__wrapper">
                            <?php
                            $butunkateqoriyanicek = $db->query("SELECT * FROM layiheler WHERE veziyyeti='0' AND lan='{$dilsec["id"]}' ORDER BY sira ASC")->fetchAll(PDO::FETCH_ASSOC);
                            $nomresinigoster = 0; // Proje numarası için sayaç
                            foreach ($butunkateqoriyanicek as $goster) {
                                $nomresinigoster++;
                                $category_info = $db->query("SELECT * FROM layihe_kateqoriya WHERE id='{$goster["kategori"]}'")->fetch(PDO::FETCH_ASSOC);
                                $kateqoriyaadi = $category_info ? $category_info["adi"] : "Unknown Category";
                            ?>
                                <div class="projects__item">
                                    <div class="has--overlay"></div>
                                    <div class="has--overlay-2"></div>
                                    <div class="projects__media">
                                        <img src="imgupload/<?= $goster["resim"] ?>" alt="<?= $goster["adi"] ?>">
                                    </div>
                                    <div class="projects__text-top">
                                        <h2><?= sprintf("%02d", $nomresinigoster) ?></h2>
                                        <span><?= $kateqoriyaadi ?></span>
                                        <h6><a href="<?= $goster["seo"] ?>"><?= $goster["adi"] ?></a></h6>
                                    </div>
                                    <div class="projects__text-bottom">
                                        <h2><?= sprintf("%02d", $nomresinigoster) ?></h2>
                                        <span><?= $kateqoriyaadi ?></span>
                                        <h6><a href="<?= $goster["seo"] ?>"><?= $goster["adi"] ?></a></h6>
                                    </div>
                                    <a class="projects__arrow" href="<?= $goster["seo"] ?>">
                                        <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                                            <path d="M1 8.00018H15" stroke="#906E50" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"/>
                                            <path d="M8 1.00018L15 8.00018L8 15.0002" stroke="#906E50" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"/>
                                        </svg>
                                    </a>
                                </div>
                            <?php
                            }
                            ?>
                        </div>
                    </div>

                    <?php
                    foreach ($kateqoriyanicek as $goster) {
                    ?>
                        <div class="tab-pane fade" id="<?= $goster["seo"] ?>" role="tabpanel" aria-labelledby="<?= $goster["seo"] ?>-tab">
                            <div class="projects__wrapper">
                                <?php
                                $category_projects = $db->query("SELECT * FROM layiheler WHERE kategori='{$goster["id"]}' AND veziyyeti='0' AND lan='{$dilsec["id"]}' ORDER BY sira ASC")->fetchAll(PDO::FETCH_ASSOC);
                                $nomresinigoster = 0; // Her kategori için sıfırla
                                foreach ($category_projects as $goster) {
                                    $nomresinigoster++;
                                ?>
                                    <div class="projects__item">
                                        <div class="has--overlay"></div>
                                        <div class="has--overlay-2"></div>
                                        <div class="projects__media">
                                            <img src="imgupload/<?= $goster["resim"] ?>" alt="<?= $goster["adi"] ?>">
                                        </div>
                                        <div class="projects__text-top">
                                            <h2><?= sprintf("%02d", $nomresinigoster) ?></h2>
                                            <span><?= $goster["adi"] ?></span>
                                            <h6><a href="<?= $goster["seo"] ?>"><?= $goster["adi"] ?></a></h6>
                                        </div>
                                        <div class="projects__text-bottom">
                                            <h2><?= sprintf("%02d", $nomresinigoster) ?></h2>
                                            <span><?= $goster["adi"] ?></span>
                                            <h6><a href="<?= $goster["seo"] ?>"><?= $goster["adi"] ?></a></h6>
                                        </div>
                                        <a class="projects__arrow" href="<?= $goster["seo"] ?>">
                                            <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                                                <path d="M1 8.00018H15" stroke="#906E50" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"/>
                                                <path d="M8 1.00018L15 8.00018L8 15.0002" stroke="#906E50" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"/>
                                            </svg>
                                        </a>
                                    </div>
                                <?php
                                }
                                ?>
                            </div>
                        </div>
                    <?php
                    }
                    ?>
                </div>
            </div>
        </div>
    </div>
</section>