PHP Dosya Yöneticisi

<?php include 'inc/session.php'; ?>
<link rel="stylesheet" href="../assets/css/flag/flag-icon.css" >
<?php
$last_product = $db->prepare("select * from urun where dil='$_SESSION[dil]'  order by id desc limit 6");
$last_product->execute();

$product_cat = $db->prepare("select * from urun_cat where dil='$_SESSION[dil]' and anasayfa_grup='1' order by sira asc");
$product_cat->execute();

$servicess = $db->prepare("select * from hizmet where dil='$_SESSION[dil]' and durum='1' order by sira asc limit 6");
$servicess->execute();

$blogs = $db->prepare("select * from blog where dil='$_SESSION[dil]' order by id desc limit 10");
$blogs->execute();

$sipariss22 = $db->prepare("select * from siparis where NOT siparis_durum='99' order by id desc");
$sipariss22->execute();

$urunsayisi = $db->prepare("select * from ebulten");
$urunsayisi->execute();

$urunsayisi2 = $db->prepare("select * from hizmet");
$urunsayisi2->execute();

$mesaj = $db->prepare("select * from mesaj");
$mesaj->execute();

$blogsayisi = $db->prepare("select * from blog where dil='$_SESSION[dil]' ");
$blogsayisi->execute();

$projesayisi = $db->prepare("select * from proje where dil='$_SESSION[dil]' ");
$projesayisi->execute();
?>
<?php	$bugun=date("d"); // bugünün tarihi
$ay=date("m"); // bu ay
$yil=date("Y"); // bu yıl
$onlineSuresi=time()-2*60*60; // iki dakika aktif olmazsa onlineden düşecek
$ip=$_SERVER['REMOTE_ADDR']; // ziyaretçinin ip si
$bugunGiris = $db->prepare("select * from hit where ip='$ip' and gun='$bugun' and ay='$ay' and yil='$yil'");
$bugunGiris->execute();
if($bugunGiris!=0){ // yani bugün girilmişse

$allsana=$db->prepare("SELECT * FROM `hit` WHERE  `ip`='".$ip."' AND `gun`='".$bugun."'");
    $allsana->execute();
    $al = $allsana->fetch(PDO::FETCH_ASSOC);

}else{ // griş yapılmamışsa kaydettirelim

}
// evet sıra geldi online, tekil ve çoğulu Göstermeye
// online Kişi
$online=$db->prepare("SELECT * FROM hit WHERE simdi>='$onlineSuresi'")->rowCount(); // onlnie kişilerimiz
// çoğul hitler

// çoğul hitler
$bugunFor = $db->prepare("SELECT SUM(sayac) FROM hit WHERE gun='$bugun' AND ay='$ay' AND yil='$yil' ORDER BY id desc");
$bugunFor->execute();
$bugunx = $bugunFor->fetch(PDO::FETCH_ASSOC);
$bugun_cogul=$bugunx['SUM(sayac)']; // bugün çoğul

$dunFor = $db->prepare("SELECT SUM(sayac) FROM hit WHERE gun='".($bugun-1)."' AND ay='$ay' AND yil='$yil' ORDER BY id desc");
$dunFor->execute();
$dunx = $dunFor->fetch(PDO::FETCH_ASSOC);
$dun_cogul=$dunx['SUM(sayac)']; // dün Çoğul

$ayFor = $db->prepare("SELECT SUM(sayac) FROM hit WHERE ay='$ay' AND yil='$yil' ORDER BY id desc");
$ayFor->execute();
$ayx = $ayFor->fetch(PDO::FETCH_ASSOC);
$buay_cogul=$ayx['SUM(sayac)']; // dün Çoğul

$toplamFor = $db->prepare("SELECT SUM(sayac) FROM hit WHERE ay='$ay' AND yil='$yil' ORDER BY id desc");
$toplamFor->execute();
$toplamx = $toplamFor->fetch(PDO::FETCH_ASSOC);
$toplam_cogul=$toplamx['SUM(sayac)']; // dün Çoğul

// tekil hitler
$buguntekilcek=$db->prepare("SELECT * FROM hit WHERE gun='$bugun' AND ay='$ay' AND yil='$yil'");
$buguntekilcek->execute();
$bugun_tekil = $buguntekilcek->rowCount();

$buaytekikcek=$db->prepare("SELECT * FROM hit WHERE  ay='$ay' AND yil='$yil'");
$buaytekikcek->execute();
$buay_tekil = $buaytekikcek->rowCount();

$toplamtekilcek=$db->prepare("SELECT * FROM hit ");
$toplamtekilcek->execute();
$toplam_tekil = $toplamtekilcek->rowCount();

?>
<!DOCTYPE html>
<html lang="tr" class="<?php if ($ayar['gecegunduz'] == 0){echo 'dark';}else{echo 'light';}?>">

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Yönetici Paneli</title>
    
    <link rel="stylesheet" href="dist/css/app.css" />
    <link rel="icon" type="image/png" sizes="16x16" href="../images/favicon.ico">
    
    <style>

@media (max-width: 767px) {
            .mo {
                display: none !important;
            }
        }
        @media (min-width: 767px) {
            .ma {
                display: none !important;
        }

</style>
</head>

<body class="main">
<?php include "inc/mobil_menu.php"; ?>
<?php include "inc/panel_ust.php"; ?>
<div class="wrapper">
    <div class="wrapper-box">
        <?php include "inc/panel-sidebar.php"; ?>
        
        <div class="content">
            <div class="grid grid-cols-12 gap-6">
                <div class="col-span-12 2xl:col-span-9">
                    <div class="grid grid-cols-12 gap-6">
                        
                        <div class="col-span-12 mt-8">
                            <div class="intro-y flex items-center h-10">
                                <h2 class="text-lg font-medium truncate mr-5">
                                    Genel Veriler
                                </h2>
                                <a href="" class="ml-auto flex items-center text-primary"> <i data-lucide="refresh-ccw" class="w-4 h-4 mr-3"></i> Yenile </a>
                            </div>
                            <div class="grid grid-cols-12 gap-6 mt-5">
                                <div class="col-span-12 sm:col-span-6 xl:col-span-3 intro-y">
                                    <div class="report-box zoom-in">
                                        <div class="box p-5">
                                            <div class="flex">
                                                <i data-lucide="package" class="report-box__icon text-primary"></i>
                                            </div>
                                            <div class="text-3xl font-medium leading-8 mt-6"><?php echo $urunsayisi2->rowCount() ?></div>
                                            <div class="text-base text-slate-500 mt-1">TOPLAM HİZMET</div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-span-12 sm:col-span-6 xl:col-span-3 intro-y">
                                    <div class="report-box zoom-in">
                                        <div class="box p-5">
                                            <div class="flex">
                                                <i data-lucide="book" class="report-box__icon text-pending"></i>
                                            </div>
                                            <div class="text-3xl font-medium leading-8 mt-6"><?php echo $blogsayisi->rowCount() ?></div>
                                            <div class="text-base text-slate-500 mt-1">TOPLAM BLOG YAZISI</div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-span-12 sm:col-span-6 xl:col-span-3 intro-y">
                                    <div class="report-box zoom-in">
                                        <div class="box p-5">
                                            <div class="flex">
                                                <i data-lucide="inbox" class="report-box__icon text-warning"></i>
                                            </div>
                                            <div class="text-3xl font-medium leading-8 mt-6"><?=$mesaj->rowCount()?></div>
                                            <div class="text-base text-slate-500 mt-1">TOPLAM MESAJ</div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-span-12 sm:col-span-6 xl:col-span-3 intro-y">
                                    <div class="report-box zoom-in">
                                        <div class="box p-5">
                                            <div class="flex">
                                                <i data-lucide="smile" class="report-box__icon text-success"></i>
                                            </div>
                                            <div class="text-3xl font-medium leading-8 mt-6"><?php echo $urunsayisi->rowCount() ?></div>
                                            <div class="text-base text-slate-500 mt-1">TOPLAM ABONE</div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="col-span-12 mt-6">
                            <div class="intro-y block sm:flex items-center h-10">
                                <h2 class="text-lg font-medium truncate mr-5">
                                    Son İletişim Mesajları
                                </h2>
                                <div class="flex items-center sm:ml-auto mt-3 sm:mt-0">
                                    <a href="pages.php?sayfa=mesajlar" class="ml-3 btn box flex items-center text-slate-600 dark:text-slate-300"> <i data-lucide="file-text" class="hidden sm:block w-4 h-4 mr-2"></i> TÜMÜNÜ GÖRÜNTÜLE </a>
                                </div>
                            </div>
                            <div class="intro-y overflow-auto lg:overflow-visible mt-8 sm:mt-0">
                                <table class="table table-report sm:mt-2">
                                    <thead>
                                    <tr>
                                        <th class="whitespace-nowrap">İSİM</th>
                                        <th class="whitespace-nowrap">E-POSTA</th>
                                        <th class="text-center whitespace-nowrap">TELEFON</th>
                                        <th class="text-center whitespace-nowrap">GÖNDERİLME TARİHİ</th>
                                        <th class="text-center whitespace-nowrap">#</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    <?php
                                    $mesajjkutusuu = $db ->prepare("select * from mesaj order by id desc LIMIT 8");
                                    $mesajjkutusuu ->execute();
                                    foreach ($mesajjkutusuu as $mesaj) {?>
                                    <tr class="intro-x">
                                        <td class="w-40">
                                            <a href="pages.php?sayfa=mesaj&mesaj_id=<?=$mesaj['id']?>" class="font-medium whitespace-nowrap"><?=$mesaj['isim']?></a>
                                        </td>
                                        <td>
                                            <?=$mesaj['eposta']?>
                                        </td>
                                        <td class="text-center"><?=$mesaj['telno']?></td>
                                        <td class="text-center"><?php echo date_tr('j F Y, H:i, l ', ''.$mesaj['tarih'].''); ?></td>
                                        <td class="table-report__action w-56">
                                            <div class="flex justify-center items-center">
                                                <a class="flex items-center mr-3" href="pages.php?sayfa=mesaj&mesaj_id=<?=$mesaj['id']?>"> <i data-lucide="eye" class="w-4 h-4 mr-1"></i> Görüntüle </a>
                                            </div>
                                        </td>
                                    </tr>
                                    <?php }?>
                                    </tbody>
                                </table>
                            </div>
                        </div>

</div>
                </div>
                <div class="col-span-12 2xl:col-span-3">
                    <div class="2xl:border-l -mb-10 pb-10">
                        <div class="2xl:pl-6 grid grid-cols-12 gap-6">
                            
                            <div class="col-span-12 md:col-span-6 xl:col-span-4 2xl:col-span-12 mt-3 2xl:mt-8">
                                <div class="intro-x flex items-center h-10">
                                    <h2 class="text-lg font-medium truncate mr-5">
                                        Online Sayaç
                                    </h2>
                                </div>
                                <div class="mt-5">
                                    <div class="intro-x">
                                        <div class="report-box zoom-in">
                                            <div class="box p-5">
                                                <div class="flex">
                                                    <i data-lucide="users" class="report-box__icon text-primary"></i>
                                                </div>
                                                <div class="text-3xl font-medium leading-8 mt-6">
                                                    <?php include 'online.php'; ?>
                                                    </div>
                                                <div class="text-base text-slate-500 mt-1">Online Sayısı</div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="intro-x" style="margin-top: 30px">
                                        <div class="report-box zoom-in">
                                            <div class="box p-5">
                                                <div class="flex">
                                                    <i data-lucide="users" class="report-box__icon text-warning"></i>
                                                </div>
                                                <div class="text-3xl font-medium leading-8 mt-6"><?php echo $bugun_tekil; ?></div>
                                                <div class="text-base text-slate-500 mt-1">Günlük Hit
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="intro-x" style="margin-top: 30px">
                                        <div class="report-box zoom-in">
                                            <div class="box p-5">
                                                <div class="flex">
                                                    <i data-lucide="users" class="report-box__icon text-pending"></i>
                                                </div>
                                                <div class="text-3xl font-medium leading-8 mt-6"><?php echo $buay_tekil; ?></div>
                                                <div class="text-base text-slate-500 mt-1">Bu Aylık Hit
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="intro-x" style="margin-top: 30px">
                                        <div class="report-box zoom-in">
                                            <div class="box p-5">
                                                <div class="flex">
                                                    <i data-lucide="users" class="report-box__icon text-success"></i>
                                                </div>
                                                <div class="text-3xl font-medium leading-8 mt-6"><?php echo $toplam_tekil; ?></div>
                                                <div class="text-base text-slate-500 mt-1">Toplam Hit
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

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

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

<script src="https://developers.google.com/maps/documentation/javascript/examples/markerclusterer/markerclusterer.js"></script>
<script src="https://maps.googleapis.com/maps/api/js?key=["your-google-map-api"]&libraries=places"></script>
<script src="dist/js/app.js"></script>

</body>
</html>

İptal

📁 PHP Dosya Yöneticisi

📝 index.php

📝 index.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)