PHP Dosya Yöneticisi

<?php
include ('config.php');
include ('system/inc/sitedata.php');

if (!isset($_SESSION['login'])){
echo " <meta http-equiv='refresh' content='1;URL=index.php'> ";
exit();
}

?>
<!DOCTYPE html>
<html class="loading" lang="en" data-textdirection="ltr">

<?php include ('system/inc/header.php'); ?>

<div class="app-content content ">
        <div class="content-overlay"></div>
        <div class="header-navbar-shadow"></div>
        <div class="content-wrapper container-xxl p-0">
            <div class="content-header row">
            </div>
            <div class="content-body">
                
                <section id="dashboard-ecommerce">
                    <div class="row match-height">
					<?php 
					$queryVeria = mysqli_query($connect, "SELECT * FROM duyurular");
					if(mysqli_affected_rows($connect)) 
					{ 
					$querySonKurum = mysqli_query($connect, "SELECT * FROM duyurular ORDER BY id DESC LIMIT 1");
					$fetchSonKurum = mysqli_fetch_array($querySonKurum);
					$duyuru = $fetchSonKurum['duyuru'];
					
					
					echo '
					<div style="display:none">
							<audio controls autoplay>
							  <source src="msc.ogg" type="audio/ogg">
							  <source src="msc.mp3" type="audio/mpeg">
							  Your browser does not support the audio element.
							</audio>
					</div>
					';
					?>
					<div class="col-md-12">
					<div class="alert alert-primary">
					<marquee behavior=alternate><strong>GENEL DUYURU : </strong> <?=$duyuru;?> </marquee>
					  
					</div>
					</div>
					
					<?php  } ?>
					
					
				
					
				
					
					
                        
                        <div class="col-xl-4 col-md-6 col-12">
                            <div class="card card-congratulation-medal">
                                <div class="card-body">
                                    <h5 style="text-transform:uppercase">Hey Admin,<br> Hoşgeldin!</h5>
                                    <p class="card-text font-small-3"><?=$site_name;?> de Keyifli<br> Vakitler Geçirmeniz <br>Dileğiyle!</p>
                                   
                                   
                                    <img src="system/theme/app-assets/images/illustration/badge.svg" class="congratulation-medal" alt="Medal Pic" />
                                </div>
                            </div>
                        </div>

<div class="col-xl-8 col-md-6 col-12">
                            <div class="card card-statistics">
                                <div class="card-header">
                                    <h4 class="card-title">Detaylar</h4>
                                    <div class="d-flex align-items-center">
                                        <p class="card-text font-small-2 mr-25 mb-0">Günceldir.</p>
                                    </div>
                                </div>
                                <div class="card-body statistics-body">
                                    <div class="row">
                                        <div class="col-xl-4 col-sm-6 col-12 mb-2 mb-xl-0">
                                            <div class="media">
                                                <div class="avatar bg-light-primary mr-2">
                                                    <div class="avatar-content">
                                                        <i class="fas fa-users"></i>
                                                    </div>
                                                </div>
                                                <div class="media-body my-auto">
												<?php
												$sayTopTamUye = mysqli_query($connect, "SELECT * FROM data_users");
												$yazdirTopTamUye = mysqli_num_rows ($sayTopTamUye);
												
												//BEKLEMEDE
												$sayTopTamUyebEK = mysqli_query($connect, "SELECT * FROM data_users WHERE aktivasyondurum = 0");
												$yazdirTopTamUyebEK = mysqli_num_rows ($sayTopTamUyebEK);
												//AKTİF
												
												$sayTopTamUyeOn = mysqli_query($connect, "SELECT * FROM data_users WHERE aktivasyondurum = 1");
												$yazdirTopTamUyeOn = mysqli_num_rows ($sayTopTamUyeOn);																																				$sayTopTamUyeOnErkek = mysqli_query($connect, "SELECT * FROM data_users WHERE cinsiyet = 'Erkek'");												$yazdirTopTamUyeOnErkek = mysqli_num_rows ($sayTopTamUyeOnErkek);																								$sayTopTamUyeOnKadn = mysqli_query($connect, "SELECT * FROM data_users WHERE cinsiyet = 'Kadın'");												$yazdirTopTamUyeOnKadn = mysqli_num_rows ($sayTopTamUyeOnKadn);
												?>
                                                    <p class="card-text font-small-3 mb-0 text-primary"> Toplam Üye : <?=$yazdirTopTamUye;?></p>
													<p class="card-text font-small-3 mb-0 text-success"> Aktive Üye : <?=$yazdirTopTamUyeOn;?></p>
													<p class="card-text font-small-3 mb-0 text-danger"> Deaktif Üye : <?=$yazdirTopTamUyebEK;?></p>													<p class="card-text font-small-3 mb-0 text-warning"> Kadın Üye : <?=$yazdirTopTamUyeOnKadn;?></p>													<p class="card-text font-small-3 mb-0 text-secondary"> Erkek Üye : <?=$yazdirTopTamUyeOnErkek;?></p>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-xl-4 col-sm-6 col-12 mb-2 mb-xl-0">
                                            <div class="media">
                                                <div class="avatar bg-light-info mr-2">
                                                    <div class="avatar-content">
                                                        <i class="fas fa-thumbs-up "></i>
                                                    </div>
                                                </div>
                                                <div class="media-body my-auto">
														<?php
														$sayTopTamCek = mysqli_query($connect, "SELECT * FROM cekim WHERE durum = 0");
														$yazdirTopTamCek = mysqli_num_rows ($sayTopTamCek);
														
														//BEKLEMEDE
														$sayTopTamCekbEK = mysqli_query($connect, "SELECT * FROM cekim WHERE durum = 1");
														$yazdirTopTamCekbEK = mysqli_num_rows ($sayTopTamUyebEK);
														//AKTİF
														
														$sayTopTamCekOn = mysqli_query($connect, "SELECT * FROM cekim WHERE durum = 2");
														$yazdirTopTamCekOn = mysqli_num_rows ($sayTopTamUyeOn);
														?>
                                                    <p class="card-text font-small-3 mb-0 text-primary"> Bek. Çekim : <?=$yazdirTopTamCek;?></p>
													<p class="card-text font-small-3 mb-0 text-success"> Onay Çekim : <?=$yazdirTopTamCekbEK;?></p>
													<p class="card-text font-small-3 mb-0 text-danger"> Red Çekim : <?=$yazdirTopTamCekOn;?></p>
                                                </div>
                                            </div>
                                        </div>
										   <div class="col-xl-4 col-sm-6 col-12 mb-2 mb-xl-0">
                                            <div class="media">
                                                <div class="avatar bg-light-success mr-2">
                                                    <div class="avatar-content">
                                                       <i class="far fa-clock"></i>
                                                    </div>
                                                </div>
                                                <div class="media-body my-auto">
												<?php
														$sayTopTamYat = mysqli_query($connect, "SELECT * FROM yatirim WHERE durum = 0");
														$yazdirTopTamYat = mysqli_num_rows ($sayTopTamYat);
														
														//BEKLEMEDE
														$sayTopTamYatbEK = mysqli_query($connect, "SELECT * FROM yatirim WHERE durum = 1");
														$yazdirTopTamYatbEK = mysqli_num_rows ($sayTopTamYatbEK);
														//AKTİF
														
														$sayTopTamYatOn = mysqli_query($connect, "SELECT * FROM yatirim WHERE durum = 2");
														$yazdirTopTamYatOn = mysqli_num_rows ($sayTopTamYatOn);
														?>
                                                    <p class="card-text font-small-3 mb-0 text-primary"> Bek. Yatırım : <?=$yazdirTopTamYat;?></p>
													<p class="card-text font-small-3 mb-0 text-success"> Onay Yatırım : <?=$yazdirTopTamYatbEK;?></p>
													<p class="card-text font-small-3 mb-0 text-danger"> Red Yatırım : <?=$yazdirTopTamYatOn;?></p>
                                                </div>
                                            </div>
                                        </div>
										
										 <div class="col-xl-4 col-sm-6 col-12 mb-2 mb-xl-0"><hr>
                                            <div class="media">
                                                <div class="avatar bg-light-success mr-2">
                                                    <div class="avatar-content">
                                                       <i class="far fa-clock"></i>
                                                    </div>
                                                </div>
                                                <div class="media-body my-auto">
												<?php
														$sayTopTamGor = mysqli_query($connect, "SELECT * FROM yapilangorevler WHERE durum = 0");
														$yazdirTopTamGor = mysqli_num_rows ($sayTopTamYat);
														
														//BEKLEMEDE
														$sayTopTamGorbEK = mysqli_query($connect, "SELECT * FROM yapilangorevler WHERE durum = 1");
														$yazdirTopTamGorbEK = mysqli_num_rows ($sayTopTamYatbEK);
														//AKTİF
														
														$sayTopTamGorOn = mysqli_query($connect, "SELECT * FROM yapilangorevler WHERE durum = 2");
														$yazdirTopTamGorOn = mysqli_num_rows ($sayTopTamYatOn);
														?>
                                                     <p class="card-text font-small-3 mb-0 text-primary"> Bek. Görv : <?=$yazdirTopTamGor;?></p>
													<p class="card-text font-small-3 mb-0 text-success"> Onay Görv : <?=$yazdirTopTamGorbEK;?></p>
													<p class="card-text font-small-3 mb-0 text-danger"> Red Görv : <?=$yazdirTopTamGorOn;?></p>
                                                </div>
                                            </div>
                                        </div>
																														 <div class="col-xl-4 col-sm-6 col-12 mb-2 mb-xl-0"><hr>                                            <div class="media">                                                <div class="avatar bg-light-success mr-2">                                                    <div class="avatar-content">                                                       <i class="far fa-clock"></i>                                                    </div>                                                </div>                                                <div class="media-body my-auto">												<?php														$sayTopTamGorDest = mysqli_query($connect, "SELECT * FROM destek");														$yazdirTopTamGorDest = mysqli_num_rows ($sayTopTamGorDest);																												//BEKLEMEDE														$sayTopTamGorDest2 = mysqli_query($connect, "SELECT * FROM destek WHERE cevap = ''");														$yazdirTopTamGorDest2 = mysqli_num_rows ($sayTopTamGorDest2);														//AKTİF																												$sayTopTamGorDest3 = mysqli_query($connect, "SELECT * FROM destek WHERE cevap <> ''");														$yazdirTopTamGorDest3 = mysqli_num_rows ($sayTopTamGorDest3);														?>                                                     <p class="card-text font-small-3 mb-0 text-primary"> Top. Destk : <?=$yazdirTopTamGorDest;?></p>													<p class="card-text font-small-3 mb-0 text-success"> Bekl. Destk : <?=$yazdirTopTamGorDest2;?></p>													<p class="card-text font-small-3 mb-0 text-danger"> Tamam. Destk : <?=$yazdirTopTamGorDest3;?></p>                                                </div>                                            </div>                                        </div>
                                      <div class="col-xl-4 col-sm-6 col-12 mb-2 mb-xl-0"><hr>                                            <div class="media">                                                <div class="avatar bg-light-success mr-2">                                                    <div class="avatar-content">                                                       <i class="far fa-clock"></i>                                                    </div>                                                </div>                                                <div class="media-body my-auto">												<?php														$sayTopTamGorKatg = mysqli_query($connect, "SELECT * FROM kategoriler");														$yazdirTopTamGorKatg = mysqli_num_rows ($sayTopTamGorKatg);																												//BEKLEMEDE														$sayTopTamGorKatgpas = mysqli_query($connect, "SELECT * FROM kategoriler WHERE durum = 0");														$yazdirTopTamGorKatgpas = mysqli_num_rows ($sayTopTamGorKatgpas);														//AKTİF																												$sayTopTamGorKatgak = mysqli_query($connect, "SELECT * FROM kategoriler WHERE durum = 1");														$yazdirTopTamGorKatgak = mysqli_num_rows ($sayTopTamGorKatgak);														?>                                                     <p class="card-text font-small-3 mb-0 text-primary"> Top. Katego. : <?=$yazdirTopTamGorKatg;?></p>													<p class="card-text font-small-3 mb-0 text-success"> Aktif Katego : <?=$yazdirTopTamGorKatgak;?></p>													<p class="card-text font-small-3 mb-0 text-danger"> Pasif Katego : <?=$yazdirTopTamGorKatgpas;?></p>                                                </div>                                            </div>                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        
                    </div>

<div class="row match-height">
                        
                        <div class="col-lg-12 col-12">
                            <div class="card card-company-table">
                                <div class="card-body p-0">
                                    <div class="table-responsive">
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th>#</th>
                                                    <th>Duyuru</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                
												
												
												     
                  <?php
											$query_r = mysqli_query($connect, "SELECT * FROM duyurular LIMIT 5");
											if (mysqli_affected_rows($connect)){
												$i = 1;
												while ($fetch_r = mysqli_fetch_array($query_r)){
												
										?>
                                           <tr>
												
											
                                                 <td>
                                                        <div class="d-flex align-items-center">
                                                            <div class="avatar rounded">
                                                                <div class="avatar-content">
                                                                    <img src="system/theme/app-assets/images/icons/speaker.svg" alt="Toolbar svg" />
                                                                </div>
                                                            </div>
                                                            
                                                        </div>
                                                    </td>

<td class="text-danger" >
											<?php echo $fetch_r['duyuru']; ?>
											</td>
											  </tr>
										<?php
												$i++;}
											}else{
										?>
											 <tr class="active">
											 <td>Henüz</td>
                                                <th scope="row">Duyuru</th>
                                                <td>Yok</td>
                                              
                                            </tr>
										<?php } ?>
                                                   
													
                                                    
                                                   
                                              
                                               
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>

</div>
                </section>

</div>
        </div>
    </div>
<?php include ('system/inc/footer.php'); ?>
</body>

</html>

İptal

📁 PHP Dosya Yöneticisi

📝 home.php

📝 home.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)