PHP Dosya Yöneticisi

<?php

if (isset($_GET['temizle'])) {
        $id = temizle($_GET['temizle']);
        $sayfasil = $ozy->prepare("delete from iletisim where id='$id'");
        $sayfasil->execute(array($id));
        if ($sayfasil) {
            echo '<script type="text/javascript">$(document).ready(function(){toastr["success"]("Başarıyla veri silindi.", "Başarılı");});</script>';
        }
    }

?>
<div class="container-fluid">
	<div class="row page-title">
		<div class="col-sm-6">
			<h3>Gelen Kutusu</h3>
		</div>
		<div class="col-sm-6">
			<nav>
				<ol class="breadcrumb justify-content-sm-end align-items-center">
					<li class="breadcrumb-item">
					    <a href="/boss/anasayfa.php">
							<svg class="svg-color">
								<use href="datas/svg/iconly-sprite.svg#Home"></use>
							</svg>
						</a>
					</li>
					<li class="breadcrumb-item active">Gelen Kutusu</li>
				</ol>
			</nav>
		</div>
	</div>
</div>
<div class="container-fluid ecommerce-dashboard">
	<div class="row">
		<div class="col-12 col-md-4">
		    <div class="card m-b-30">
                <div class="card-body table-responsive">
                    <a href="eposta-gonder" class="btn btn-danger rounded btn-custom btn-block waves-effect waves-light" style="width: 100%;">Toplu Eposta Gönder</a>
                    <br>
                    <div class="mail-list m-t-10" style="display: flex;">
                        <a href="gelen-kutusu" style="width: 33%; text-align: center;">
                            <div style="margin: 5px; background: black; color: white; border-radius: 5px; padding: 5px;">
                                <span class="float-right">
        						    <?php 
        						        $gelen = $ozy->prepare("SELECT COUNT(*) FROM iletisim");
                                        $gelen->execute();
                                        $gelenmesajsayisi = $gelen->fetchColumn(); echo $gelenmesajsayisi;
                                    ?>
        						</span>
    						    <i class="ti-archive mr-2"></i> Gelen
                            </div>
						</a>
                        <a  href="gelen-kutusu?s=1" style="width: 34%; text-align: center;">
                            <div style="margin: 5px; background: black; color: white; border-radius: 5px; padding: 5px;">
                                <span class="float-right">
            						<?php 
            						    $giden = $ozy->prepare("SELECT COUNT(*) FROM iletisim  where giden='1'");
                                        $giden->execute();
                                        $gidenmesajsayisi = $giden->fetchColumn(); echo $gidenmesajsayisi;
                                    ?>
    						    </span>
    						    <i class="ti-location-arrow mr-2"></i> Cevaplanan
                            </div>
						</a>
						<a href="toplu-eposta" class="active" style="width: 33%; text-align: center;">
						    <div style="margin: 5px; background: black; color: white; border-radius: 5px; padding: 5px;">
						        <span class="float-right">
            						<?php 
            						    $toplu = $ozy->prepare("SELECT COUNT(*) FROM tiletisim");
                                        $toplu->execute();
                                        $toplueposta = $toplu->fetchColumn(); echo $toplueposta;
                                    ?>
        						</span>
    						    <i class="ti-pencil  mr-2"></i>Toplu Eposta 
						    </div>
						</a>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-12 col-md-8">
		    <div class="card m-b-30">
                <div class="card-body table-responsive">
                    <div class="email-right-aside">
                    	<div class="card email-body email-list">
            				<div class="mail-body-wrapper">
            					<ul id="paginated-list" data-current-page="1" aria-live="polite">
            						<?php

$page = intval(@$_GET['page']);
                                        if (!$page) {
                                            $page = 1;
                                        }
                                        
                                        $bak = $ozy->prepare("select * from iletisim");
                                        $bak->execute([]);
                                        $toplam = $bak->rowCount();
                                        $limit = 20;
                                        $goster = $page * $limit - $limit;
                                        $sayfasayisi = ceil($toplam / $limit);
                                        $forlimit = 200;
                                        
                                        if (temizle($_GET["s"] == '1')) {
                                            $pr = $ozy->query("select * from iletisim where giden='1' order by id DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                        } elseif (temizle($_GET["s"] == '2')) {
                                            $pr = $ozy->query("select * from iletisim where durum='0' order by id DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                        } else {
                                            $pr = $ozy->query("select * from iletisim  order by id DESC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
                                        }
                                        
                                        $__URUN__ = false;
                                        foreach ($pr as $iletisim) {
                                            $__URUN__ = true;
                                    ?>
                                        <a href="mesaj-duzenle/<?php echo $iletisim['id']; ?>">
                    						<li class="inbox-data">
                						        <div class="inbox-user">
                    								<div class="rounded-border">
                    								    <img class="img-fluid" src="datas/images/user/1.jpg" alt="user">
                    								</div>
                    								<p><?php echo $iletisim['isim']; ?></p>
                    							</div>
                    							<div class="inbox-message">
                    								<div class="email-data"><span>Konu: <?php echo $iletisim['konu']; ?><span><?php echo strip_tags(mb_substr($iletisim['mesaj'],0,100));?>...</span></span></div>
                    								<div class="email-timing"><span><?php echo $iletisim['tarih']; ?></span></div>
                    								<div class="email-options">
                    								    <div class="btn-group" role="group">
                        								    <a href="tel:<?php echo $iletisim['telefon'];  ?>" target="_blank" onclick="return confirm('Telefon ile yanıt vermek istiyor musun ?')" class="btn btn-sm btn-danger" style="border: none;background: #4192e9;" data-toggle="tooltip" data-original-title="Telefon ile Yanıtla"><img style="width: 16px;height: 16px;" src="assets/images/tel.png"></img></a>									 
                        									<a href="https://api.whatsapp.com/send?phone=+9<?php echo $iletisim['telefon'];  ?>&amp;text=Merhaba iyi günler, <?php echo $ayar['siteadi'];?> olarak websitemizin iletişim formundan göndermiş olduğunuz mesaja istinaden sizi rahatsız ediyorum." target="_blank" onclick="return confirm('WhatsApp ile yanıt vermek istiyor musun  ?')" class="btn btn-sm btn-danger" style="border: #2ab200;background: #2ab200;" data-toggle="tooltip" data-original-title="WhatsApp ile Yanıtla"><img style="width: 16px;height: 16px;" src="assets/images/whatsap.jpg"></img></a>									 
                                                            <a href="mesaj-duzenle/<?php echo $iletisim['id']?>" class="btn btn-sm btn-success" data-toggle="tooltip" data-original-title="Düzenle"><i class="fa fa-edit" aria-hidden="true" style="color:white;"></i></a>	
                        									<a href="gelen-kutusu?temizle=<?php echo $iletisim['id'];  ?>" onclick="return confirm('Silmek istediğinize emin misiniz ?')" class="btn btn-sm btn-danger" data-toggle="tooltip" data-original-title="Sil"><i style="color:white;" class="fas fa-trash" aria-hidden="true"></i></a>
                    								    </div>
                    								</div>
                    							</div>
                    						</li>
                    					</a>
            						<?php }
                                        if (!$__URUN__){
                                            echo "Henüz gelen bir mesaj malesef bulunamadı";
                                        }
                                    ?>
            					</ul>
            				</div>
            				<div class="mail-pagination">
            				    <?php $geri = $_GET['page']-1;?>
            					<a class="pagination-button <?php echo $_GET['pages'] == '1' ? 'disabled' : null; ?>" id="prev-button" href="gelen-kutusu?s=<?php echo $_GET['s'];?>&page=<?php echo $geri;?>">&lt;</a>
            					<div class="pagination-index" id="pagination-numbers">
            					    <?php
                                        for ($i= $sayfa - $forlimit ; $i < $sayfa + $forlimit + 1 ; $i++) {
                                            if ($i>0 and $i<=$sayfasayisi) {
                                                if ($i == $sayfa) {
                                                    echo "<a class='pagination-number active' aria-current='page'>".$i."</a>";        
                                                }else{
                                                    echo "<a class='pagination-number' href='gelen-kutusu?s=".$_GET['s']."&page=".$i."'>".$i."</a>";
                                                }
                                            }
                                        }
                                    ?>
            					</div>
            					<?php $ileri = 1+$_GET['page'];?>
            					<a class="pagination-button" id="next-button" href="gelen-kutusu?s=<?php echo $_GET['s'];?>&page=<?php echo $ileri;?>">&gt;</a>
            				</div>
                    	</div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

İptal

📁 PHP Dosya Yöneticisi

📝 gelenkutusu.php

📝 gelenkutusu.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)