PHP Dosya Yöneticisi

<?php
$bugun = date('Y/m/d');
$tblhaber = $db->prepare("select * from istatistik where  id=:id ");
$tblhaber->execute(array(
    ':id' => 1
));
$istatistik = $tblhaber->fetch(PDO::FETCH_ASSOC);

$buguni = $db->prepare("select * from istatistik where  tarih=:tarih ");
$buguni->execute(array(
    ':tarih' => $bugun
));
$bugunistatistik = $buguni->fetch(PDO::FETCH_ASSOC);

if (empty($bugunistatistik["views"])) {
    $kaydet = $db->prepare("insert into istatistik  set 
        views=:views
		");
    $kaydet->execute([
        ':views' => 1
    ]);
}

?>
<div class="content-body">

<div class="row justify-content-between align-items-center mb-10">

<div class="col-12 col-lg-auto mb-20">
            <div class="page-heading">
                <h3>Anasayfa <span>/ Dashboard</span></h3>
            </div>
        </div>
    </div>

<div class="row">
        
        <div class="col-xlg-3 col-md-6 col-12 mb-30">
            <div class="top-report">

<div class="head">
                    <h4>Görüntüleme</h4>
                    <a class="view"><i class="zmdi zmdi-eye"></i></a>
                </div>

<div class="content">
                    <h5>Bugün</h5>
                    <h2><?php echo $bugunistatistik["views"]; ?></h2>
                </div>

</div>
        </div>

<div class="col-xlg-3 col-md-6 col-12 mb-30">
            <div class="top-report">

<div class="head">
                    <h4>Görüntüleme</h4>
                    <a class="view"><i class="zmdi zmdi-eye"></i></a>
                </div>

<div class="content">
                    <h5>Tüm zamanlar</h5>
                    <h2><?php echo $istatistik["views"]; ?></h2>
                </div>

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

<div class="col-12 mb-30">
            <div class="box">
                <div class="box-head">
                    <h4 class="title">Mesajlar</h4>
                </div>
                <div class="box-body">
                    <div class="table-responsive">
                    <table class="table table-bordered data-table data-table-default">
                        <thead>
                            <tr>
                                <th>İsim</th>
                                <th>Tarih</th>
                                <th>website</th>
                                <th>İşlem</th>
                              
                            </tr>
                        </thead>

<tbody>
                            <?php
                            $sorgula = $db->prepare("SELECT * FROM mesajlar");
                            $sorgula->execute();
                            while ($veri = $sorgula->fetch(PDO::FETCH_ASSOC)) {
                            ?>
                                <tr>
                                    <td><?php echo $veri["email"]; ?></td>
                                    <td><?php echo $veri["date"]; ?></td>
                                    <td><?php echo $veri["website"]; ?></td>
                                    <td>
                                        <a href="?s=oku&id=<?php echo $veri["id"]; ?>" class="button mr-2 button-outline button-primary">Oku</a>
                                        <a href="config/sil.php?id=<?php echo $veri["id"]; ?>" class="button mr-2 button-outline button-danger">sil</a>
                                    </td>
                                </tr>
                            <?php } ?>
                        </tbody>

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

<?php include("pages/inc/footer.php"); ?>

<script src="assets/js/plugins/moment/moment.min.js"></script>

<script src="assets/js/plugins/daterangepicker/daterangepicker.js"></script>
<script src="assets/js/plugins/daterangepicker/daterangepicker.active.js"></script>

<script src="assets/js/plugins/chartjs/Chart.min.js"></script>
<script src="assets/js/plugins/chartjs/chartjs.active.js"></script>

<script src="assets/js/plugins/vmap/jquery.vmap.min.js"></script>
<script src="assets/js/plugins/vmap/maps/jquery.vmap.world.js"></script>
<script src="assets/js/plugins/vmap/maps/samples/jquery.vmap.sampledata.js"></script>
<script src="assets/js/plugins/vmap/vmap.active.js"></script>

</body>

</html>

İptal

📁 PHP Dosya Yöneticisi

📝 home.php

📝 home.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)