PHP Dosya Yöneticisi

<?php include "includes/header.php";
$kategori_id = $_GET['ser_id'];

$kategoriler = $db->prepare("select * from proje_kat where id=:id and durum=:durum and dil=:dil");
$kategoriler->execute(array(
    'id' => $kategori_id,
    'durum' => '1',
    'dil' => $_SESSION['dil']
));
$kategori = $kategoriler->fetch(PDO::FETCH_ASSOC);

?>
<?php
if($kategoriler->rowCount() == 0)
{
    header('Location:'.$siteurl.'');

exit;

}
?>

<div class="section-space--sm bg-primary-5p">
        <div class="section-space--sm-bottom">
            <div class="container">
                <div class="row justify-content-center">
                    <div class="col-lg-8 col-xxl-6">
                        <div class="text-center">
              <span class="d-inline-flex align-items-center bg-primary-50 gap-4 rounded-pill py-1 ps-1 pe-5">
                <span class="w-9 h-9 rounded-circle d-grid place-content-center bg-primary-300 clr-neutral-0 flex-shrink-0">
                  <span class="material-symbols-outlined mat-icon fw-200"> arrow_right_alt </span>
                </span>
                <span class="h5 lh-1 m-0 clr-primary-400 fw-semibold"> <?php echo $kategori['baslik']; ?> </span>
              </span>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="container-lg">
            <div class="row g-4">
                <div class="col-md-4">
                    <div class="py-6 px-8 bg-neutral-0 rounded-4 box-shadow">
                        <p class="mb-4 clr-neutral-700 fs-20 fw-medium"> Firma Ara </p>
                        <form method="get" name="ara" action="firmalar">
                            <ul class="list gap-4">
                                <li>
                                    <input name="isim" type="text" class="form-control bg-primary-3p border border-neutral-40 rounded-pill py-3 px-5" placeholder="Firma İsmi" id="first-name">
                                </li>
                                <li>
                                    <div class="property-search__select property-search__col rounded-pill px-6">
                                        <select class="form-select" name="sektor">
                                            <option>Sektör Seçiniz</option>
                                            <?php
                                            $refsor=$db->prepare("select * from proje_kat where durum='1' and dil='$_SESSION[dil]' order by sira ASC");
                                            $refsor->execute();
                                            while ($ser=$refsor->fetch(PDO::FETCH_ASSOC)) {
                                                ?>
                                                <option value="<?php echo $ser['id'] ?>"><?php echo $ser['baslik'] ?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                </li>
                                <li>
                                    <div class="property-search__select property-search__col rounded-pill px-6">
                                        <select class="form-select" name="il">
                                            <option>Şehir Seçiniz</option>
                                            <?php
                                            $sehir = $db->prepare("select * from iller order by id asc");
                                            $sehir->execute();

foreach ($sehir as $ilsen) {?>
                                                <option value="<?=$ilsen['id']?>"><?=$ilsen['name']?></option>
                                            <?php }?>
                                        </select>
                                    </div>
                                </li>
                            </ul>
                            <div class="hr-dashed my-6 opacity-50"></div>
                            <button class="btn btn-outline-primary py-3 px-6 rounded-pill d-inline-flex align-items-center justify-content-center gap-2 fw-semibold w-100 text-center">
                                <span class="material-symbols-outlined mat-icon fw-300"> rotate_right </span> Tıkla </button>
                        </form>
                    </div>
                </div>
                <div class="col-md-8">
                        <div class="row g-4">
                            <?php
                            $sayfada = 20; // sayfada gösterilecek içerik miktarını belirtiyoruz.
                            $sorgu=$db->prepare("select * from uyefirma where durum='1' and sektor='$kategori_id'");
                            $sorgu->execute();
                            $toplam_icerik=$sorgu->rowCount();
                            $toplam_sayfa = ceil($toplam_icerik / $sayfada);
                            // eğer sayfa girilmemişse 1 varsayalım.
                            $sayfa = isset($_GET['sayfa']) ? (int) $_GET['sayfa'] : 1;
                            // eğer 1'den küçük bir sayfa sayısı girildiyse 1 yapalım.
                            if($sayfa < 1) $sayfa = 1;
                            // toplam sayfa sayımızdan fazla yazılırsa en son sayfayı varsayalım.
                            if($sayfa > $toplam_sayfa) $sayfa = $toplam_sayfa;
                            $limit = ($sayfa - 1) * $sayfada;
                            $refsor=$db->prepare("select * from uyefirma where durum='1'  and sektor='$kategori_id' order by id DESC limit $limit,$sayfada");
                            $refsor->execute();
                            if ($refsor->rowCount()){
                                while ($ser=$refsor->fetch(PDO::FETCH_ASSOC)) {
                                    $iceriksor=$db->prepare("SELECT * FROM proje_kat where id=:id and durum=:durum");
                                    $iceriksor->execute(array('id' => $ser['sektor'], 'durum' => 1));
                                    $icerikcek=$iceriksor->fetch(PDO::FETCH_ASSOC);

$ilsor=$db->prepare("SELECT * FROM iller where id=:id");
                                    $ilsor->execute(array('id' => $ser['il']));
                                    $il=$ilsor->fetch(PDO::FETCH_ASSOC);

$ilcesor=$db->prepare("SELECT * FROM ilceler where id=:id");
                                    $ilcesor->execute(array('id' => $ser['ilce']));
                                    $ilce=$ilcesor->fetch(PDO::FETCH_ASSOC);
                                    ?>
                                    <div class="p-6 bg-neutral-0 rounded-4 ">
                                        <div class="d-flex align-items-center justify-content-between flex-wrap gap-3">
                                            <a href="firma/<?php echo seo($ser['id'])?>/<?php echo seo($ser['firmaismi']) ?>" target="_blank">
                                                <h5 style="font-size: 1em" class="clr-primary-300 d-inline-block mb-0"> <?php echo $icerikcek['baslik'] ?> </h5>
                                            </a>
                                            <ul class="list list-row gap-3 align-items-center">
                                                <li>
                                                    <a target="_blank" href="firma/<?php echo seo($ser['id'])?>/<?php echo seo($ser['firmaismi']) ?>" class="link w-8 h-8 d-grid place-content-center bg-primary-50 clr-primary-300 rounded-circle :bg-primary-300 :clr-neutral-0">
                                                        <span class="material-symbols-outlined mat-icon fs-20">  visibility  </span>
                                                    </a>
                                                </li>
                                            </ul>
                                        </div>
                                        <a href="firma/<?php echo seo($ser['id'])?>/<?php echo seo($ser['firmaismi']) ?>" target="_blank" style="text-decoration:none">
                                            <h3 class="mt-4 mb-8" style="font-size: 1.5em"> <?php echo $ser['firmaismi'] ?> </h3>
                                        </a>
                                        <div class="hr-dashed my-8"></div>
                                        <ul class="list list-row flex-wrap align-items-center list-divider-dot gap-4 gap-md-0">
                                            <li>
                                                <div class="d-flex align-items-center gap-2">
                                                    <span class="material-symbols-outlined mat-icon clr-secondary-500">  water_damage </span>
                                                    <p class="mb-0"> Firma Yetkilisi: <?php echo $ser['isim'] ?> </p>
                                                </div>
                                            </li>
                                            <li>
                                                <div class="d-flex align-items-center gap-2">
                                                    <span class="material-symbols-outlined mat-icon clr-secondary-500">  distance </span>
                                                    <p class="mb-0"> <?php echo $ilce['ilce_adi'] ?>/<?php echo $il['name'] ?> </p>
                                                </div>
                                            </li>
                                        </ul>
                                    </div>
                                <?php }?>

<?php }else{?>
                            <div class="p-6 bg-neutral-0 rounded-4 ">
                                <div class="d-flex align-items-center justify-content-between flex-wrap gap-3">
                                    <h4>Kategoriye ait firma bulunamadı...</h4>
                                </div>
                                </div>
                            <?php }?>
                            <div class="col-12">
                                <nav>
                                    <ul class="pagination gap-3 justify-content-center">
                                        <?php $s=0; while ($s < $toplam_sayfa) { $s++; ?>
                                            <?php if ($s==$sayfa) {?>
                                                <li class="page-item"><a class="page-link p-0 w-10 h-10 d-grid place-content-center lh-1 rounded-circle border border-primary-300 clr-neutral-0 :clr-neutral-0 active-bg"><?php echo $s; ?></a></li>
                                            <?php } else {?>
                                                <li class="page-item"><a class="page-link p-0 w-10 h-10 d-grid place-content-center lh-1 rounded-circle border border-primary-300 clr-primary-300" href="kategori/<?php echo $kategori['id']; ?>/<?php echo seo($kategori['baslik']) ?>?k=<?php echo $katid; ?>&sayfa=<?php echo $s ?>"><?php echo $s; ?></a></li>
                                            <?php   } }  ?>
                                    </ul>
                                </nav>
                            </div>
                        </div>
                </div>
            </div>
        </div>
    </div>
<?php include "includes/footer.php"; ?>

İptal

📁 PHP Dosya Yöneticisi

📝 kategori.php

📝 kategori.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)