<div class="project-slider owl-carousel owl-theme">
    <?php
    $psor = $db->prepare("SELECT * FROM projeler p
                         LEFT JOIN projeresim pr ON p.id = pr.rid
                         WHERE p.anasayfa=? AND p.dil=?
                         ORDER BY p.id ASC");
    $psor->execute(array("1", $_SESSION['dil']));
    $pisl = $psor->fetchAll(PDO::FETCH_ASSOC);

    foreach ($pisl as $pson){
        ?>
        <div class="single-project">
            <?php
            $resimURL = "/".tema."/uploads/projeler/diger/".$pson['resim'];
            if (!empty($resimURL)){
                ?>
                <a title="" class="popup-btn" href="<?=$resimURL;?>"><img src="<?=$resimURL;?>" alt="" class="project-img"></a>
                <?php
            }
            ?>
            <div class="fancybox"><i class="bx bx-expand" aria-hidden="true"></i></div>
        </div>
        <?php
    }
    ?>
</div>