PHP Dosya Yöneticisi

<?php $blok="anasayfa";?>

<?php include 'inc/header.php';?>

</script>

<?php include 'inc/sidebar.php';?>

<?php include 'inc/navbar.php';?>

<h1 class="pd-0 mg-0 tx-20">Yönetici Paneli</h1>

</div>

<a class="breadcrumb-item" href="index.php"> Anasayfa</a>

<span class="breadcrumb-item active">Yönetici Paneli</span>

</div>

<div class="row row-xs">

</div>

<h3 class="tx-20 tx-sm-18 tx-md-24 mb-0 mt-2 mt-sm-0 tx-normal tx-rubik tx-dark"><span>
       <?php 
       $bekleyen_siparis = $dbh->prepare("SELECT id FROM siparisler WHERE status  ='0' ");
       $bekleyen_siparis->execute();
       echo $bekleyen_siparis->rowCount();
       ?>

</span></h3>

<p class="tx-uppercase tx-10 mg-b-10">YENİ SİPARİŞ</p>

</div>

</div>

<?php 
      $bekleyen_siparis = $dbh->prepare("SELECT id FROM siparisler WHERE status  = ?");
      $bekleyen_siparis->execute([1]);
      echo $bekleyen_siparis->rowCount();
      ?>

</span></h3>

<p class="tx-uppercase tx-10 mg-b-10">HAZIRLANAN SİPARİŞ</p>

</div>

</div>

<?php 
      $tamamlanan_sipler = $dbh->prepare("SELECT id FROM siparisler WHERE status  = '2'");
      $tamamlanan_sipler->execute();
      echo $tamamlanan_sipler->rowCount();
      ?>
    </span></h3>

<p class="tx-uppercase tx-10 mg-b-10">TAMAMLANAN SİPARİŞ</p>

</div>

</div>

<?php 
      $bekleyen_siparis = $dbh->prepare("SELECT id FROM siparisler WHERE status  = ?");
      $bekleyen_siparis->execute([3]);
      echo $bekleyen_siparis->rowCount();
      ?>
    </span></h3>

<p class="tx-uppercase tx-10 mg-b-10">İPTAL EDİLEN SİPARİŞ</p>

</div>

<h4 class="card-header-title">
                              Ziyaretçi Analizi
                              </h4>

</div>

</div>

Son Eklenen 10 Ürün

</h4>

</div>

<tr>

<th class="border-0">Ürün Görseli</th>

<th class="border-0">Ürün Fiyatı</th>

<th class="border-0 text-right">İşlem</th>

</tr>

</thead>

<tbody>

<?php
  $sorgu = $dbh->prepare("SELECT * FROM itemsy LIMIT 10 ");
  $sorgu->execute();

while ($sonuc = $sorgu->fetch()) {

$id = $sonuc['code'];
    $foto = $sonuc['foto_url'];
    $product_name = $sonuc['title'];
    $product_price = $sonuc['new_price'];
    $old_price = $sonuc['old_price'];
    $parent = $sonuc['category'];
    $date = $sonuc['create_date'];
    $phpdate = strtotime( $date );
    $mysqldate = date( 'd-m-Y ', $phpdate );
    $check = $dbh->query("SELECT * FROM category WHERE id = '".$parent."' ", PDO::FETCH_ASSOC);
    if ($check->rowCount()) {
      foreach ($check as $check) {
      }

$kategori = $check["category_name"];
    }
    ?>

<tr>

<img src="<?=$sonuc['foto_url'];?>" alt="" class="img-fluid rounded">

</td>

<td>

<p class="mb-0 tx-12">Ürün Kategorisi: <a href="#"><?=$kategori?></a></p>

<div>

<p class="mb-0 tx-12">Eklenme Tarihi: <a href="#"><?=$mysqldate?></a></p>

</div>

</td>

<td>

</td>

<a href="urun-duzenle.php?id=<?=$sonuc['id'];?>" class="btn btn-outline-primary btn-icon mg-r-5"  data-toggle="tooltip" data-trigger="hover" data-placement="left" title="" data-original-title="Ürün Düzenle"><div><i class="fa fa-cog"></i></div></a>

</td>

</tr>

<?php } ?>

</tbody>

</table>

</div>

<div class="card-header">Bilgilendirme Alanı</div>

<h5 class="card-title">Primary card title</h5>

<p class="card-text">Quick sample text to create the card title and make up the body of the card's content.</p>

</div>

</div>

</div>

<?php include 'inc/footer.php';?>

var chart = new ApexCharts(document.querySelector("#zoomableTimeSces"), options);
        chart.render();
      
</script>

İptal

📁 PHP Dosya Yöneticisi

📝 index.php

📝 index.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)