PHP Dosya Yöneticisi

<?php $blok="anasayfa";?>
<?php include 'inc/header.php';?>
<?php include 'inc/sidebar.php';?>
<?php include 'inc/navbar.php';?>

<div class="page-inner">
               
               <div id="main-wrapper">
                  
                  
                  
                  <div class="pageheader pd-t-25 pd-b-35">
                     <div class="pd-t-5 pd-b-5">
                        <h1 class="pd-0 mg-0 tx-20">Yönetici Paneli</h1>
                     </div>
                     <div class="breadcrumb pd-0 mg-0">
                        <a class="breadcrumb-item" href="index.php">Anasayfa</a>
                        <span class="breadcrumb-item active"> Şuan: Anasayfa</span>
                     </div>
                  </div>
                  
                  
                  
                  
                  <?php
     $bilgial = $dbh->query("SELECT * FROM arac_reservbilgial WHERE id ", PDO::FETCH_ASSOC);
     $kredial = $dbh->query("SELECT * FROM arac_reservkredial WHERE id ", PDO::FETCH_ASSOC);
     $aracsatiyorum = $dbh->query("SELECT * FROM arac_satiyorum WHERE id ", PDO::FETCH_ASSOC);
     $iletisim = $dbh->query("SELECT * FROM bize_ulasin WHERE id ", PDO::FETCH_ASSOC);
     ?>    
                  <div class="row row-xs clearfix">
                  <div class="col-sm-3 col-xl-3">
                       <div class="card mg-b-20">
                          <div class="card-body">
                             <div class="row">
                                <div class="col-12">
                                   <div class="float-right">
                                      <i class="tx-30 tx-success  icon-close"></i>
                                   </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 class="counter">
                                   <?=$bilgial->rowCount()?>
                                   </span></h3>
                                   <p class="tx-uppercase tx-10 mg-b-10">Bilgi Al Talepleri</p>
                                </div>
                             </div>
                          </div>
                       </div>
                    </div>

<div class="col-sm-3 col-xl-3">
                       <div class="card mg-b-20">
                          <div class="card-body">
                             <div class="row">
                                <div class="col-12">
                                   <div class="float-right">
                                      <i class="tx-30 tx-success  icon-close"></i>
                                   </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 class="counter">
                                   <?=$kredial->rowCount()?>
                                   </span></h3>
                                   <p class="tx-uppercase tx-10 mg-b-10">Kredi Al Talepleri</p>
                                </div>
                             </div>
                          </div>
                       </div>
                    </div>

<div class="col-sm-3 col-xl-3">
                       <div class="card mg-b-20">
                          <div class="card-body">
                             <div class="row">
                                <div class="col-12">
                                   <div class="float-right">
                                      <i class="tx-30 tx-success  icon-close"></i>
                                   </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 class="counter">
                                   <?=$aracsatiyorum->rowCount()?>
                                   </span></h3>
                                   <p class="tx-uppercase tx-10 mg-b-10">Araçımı Satıyorum Talepleri</p>
                                </div>
                             </div>
                          </div>
                       </div>
                    </div>

<div class="col-sm-3 col-xl-3">
                       <div class="card mg-b-20">
                          <div class="card-body">
                             <div class="row">
                                <div class="col-12">
                                   <div class="float-right">
                                      <i class="tx-30 tx-success  icon-close"></i>
                                   </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 class="counter">
                                   <?=$iletisim->rowCount()?>
                                   </span></h3>
                                   <p class="tx-uppercase tx-10 mg-b-10">İletişim Talepleri</p>
                                </div>
                             </div>
                          </div>
                       </div>
                    </div>

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

</div>

</div>

<div class="col-md-6 col-lg-6">
                        <div class="card mg-b-20">
                           <div class="card-header">
                              <h4 class="card-header-title">
                              Bilgi Al Talepleri
                              </h4>
                              <div class="card-header-btn">
                                 <a  href="#" data-toggle="collapse" class="btn card-collapse" data-target="#collapse2" aria-expanded="true"><i class="ion-ios-arrow-down"></i></a>
                                 <a href="#" data-toggle="refresh" class="btn card-refresh"><i class="ion-android-refresh"></i></a>
                                 <a href="#" data-toggle="expand" class="btn card-expand"><i class="ion-android-expand"></i></a>
                                 <a href="#" data-toggle="remove" class="btn card-remove"><i class="ion-android-close"></i></a>
                              </div>
                           </div>
                           <div class="card-body pd-0 collapse show" id="collapse2">
                              <table class="table table-striped table-responsive-sm">
                                 <thead>
                                    <tr>
                                       <th>#</th>
                                       <th>İsim Soyisim</th>
                                       <th>Telefon No</th>
                                       <th>Tarih</th>
                                       <th>İşlemler</th>
                                    </tr>
                                 </thead>
                                 <tbody>
                        <?php
                        $sorgu = $dbh->prepare("SELECT * FROM arac_reservbilgial LIMIT 5");
                        $sorgu->execute();
                        while ($sonuc = $sorgu->fetch()) {
                        $id = $sonuc['id']; 
                        $adsoyad = $sonuc['adsoyad'];
                        $ceptelefon = $sonuc['ceptelefon'];
                        $created = $sonuc['created'];
                        $arac = $sonuc['arac'];
                        ?>
                                    <tr>
                                       <th scope="row"><?=$sonuc['id'];?></th>
                                       <td><?=$sonuc['adsoyad'];?></td>
                                       <td><?=$sonuc['ceptelefon'];?></td>
                                       <td><?=$sonuc['created'];?></td>
                                       <td>
                                      <button type="button" class="btn btn-outline-primary btn-icon mg-r-5" data-toggle="modal" data-target="#m_modal_<?=$sonuc['id'];?>"> <div><i class="fa fa-envelope-open-o"></i></div></button>  <a href="bilgial-sil.php?id=<?=$sonuc['id'];?>" class="btn btn-outline-danger btn-icon mg-r-5" data-toggle="tooltip" data-trigger="hover" data-placement="right" title="" data-original-title="Mesajı Siler"><div><i class="fa fa-minus-circle"></i></div></a>
                                       </td>
                                    </tr>
                                    <div class="modal" id="m_modal_<?=$sonuc['id'];?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel_<?=$sonuc['id'];?>" style="display: none;" aria-hidden="true">
                                 <div class="modal-dialog" role="document">
                                    <div class="modal-content">
                                       <div class="modal-header">
                                          <h5 class="modal-title" id="exampleModalLabel_<?=$sonuc['id'];?>"><b>#</b><?=$sonuc['id'];?>   Mesaj İçeriği ( <?=$sonuc['created'];?> )</h5>
                                          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                          <span aria-hidden="true"><i class="ion-ios-close-empty"></i></span>
                                          </button>
                                       </div>
                                       <div class="modal-body"> 
                                 
                                   
                                          <p><b>Ad Soyad;</b>  <?=$sonuc['adsoyad'];?> </p>
                                          <p><b>Cep Telefonu;</b>  <?=$sonuc['ceptelefon'];?></p>   
                           
                                          <p><b>Araç;</b> 
                                          
                                          <?
                                              $c = $dbh->prepare("SELECT * FROM proje where id = ".$sonuc["arac"]);
                                              $c->execute();
                                              $arac = $c->fetch();
                                              $baslikseo=seo( $arac['arac_baslik']); 
                                              ?>
                                             <a href="../ilan-<?=$baslikseo?>-i<?=$arac['id'];?>" target="_blank">
                                            <?=$arac["arac_baslik"]?></a>
                                          <?
                                          ?>  
                                       
                                       </p>
                                       </div>
                                       <div class="modal-footer">
                                          <button type="button" class="btn btn-secondary" data-dismiss="modal">Kapat</button>
                                       </div>
                                    </div>
                                 </div>
                              </div>
                                    <?php } ?>
                                 </tbody>
                              </table>
                           </div>
                        </div>
                     </div>

<div class="col-md-6 col-lg-6">
                        <div class="card mg-b-20">
                           <div class="card-header">
                              <h4 class="card-header-title">
                                 Kredi Al Talepleri
                              </h4>
                              <div class="card-header-btn">
                                 <a  href="#" data-toggle="collapse" class="btn card-collapse" data-target="#collapse112" aria-expanded="true"><i class="ion-ios-arrow-down"></i></a>
                                 <a href="#" data-toggle="refresh" class="btn card-refresh"><i class="ion-android-refresh"></i></a>
                                 <a href="#" data-toggle="expand" class="btn card-expand"><i class="ion-android-expand"></i></a>
                                 <a href="#" data-toggle="remove" class="btn card-remove"><i class="ion-android-close"></i></a>
                              </div>
                           </div>
                           <div class="card-body pd-0 collapse show" id="collapse112">
                              <table class="table table-striped table-responsive-sm">
                                 <thead>
                                    <tr>
                                       <th>#</th> 
                                       <th>Ad Soyad</th>
                                       <th>Cep Telefonu</th>  
                                       <th>Tarih</th>
                                       <th>İşlem</th>
                                    </tr>
                                 </thead>
                                 <tbody>
                                    <?php
                        $sorgu = $dbh->prepare("SELECT * FROM arac_reservkredial LIMIT 5");
                        $sorgu->execute();
                        while ($sonuc = $sorgu->fetch()) {
                        $id = $sonuc['id']; 
                        $tcno = $sonuc['tcno'];
                        $adsoyad = $sonuc['adsoyad'];
                        $ceptelefon = $sonuc['ceptelefon'];
                        $dogumyili = $sonuc['dogumyili'];
                        $pesinat = $sonuc['pesinat'];
                        $created = $sonuc['created'];
                        $arac = $sonuc['arac'];
                        ?>
                                    <tr>
                                       <th scope="row"><?=$sonuc['id'];?></th> 
                                       <td><?=$sonuc['adsoyad'];?></td>
                                       <td><?=$sonuc['ceptelefon'];?></td>
                                       <td><?=$sonuc['created'];?></td>
                                      
                                       <td>
                                          <button type="button" class="btn btn-outline-primary btn-icon mg-r-5" data-toggle="modal" data-target="#m_modal_<?=$sonuc['id'];?>"> <div><i class="fa fa-envelope-open-o"></i></div></button>  <a href="kredial-sil.php?id=<?=$sonuc['id'];?>" class="btn btn-outline-danger btn-icon mg-r-5" data-toggle="tooltip" data-trigger="hover" data-placement="right" title="" data-original-title="Mesajı Siler"><div><i class="fa fa-minus-circle"></i></div></a>
                                       </td>
                                        <div class="modal" id="m_modal_<?=$sonuc['id'];?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel_<?=$sonuc['id'];?>" style="display: none;" aria-hidden="true">
                                 <div class="modal-dialog" role="document">
                                    <div class="modal-content">
                                       <div class="modal-header">
                                          <h5 class="modal-title" id="exampleModalLabel_<?=$sonuc['id'];?>"><b>#</b><?=$sonuc['id'];?>   Mesaj İçeriği ( <?=$sonuc['created'];?> )</h5>
                                          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                          <span aria-hidden="true"><i class="ion-ios-close-empty"></i></span>
                                          </button>
                                       </div>
                                       <div class="modal-body"> 
                                 
                                   
                                          <p><b>Ad Soyad;</b>  <?=$sonuc['adsoyad'];?> </p>
                                          <p><b>Cep Telefonu:</b>  <?=$sonuc['ceptelefon'];?></p>   
                                          <p><b>T.C No:</b> <?=$sonuc['tcno'];?></p>
                                          <p><b>Peşinat Tutarı:</b> <?=$sonuc['pesinat'];?></p>
                           
                                          <p><b>Araç;</b> 
                                          
                                          <?
                                              $c = $dbh->prepare("SELECT * FROM proje where id = ".$sonuc["arac"]);
                                              $c->execute();
                                              $arac = $c->fetch();
                                              $baslikseo=seo( $arac['arac_baslik']); 
                                              ?>
                                            <a href="../ilan-<?=$baslikseo?>-i<?=$arac['id'];?>" target="_blank">
                                            <?=$arac["arac_baslik"]?></a>
                                          <?
                                          ?>  
                                       
                                       </p>
                                       </div>
                                       <div class="modal-footer">
                                          <button type="button" class="btn btn-secondary" data-dismiss="modal">Kapat</button>
                                       </div>
                                    </div>
                                 </div>
                              </div>
                                    </tr>
                                    <?php } ?>
                                 </tbody>
                              </table>
                           </div>
                        </div>
                     </div>

<div class="col-md-6 col-lg-6">
                        <div class="card mg-b-20">
                           <div class="card-header">
                              <h4 class="card-header-title">
                              Araçımı Satıyorum Talepleri
                              </h4>
                              <div class="card-header-btn">
                                 <a  href="#" data-toggle="collapse" class="btn card-collapse" data-target="#collapse1152" aria-expanded="true"><i class="ion-ios-arrow-down"></i></a>
                                 <a href="#" data-toggle="refresh" class="btn card-refresh"><i class="ion-android-refresh"></i></a>
                                 <a href="#" data-toggle="expand" class="btn card-expand"><i class="ion-android-expand"></i></a>
                                 <a href="#" data-toggle="remove" class="btn card-remove"><i class="ion-android-close"></i></a>
                              </div>
                           </div>
                           <div class="card-body pd-0 collapse show" id="collapse1152">
                              <table class="table table-striped table-responsive-sm">
                                 <thead>
                                    <tr>
                                       <th>#</th>
                                       <th>İsim Soyisim</th>
                                       <th>Telefon No</th>
                                       <th>Tarih</th>
                                       <th>İşlemler</th>
                                    </tr>
                                 </thead>
                                 <tbody>
                        <?php
                        $sorgu = $dbh->prepare("SELECT * FROM arac_satiyorum LIMIT 5");
                        $sorgu->execute();
                        while ($sonuc = $sorgu->fetch()) {
                        $id = $sonuc['id']; 
                        $sahibinden_ilan = $sonuc['sahibinden_ilan'];
                        $arac_marka = $sonuc['arac_marka'];
                        $arac_model = $sonuc['arac_model'];
                        $kasa_tipi = $sonuc['kasa_tipi'];
                        $arac_yil = $sonuc['arac_yil'];
                        $arac_km = $sonuc['arac_km'];
                        $arac_yakit = $sonuc['arac_yakit'];
                        $arac_vites = $sonuc['arac_vites'];
                        $arac_durum = $sonuc['arac_durum'];
                        $arac_motor = $sonuc['arac_motor'];
                        $arac_renk = $sonuc['arac_renk'];
                        $arac_garanti = $sonuc['arac_garanti'];
                        $arac_takas = $sonuc['arac_takas'];
                        $arac_plaka = $sonuc['arac_plaka'];
                        $arac_hasar = $sonuc['arac_hasar'];
                        $arac_aciklama = $sonuc['arac_aciklama'];
                        $isim_soyisim = $sonuc['isim_soyisim'];
                        $telefon = $sonuc['telefon'];
                        $sehir = $sonuc['sehir']; 
                        $fiyat = $sonuc['fiyat'];
                        $date = $sonuc['date'];
                        ?>
                                    <tr>
                                       <th scope="row"><?=$sonuc['id'];?></th>
                                       <td><?=$sonuc['isim_soyisim'];?></td>
                                       <td><?=$sonuc['telefon'];?></td>
                                       <td><?=$sonuc['date'];?></td>
                                       <td>
                                      <button type="button" class="btn btn-outline-primary btn-icon mg-r-5" data-toggle="modal" data-target="#m_modal_115<?=$sonuc['id'];?>"> <div><i class="fa fa-envelope-open-o"></i></div></button>  <a href="aracsatiyorum-sil.php?id=<?=$sonuc['id'];?>" class="btn btn-outline-danger btn-icon mg-r-5" data-toggle="tooltip" data-trigger="hover" data-placement="right" title="" data-original-title="Mesajı Siler"><div><i class="fa fa-minus-circle"></i></div></a>
                                       </td>
                                    </tr>
                                    <div class="modal" id="m_modal_115<?=$sonuc['id'];?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel_115<?=$sonuc['id'];?>" style="display: none;" aria-hidden="true">
                                 <div class="modal-dialog" role="document">
                                    <div class="modal-content">
                                       <div class="modal-header">
                                          <h5 class="modal-title" id="exampleModalLabel_115<?=$sonuc['id'];?>"><b>#</b><?=$sonuc['id'];?>   Mesaj İçeriği ( <?=$sonuc['date'];?> )</h5>
                                          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                          <span aria-hidden="true"><i class="ion-ios-close-empty"></i></span>
                                          </button>
                                       </div>
                                       <div class="modal-body"> 
                                          <p><b>İsim Soyisim:</b>  <?=$sonuc['isim_soyisim'];?> </p>
                                          <p><b>Telefon No:</b>  <?=$sonuc['telefon'];?> </p>
                                          <p><b>İl / İlçe:</b>  <?=$sonuc['sehir'];?> </p>
                                          <p><b>İstenilen Fiyat:</b>  <?=$sonuc['fiyat'];?> </p>
                                          <br>
                                          <p><b>Sahibinden İlan No:</b>  <?=$sonuc['sahibinden_ilan'];?> </p>
                                          <p><b>Araç Marka / Model / Renk / Kasa Tipi:</b>  <?=$sonuc['arac_marka'];?> / <?=$sonuc['arac_model'];?> / <?=$sonuc['arac_renk'];?> / <?=$sonuc['kasa_tipi'];?> </p>
                                          <p><b>Araç Yılı:</b>  <?=$sonuc['arac_yil'];?> </p>
                                          <p><b>Araç KM:</b>  <?=$sonuc['arac_km'];?> </p>
                                          <p><b>Araç Yakıt:</b>  <?=$sonuc['arac_yakit'];?> </p>
                                          <p><b>Araç Vitesi:</b>  <?=$sonuc['arac_vites'];?> </p>
                                          <p><b>Araç Durumu:</b>  <?=$sonuc['arac_durum'];?> </p>
                                          <p><b>Motor Gücü:</b>  <?=$sonuc['arac_motor'];?> </p>
                                          <p><b>Araç Garanti Durumu:</b>  <?=$sonuc['arac_garanti'];?> </p>
                                          <p><b>Takas Durumu:</b>  <?=$sonuc['arac_takas'];?> </p>
                                          <p><b>Araç Plakası:</b>  <?=$sonuc['arac_plaka'];?> </p>
                                          <p><b>Araç Hasar Durumu:</b>  <?=$sonuc['arac_hasar'];?> </p>
                                          <p><b>Cep Telefonu;</b>  <?=$sonuc['arac_marka'];?></p>   
                           
                                          <p><b>Açıklama;</b><br>

<p><?=$sonuc['arac_aciklama'];?></p> 
                                          
                                          
                                       </p>
                                       </div>
                                       <div class="modal-footer">
                                          <button type="button" class="btn btn-secondary" data-dismiss="modal">Kapat</button>
                                       </div>
                                    </div>
                                 </div>
                              </div>
                                    <?php } ?>
                                 </tbody>
                              </table>
                           </div>
                        </div>
                     </div>

<div class="col-md-6 col-lg-6">
                        <div class="card mg-b-20">
                           <div class="card-header">
                              <h4 class="card-header-title">
                                 İletişim Talepleri
                              </h4>
                              <div class="card-header-btn">
                                 <a  href="#" data-toggle="collapse" class="btn card-collapse" data-target="#collapse2" aria-expanded="true"><i class="ion-ios-arrow-down"></i></a>
                                 <a href="#" data-toggle="refresh" class="btn card-refresh"><i class="ion-android-refresh"></i></a>
                                 <a href="#" data-toggle="expand" class="btn card-expand"><i class="ion-android-expand"></i></a>
                                 <a href="#" data-toggle="remove" class="btn card-remove"><i class="ion-android-close"></i></a>
                              </div>
                           </div>
                           <div class="card-body pd-0 collapse show" id="collapse2">
                             <table class="table table-striped table-responsive-sm">
                                 <thead>
                                    <tr>
                                       <th>#</th>
                                       <th>İsim Soyisim</th>
                                       <th>Telefon No</th> 
                                       <th>Tarih</th>
                                       <th>İşlem</th>
                                    </tr>
                                 </thead>
                                 <tbody>
                                    <?php
                        $sorgu = $dbh->prepare("SELECT * FROM bize_ulasin LIMIT 5");
                        $sorgu->execute();
                        while ($sonuc = $sorgu->fetch()) {
                        $id = $sonuc['id'];
                        $isim_soyisim = $sonuc['isim_soyisim'];
                        $telefon = $sonuc['telefon']; 
                        $aciklama = $sonuc['aciklama'];
                        $tarih = $sonuc['tarih'];
                        ?>
                                    <tr>
                                       <th scope="row"><?=$sonuc['id'];?></th>
                                       <td><?=$sonuc['isim_soyisim'];?></td>
                                       <td><?=$sonuc['telefon'];?></td> 
                                       <td><?=$sonuc['tarih'];?></td>
                                       <td>
<button type="button" class="btn btn-outline-primary btn-icon mg-r-5" data-toggle="modal" data-target="#m_modal_<?=$sonuc['id'];?>"> <div><i class="fa fa-envelope-open-o"></i></div></button>  <a href="iletisim-sil.php?id=<?=$sonuc['id'];?>" class="btn btn-outline-danger btn-icon mg-r-5" data-toggle="tooltip" data-trigger="hover" data-placement="right" title="" data-original-title="Mesajı Siler"><div><i class="fa fa-minus-circle"></i></div></a>
                                       </td>
                                        <div class="modal" id="m_modal_<?=$sonuc['id'];?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel_<?=$sonuc['id'];?>" style="display: none;" aria-hidden="true">
                                 <div class="modal-dialog" role="document">
                                    <div class="modal-content">
                                       <div class="modal-header">
                                          <h5 class="modal-title" id="exampleModalLabel_<?=$sonuc['id'];?>">Mesaj İçeriği ( <?=$sonuc['tarih'];?> )</h5>
                                          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                          <span aria-hidden="true"><i class="ion-ios-close-empty"></i></span>
                                          </button>
                                       </div>
                                     
                                     <div class="modal-body"> 
                                        
                                        <p><b>İsim Soyisim:</b> <?=$sonuc['isim_soyisim'];?></p>
                                        <p><b>Telefon:</b> <?=$sonuc['telefon'];?></p>
                                        <p><b>Mail:</b> <?=$sonuc['mail'];?></p>
                                        <br>Açıklama;<br>
                                        <p><b><?=$sonuc['aciklama'];?></b>
                                         
                                       </p>
                                       </div>
                                       <div class="modal-footer">
                                          <button type="button" class="btn btn-secondary" data-dismiss="modal">Kapat</button>
                                       </div>
                                    </div>
                                 </div>
                              </div>
                                    </tr>
                                    <?php } ?>
                                 </tbody>
                              </table>
                           </div>
                        </div>
                     </div>
                       
                     
                    
</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)