PHP Dosya Yöneticisi

<?php include 'support/session.php'; ?>
<?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 urun");
$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">

<?php include 'support/panel_header_libs.php'?>

</head>

<?php include "support/panel_parts/panel_topbar.php";?>

<?php include "support/panel_parts/panel_leftbar.php";?>

<div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h4 class="text-themecolor"><i class="icon-speedometer"></i> Gösterge Paneli</h4>
                </div>
                <div class="col-md-7 align-self-center text-right">
                    <div class="d-flex justify-content-end align-items-center">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="javascript:void(0)">Yönetim Paneli</a></li>
                            <li class="breadcrumb-item active">Gösterge Paneli</li>
                        </ol>
                    </div>
                </div>
            </div>

<div class="row">
                
                <div class="col-lg-3 col-md-6">
                    <div class="card">
                        <div class="d-flex flex-row">
                            <div class="p-10 bg-info">
                                <h3 class="text-white box m-b-0"><i class="icon-people"></i></h3></div>
                            <div class="align-self-center m-l-20">
                                <h3 class="m-b-0 text-info">
                                    <p id="onlinever" style="padding: 0px; margin: 0px"></p>
                                    <script>
                                        function veriler2(){ $.get("support/online.php",function(data){ jQuery('#onlinever').html(data); }); }
                                        window.setInterval("veriler2()",3000);
                                    </script></h3>
                                <h5 class="text-muted m-b-0">Online Sayısı</h5></div>
                        </div>
                    </div>
                </div>
                
                
                <div class="col-lg-3 col-md-6">
                    <div class="card">
                        <div class="d-flex flex-row">
                            <div class="p-10 bg-success">
                                <h3 class="text-white box m-b-0"><i class="icon-people"></i></h3></div>
                            <div class="align-self-center m-l-20">
                                <h3 class="m-b-0 text-success"><?php echo $bugun_tekil; ?></h3>
                                <h5 class="text-muted m-b-0">Günlük Hit </h5>
                            </div>
                        </div>
                    </div>

</div>
                
                
                <div class="col-lg-3 col-md-6">
                    <div class="card">
                        <div class="d-flex flex-row">
                            <div class="p-10 bg-inverse">
                                <h3 class="text-white box m-b-0"><i class="icon-people"></i></h3></div>
                            <div class="align-self-center m-l-20">
                                <h3 class="m-b-0"><?php echo $buay_tekil; ?></h3>
                                <h5 class="text-muted m-b-0">Bu Aylık Hit</h5></div>
                        </div>
                    </div>
                </div>
                
                
                <div class="col-lg-3 col-md-6">
                    <div class="card">
                        <div class="d-flex flex-row">
                            <div class="p-10 bg-primary">
                                <h3 class="text-white box m-b-0"><i class="icon-people"></i></h3></div>
                            <div class="align-self-center m-l-20">
                                <h3 class="m-b-0 text-primary"><?php echo $toplam_tekil; ?></h3>
                                <h5 class="text-muted m-b-0">Toplam Hit</h5></div>
                        </div>
                    </div>
                </div>
                
            </div>

<div class="col-lg-3 col-md-6">
                    <div class="card" style="background: linear-gradient(45deg, #45c0ba, #76c880) !important;">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="d-flex no-block align-items-center">
                                        <div>
                                            <h3><i class="icon-social-dropbox text-secondary"></i></h3>
                                            <p class="text-secondary">TOPLAM ÜRÜN</p>
                                        </div>
                                        <div class="ml-auto">
                                            <h2 class="counter text-secondary"><?php echo $urunsayisi2->rowCount() ?></h2>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="progress">
                                        <div class="progress-bar bg-secondary" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="col-lg-3 col-md-6">
                    <div class="card" style="background: linear-gradient(45deg, #705be1, #52d8c6) !important;">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="d-flex no-block align-items-center">
                                        <div>
                                            <h3><i class="icon-pencil text-secondary"></i></h3>
                                            <p class="text-secondary">TOPLAM BLOG YAZISI</p>
                                        </div>
                                        <div class="ml-auto">
                                            <h2 class="counter text-secondary"><?php echo $blogsayisi->rowCount() ?></h2>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="progress">
                                        <div class="progress-bar bg-info" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="col-lg-3 col-md-6">
                    <div class="card" style="background: linear-gradient(45deg, #635bd6, #f742aa) !important;">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="d-flex no-block align-items-center">
                                        <div>
                                            <h3><i class="icon-handbag text-secondary"></i></h3>
                                            <p class="text-secondary">TOPLAM MESAJ</p>
                                        </div>
                                        <div class="ml-auto">
                                            <h2 class="counter text-secondary"><?=$mesaj->rowCount()?></h2>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="progress">
                                        <div class="progress-bar bg-primary" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="col-lg-3 col-md-6">
                    <div class="card" style="background: linear-gradient(45deg, #45c0ba, #76c880) !important;">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="d-flex no-block align-items-center">
                                        <div>
                                            <h3><i class="icon-social-dropbox text-secondary"></i></h3>
                                            <p class="text-secondary">TOPLAM ABONE</p>
                                        </div>
                                        <div class="ml-auto">
                                            <h2 class="counter text-secondary"><?php echo $urunsayisi->rowCount() ?></h2>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="progress">
                                        <div class="progress-bar bg-secondary" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>

<div class="row">
                
                
                
                <div class="col-lg-6">
                    <div class="card">
                        <div class="card-body">
                            <h5 class="card-title">Son Blog Yazıları
                                <a href="pages.php?sayfa=bloglar">
                                <span class="text-muted pull-right" style="font-size:13px; padding-top: 4px">
                                TÜMÜ
                                </span>
                                </a>
                            </h5>
                        </div>
                        <div class="card-body bg-light" style="border-bottom: 1px solid #dee2e6;">
                            <div class="row">
                                <div class="col-6">
                                    <a href="pages.php?sayfa=blogekle" role="button" class="btn btn-success"><i class="mdi mdi-plus"></i> YENİ BLOG EKLE</a>
                                </div>
                                <div class="col-6 align-self-center display-6 text-right">
                                    <h6 class="text-muted">Sol butondan yeni blog ekleyebilirsiniz</h6></div>
                            </div>
                        </div>
                        
                        
                        
                        <div class="comment-widgets" <?php if($blogs->rowCount()>3) {?>id="slimtest2" style="height: 528px;"<?php }?>>
                            
                            <?php foreach ($blogs as $blog) {?>
                                <div class="d-flex no-block comment-row">
                                    <div class="p-2"><img src="../images/blog/<?=$blog['gorsel']?>" alt="user" width="80" height="55"></div>
                                    <div class="comment-text w-100">
                                        <h5 class="font-medium"><?=$blog['baslik']?></h5>
                                        <p class="m-b-10 text-muted"><?=$blog['spot']?></p>
                                        <div class="comment-footer">
                                            <span class="text-muted pull-right"><?php echo date_tr('j F Y, l ', ''.$blog['tarih'].''); ?></span>

<?php if($blog['anasayfa'] == 1) {?>
                                                <span class="badge badge-pill badge-success"><i class="fa fa-home"></i> Anasayfa Onaylı</span>
                                            <?php } else {?>
                                                <span class="badge badge-pill badge-dark"><i class="fa fa-times"></i> Anasayfa Onaysız</span>
                                            <?php }?>

<?php if($blog['durum'] == 1) {?>
                                                <span class="badge badge-pill badge-info"><i class="fa fa-check"></i> Yayında</span>
                                            <?php } else {?>
                                                <span class="badge badge-pill badge-danger"><i class="fa fa-times"></i> Yayında Değil</span>
                                            <?php }?>

<span class="action-icons">
                                                    <a href="pages.php?sayfa=blog&blog_id=<?=$blog['id']?>"><i class="ti-pencil-alt"></i></a>
                                        </span>
                                        </div>
                                    </div>
                                </div>
                            <?php }?>
                            <?php
                            if($blogs->rowCount()<=0) {
                                ?>

<div style="width: 100%; padding: 30px 0 10px 0; text-align: center">
                                    <h4>Henüz blog yazısı eklenmemiş!</h4>
                                </div>

<?php }?>

</div>
                    </div>
                </div>
                
                
                
                <div class="col-lg-6">

<?php
                    $telsayisicek = $db ->prepare("select * from sms_numaralar");
                    $telsayisicek->execute();

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

<a alt="default" href="pages.php?sayfa=toplusmsgonder" style="cursor: pointer">
                        <div class="col-lg-12 col-md-12" style="padding-left: 0; padding-right: 0" >
                            <div class="card" style="background: linear-gradient(45deg, #635bd6, #f742aa) !important;">
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-md-12">
                                            <div class="d-flex no-block align-items-center">
                                                <div>
                                                    <h3><i class="mdi mdi-cellphone-basic text-secondary"></i> <i class="icon-action-undo text-secondary"></i></h3>
                                                    <p class="text-secondary" ><?=$telsayisicek->rowCount()?> Kayıtlı Numara</p>
                                                </div>
                                                <div class="ml-auto">
                                                    <h4 class="counter text-secondary">TOPLU SMS GÖNDER</h4>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-12">
                                            <div class="progress">
                                                <div class="progress-bar bg-primary" role="progressbar" style="width: 100%; height: 3px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </a>

<a alt="default" href="pages.php?sayfa=ebultengonder" style="cursor: pointer">
                        <div class="col-lg-12 col-md-12" style="padding-left: 0; padding-right: 0; " >
                            <div class="card" style=" background: linear-gradient(45deg, #212529, #666) !important;">
                                <div class="card-body" >
                                    <div class="row">
                                        <div class="col-md-12">
                                            <div class="d-flex no-block align-items-center">
                                                <div>
                                                    <h3><i class="icon-envelope-open text-secondary"></i> <i class="icon-action-undo text-secondary"></i></h3>
                                                    <p class="text-secondary" ><?=$mailSayisicek->rowCount()?> Kayıtlı E-Posta</p>
                                                </div>
                                                <div class="ml-auto">
                                                    <h4 class="counter text-secondary">TOPLU E-POSTA GÖNDER</h4>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-12">
                                            <div class="progress">
                                                <div class="progress-bar bg-warning" role="progressbar" style="width: 100%; height: 3px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </a>

</div>
            </div>

<?php include "support/panel_parts/panel_rightbar.php"; ?>
        </div>

</div>

<footer class="footer">
        Yönetim Paneli   -  <?=$ayar['site_baslik']?>
    </footer>

</div>

<?php include 'support/panel_footer_libs.php';?>

</body>

</html>

İptal

📁 PHP Dosya Yöneticisi

📝 index.php

📝 index.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)