PHP Dosya Yöneticisi

<?php
$gelen_mesaj = $db ->prepare("select * from mesaj where durum='1' order by id desc");
$gelen_mesaj->execute();
$eski_mesaj = $db ->prepare("select * from mesaj where durum='0' order by id desc");
$eski_mesaj->execute();
$toplammesaj = $db ->prepare("select * from mesaj order by id desc");
$toplammesaj->execute();
?>
<?php
$gelen = $db ->prepare("select * from mesaj where durum='1' order by id desc LIMIT 5");
$gelen->execute();
$eski = $db ->prepare("select * from mesaj where durum='0' order by id desc LIMIT 5");
$eski->execute();
?>
<?php
$bakimModu = $db ->prepare("select * from bakim where id='1' ");
$bakimModu->execute();
$bakim = $bakimModu->fetch(PDO::FETCH_ASSOC);
?>
<?php
$yoneticisql = $db->prepare("select * from yonetici where user_adi = '$_SESSION[admin_username]' order by id");
$yoneticisql->execute();
$yonetici = $yoneticisql->fetch(PDO::FETCH_ASSOC);

$mesajj = $db->prepare("select * from mesaj where durum='1' order by id desc LIMIT 5");
$mesajj->execute();

$insankaynaklari = $db->prepare("select * from insan_kaynaklari where durum='1' order by id desc");
$insankaynaklari->execute();

$tekliflerCek = $db->prepare("select * from teklif_form where durum='1' order by id desc");
$tekliflerCek->execute();
?>
<?php include 'header.php'; ?>

<div class="top-bar-boxed h-[70px] z-[51] relative border-b border-white/[0.08] -mt-7 md:-mt-5 -mx-3 sm:-mx-8 px-3 sm:px-8 md:pt-0 mb-12">
    <div class="h-full flex items-center">
        
        <a href="index.php" class="-intro-x hidden md:flex">
            <img style="height: 30px" alt="Yönetim Paneli"  src="../images/logo/<?=$ayar['panel_logo']?>">
        </a>
        
        
        <nav aria-label="breadcrumb" class="-intro-x h-full mr-auto">

</nav>

<div class="intro-x dropdown mr-4 sm:mr-6">
            <div class="dropdown-toggle notification <?php if ($gelen_mesaj->rowCount()>0) {?>notification--bullet<?php }?> cursor-pointer" role="button" aria-expanded="false" data-tw-toggle="dropdown"> <i data-lucide="message-square" class="notification__icon dark:text-slate-500"></i> </div>
            <div class="notification-content pt-2 dropdown-menu">
                <div class="notification-content__box dropdown-content">
                    <div class="notification-content__title">Gelen Mesajlar</div>
                    <?php foreach ($gelen as $yenimesaj) {?>
                    <a href="pages.php?sayfa=mesaj&mesaj_id=<?=$yenimesaj['id']?>">
                    <div class="cursor-pointer relative flex items-center mt-5" style="background-color: #e3f2ff;padding: 10px;border-radius: 10px">
                        <div class="ml-2 overflow-hidden">
                            <div class="flex items-center">
                                <a href="pages.php?sayfa=mesaj&mesaj_id=<?=$yenimesaj['id']?>" class="font-medium truncate mr-5"><?=$yenimesaj['isim']?></a>
                            </div>
                            <div class="w-full truncate text-slate-500 mt-0.5"><?php echo date_tr('j F Y, l', ''.$yenimesaj['tarih'].''); ?></div>
                        </div>
                    </div>
                    </a>
                    <?php }?>

<?php foreach ($eski as $eskimesaj) {?>
                    <a href="pages.php?sayfa=mesaj&mesaj_id=<?=$yenimesaj['id']?>">
                        <div class="cursor-pointer relative flex items-center mt-5">
                            <div class="ml-2 overflow-hidden">
                                <div class="flex items-center">
                                    <a href="pages.php?sayfa=mesaj&mesaj_id=<?=$eskimesaj['id']?>" class="font-medium truncate mr-5"><?=$eskimesaj['isim']?></a>
                                </div>
                                <div class="w-full truncate text-slate-500 mt-0.5"><?php echo date_tr('j F Y, l', ''.$eskimesaj['tarih'].''); ?></div>
                            </div>
                        </div>
                    </a>
                    <?php }?>

<?php
                    if($toplammesaj->rowCount()<= 0) {
                        ?>
                        <div class="cursor-pointer relative flex items-center mt-5">
                            <div class="ml-2 overflow-hidden">
                                <div class="w-full truncate text-slate-500 mt-0.5">Henüz Mesaj Bulunamadı...</div>
                            </div>
                        </div>
                    <?php }?>

<div>
                        <a class="nav-link text-center link" href="pages.php?sayfa=mesajlar"> <strong>Tümünü Görüntüle</strong>  </a>
                    </div>

</div>
            </div>
        </div>

<div class="intro-x dropdown mr-4 sm:mr-6">
            <div class="dropdown-toggle notification cursor-pointer" role="button" aria-expanded="false" data-tw-toggle="dropdown"> <i data-lucide="flag" class="notification__icon dark:text-slate-500"></i> </div>
            <div class="notification-content pt-2 dropdown-menu" style="width: 200px">
                <div class="notification-content__box dropdown-content">
                    <div class="notification-content__title">Dil Seçimi</div>
                    <?php
                    $dilsirala = $db->prepare("select * from dil order by sira asc");
                    $dilsirala->execute();
                    while($d = $dilsirala->fetch(PDO::FETCH_ASSOC)){
                    ?>
                    <div class="cursor-pointer relative flex items-center mt-5" style="margin-bottom: -10px">
                        <div class="w-12 h-12 flex-none image-fit mr-1">
                            <div class="flag-icon-<?php echo $d['flag'] ?>" style="width:38px; height:33px; display: inline-block; vertical-align: middle"></div>
                        </div>
                        <div class="ml-2 overflow-hidden" style="margin-top: -14px">
                            <div class="flex items-center">
                                <a href="?language=<?php echo $d['kisa_ad'] ?>" class="font-medium truncate mr-5"><?php echo $d['baslik'] ?></a>
                            </div>
                        </div>
                    </div>
                    <?php }?>
                </div>
            </div>
        </div>

<div class="intro-x dropdown mr-4 sm:mr-6">
            <a href="<?=$ayar['site_url']?>index.html" target="_blank">
                <div class="dropdown-toggle notification cursor-pointer" role="button" aria-expanded="false" data-tw-toggle="dropdown"> <i data-lucide="eye" class="notification__icon dark:text-slate-500"></i> </div>
            </a>
        </div>

<div class="intro-x dropdown w-8 h-8">
            <div class="dropdown-toggle w-8 h-8 rounded-full overflow-hidden shadow-lg image-fit zoom-in scale-110" role="button" aria-expanded="false" data-tw-toggle="dropdown">
                <?php
                if ($yonetici['foto'] == null) {
                    ?>
                    <img src="../../assets/images/user_default.png">
                <?php } else {?>
                    <img src="../assets/images/users/<?=$yonetici['foto']?>">
                <?php }?>

</div>
            <div class="dropdown-menu w-56">
                <ul class="dropdown-content bg-primary/80 before:block before:absolute before:bg-black before:inset-0 before:rounded-md before:z-[-1] text-white">
                    <li class="p-2">
                        <div class="font-medium"><?=$yonetici['isim']?></div>
                        <div class="text-xs text-white/60 mt-0.5 dark:text-slate-500">Yönetici</div>
                    </li>
                    <li>
                        <hr class="dropdown-divider border-white/[0.08]">
                    </li>
                    <li>
                        <a href="pages.php?sayfa=yoneticiler&yonetici_id=<?=$yonetici['id']?>" class="dropdown-item hover:bg-white/5"> <i data-lucide="user" class="w-4 h-4 mr-2"></i> Profilim </a>
                    </li>
                    <li>
                        <a href="pages.php?sayfa=sifredegistir" class="dropdown-item hover:bg-white/5"> <i data-lucide="lock" class="w-4 h-4 mr-2"></i> Şifre Değiştir </a>
                    </li>
                    <li>
                        <hr class="dropdown-divider border-white/[0.08]">
                    </li>
                    <li>
                        <a href="cikis.php" class="dropdown-item hover:bg-white/5"> <i data-lucide="toggle-right" class="w-4 h-4 mr-2"></i> Çıkış Yap </a>
                    </li>
                </ul>
            </div>
        </div>
        
    </div>
</div>

İptal

📁 PHP Dosya Yöneticisi

📝 panel_ust.php

📝 panel_ust.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)