PHP Dosya Yöneticisi

<?php include("header.php");
if($user["yetki"]!="1" && $user["yetki"]!="2"){
	header("Location: index.php");
	exit;
}
if(@$_POST["id"]!=Null && @$_POST["cevap"]!=Null){
				
  $id=htmlentities($_POST["id"], ENT_QUOTES, "UTF-8");
  $cevap=htmlentities($_POST["cevap"], ENT_QUOTES, "UTF-8");
				
                  $destekcek=mysqli_query($baglanti,"select * from iletisim where id='$id'"); 
                $satir=mysqli_fetch_array($destekcek);
				$email=$satir["mail"];
				
        mysqli_query($baglanti,"UPDATE iletisim SET cevap='".$cevap."' WHERE id = '$id'");
							require("../config/mail/class.phpmailer.php");

$mail = new PHPMailer();

$mail->IsSMTP();

$mail->SMTPDebug = 1;

$mail->SMTPAuth = true;

$mail->SMTPSecure = 'ssl';

$mail->Host = $ayar["mail_host"];

$mail->Port = 465;

$mail->IsHTML(true);

$mail->SetLanguage("tr", "phpmailer/language");

$mail->CharSet  ="utf-8";

$mail->Username = $ayar["mail_user"];

$mail->Password = $ayar["mail_sifre"];

$mail->SetFrom($ayar["mail_email"], $ayar["ad"]);

$mail->AddAddress($email);

$mail->Subject = "Talebiniz Yanıtlandı";

$mail->Body = '<table class="body"

style="Margin:0;border-collapse:collapse;border-color:transparent;border-spacing:0;color:#0a0a0a;font-family:Open Sans,sans-serif;font-size:16px;font-weight:400;height:100%;line-height:1.3;margin:0;padding:0;text-align:left;vertical-align:top;width:100%">

<td class="center" align="center" valign="top"

style="-moz-hyphens:auto;-webkit-hyphens:auto;Margin:0;border-collapse:collapse!important;color:#0a0a0a;font-family:Open Sans,sans-serif;font-size:16px;font-weight:400;hyphens:auto;line-height:1.3;margin:0;padding:0;text-align:left;vertical-align:top;word-wrap:break-word">

<table class="spacer float-center"

style="Margin:0 auto;border-collapse:collapse;border-color:transparent;border-spacing:0;float:none;margin:0 auto;padding:0;text-align:center;vertical-align:top;width:100%">

<tbody>

<td height="20"

style="-moz-hyphens:auto;-webkit-hyphens:auto;Margin:0;border-collapse:collapse!important;color:#0a0a0a;font-family:Open Sans,sans-serif;font-size:40px;font-weight:400;hyphens:auto;line-height:40px;margin:0;mso-line-height-rule:exactly;padding:0;text-align:left;vertical-align:top;word-wrap:break-word">

</td>

</tr>

</tbody>

</table>

<table cellspacing="0" cellpadding="0" border="0" align="center" class="container container-radius body-drip float-center"

style="display:table;border-spacing:60px 0;border-collapse:separate;width:100%;max-width:800px;background-color: #336699;">

<tbody>

<tr>

<tbody>

<td height="50px"

style="-moz-hyphens:auto;-webkit-hyphens:auto;Margin:0;border-collapse:collapse!important;color:#0a0a0a;font-family:Open Sans,sans-serif;font-size:32px;font-weight:400;hyphens:auto;line-height:32px;margin:0;mso-line-height-rule:exactly;padding:0;text-align:left;vertical-align:top;word-wrap:break-word">

</td>

</tr>

<tr>

Talebiniz Yanıtlandı

</td>

</tr>

<td height="60px"

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

<table cellspacing="0" cellpadding="0" border="0" align="center" class="container body-drip float-center"

style="Margin:0 auto;background:#f6f6f6;border-collapse:collapse;border-color:transparent;border-spacing:0;float:none;margin:0 auto;padding:0;text-align:center;vertical-align:top;width:800px;max-width:800px">

<tbody>

<table class="spacer float-center"

style="Margin:0 auto;background:#f6f6f6;border-collapse:collapse;border-color:transparent;border-spacing:0;float:none;margin:0 auto;padding:0;text-align:center;vertical-align:top;width:100%">

<tbody>

<td height="50px"

</td>

</tr>

</tbody>

</table>

<table class="container-radius"

style="border-top-width:0;border-top-color:#efefef;border-left-width:0;border-right-width:0;border-bottom-width:1px;border-bottom-color:#efefef;border-right-color:#efefef;border-left-color:#efefef;border-style:solid; border-bottom-left-radius:3px;border-bottom-right-radius:3px;display:table;padding-bottom:50px;border-spacing:60px 0;border-collapse:separate;width:100%;background:#f6f6f6;max-width:800px;">

<tbody>

<tr>

<td>

<table class="row"

style="border-collapse:collapse;border-color:transparent;border-spacing:0;display:table;padding:0;position:relative;text-align:left;vertical-align:top;width:100%">

<tbody>

</tbody>

</table>

Konu: <strong>'.$satir["baslik"].'</strong><br>
										
										Sorunuz: <strong>'.$satir["mesaj"].'</strong><br>
                                       
										Yetkili Yanıtı: <strong>'.$cevap.'</strong><br>

---<br>
										Bize Ulaştığınız İçin Teşekkür Ederiz

</td>

</tr>

</tbody>

</table>

</td>

</tr>

</tbody>

</table>

<hr align="center" class="float-center spacer container"

style="background:#efefef;border:none;color:#efefef;height:1px;margin-bottom:0;margin-top:0;width: 800px;">

<table class="spacer float-center"

style="Margin:0 auto;border-collapse:collapse;border-color:transparent;border-spacing:0;float:none;margin:0 auto;padding:0;text-align:center;vertical-align:top;width:100%">

<tbody>

<td height="50"

</td>

</tr>

</tbody>

</table>

</center>

</td>

</tr>

</table>

if(!$mail->Send()){

echo "Mailer Error: ".$mail->ErrorInfo;

}
header("Location: ?is=yanit");
exit;
}
 ?>
      <div class="page-content-wrapper">
        <div class="page-content-wrapper-inner">
          <div class="content-viewport">
            <div class="row">
              <div class="col-12 py-5">
                <h4>İletişim İstekleri</h4>
			
              </div>
            </div>
            <div class="row">
			  <div class="col-md-12 equel-grid">
                <div class="grid">
                  <p class="grid-header">İletişim Listesi</p>
                  <div class="grid-body">
             
                  <div class="table-responsive">
				  <?php 
				  if(@$_GET["is"]=="yanit"){
					echo '<div class="alert alert-success m-2">Yanıt başarıyla gönderilmiştir.</div>';  
				  }
				  ?>
                    <table class="table table-hover table-sm">
                      <thead>
                        <tr class="solid-header">
                        <th>Ad</th>
                        <th>Tarih</th>
                        <th>Konu</th>
                        <th>Mail</th>
                        <th>Durum</th>
                        <th>İşlem</th>
                        </tr>
                      </thead>
                      <tbody>
					     <?php
 $say=mysqli_query($baglanti,"select * from iletisim ORDER BY id DESC"); 
				  $satir_sayisi=mysqli_num_rows($say);
				      if(isset($_GET['sayfa']) && is_numeric($_GET['sayfa'])){
        $sayfa = $_GET['sayfa'];
        if($sayfa < 0){
            $sayfa=1;
        }
    }else{
        $sayfa = 1;
    }
    $limit  = 50;
    $ss     = ceil( $satir_sayisi / $limit );
    $sayfa  = ( $sayfa > $ss ? 1 : $sayfa );
    $goster = ( $sayfa * $limit ) - $limit;
                  $destekcek=mysqli_query($baglanti,"select * from iletisim ORDER BY id DESC LIMIT $goster, $limit"); 
                
                                                while($satir=mysqli_fetch_array($destekcek))
                                                {
                                                   
                                                        echo '
                          <tr>
                <td>'.$satir['ad'].'</td>
                <td>'.$satir['tarih'].'</td>
             <td>'.$satir['baslik'].'</td>
             <td>'.$satir['mail'].'</td>
             <td>'; if($satir["cevap"]==Null){ echo '<span class="badge badge-danger">Okunmadı</span>';} else{ echo '<span class="badge badge-success">Yanıtlandı</span>';} echo '</td>
             <td><button type="button" class="btn btn-info btn-sm" data-toggle="modal" data-target="#myModal'.$satir['id'].'">Görüntüle</button></td>
              </tr><div id="myModal'.$satir['id'].'" class="modal fade" role="dialog">
  <div class="modal-dialog modal-lg">

<div class="modal-content">
      <div class="modal-header">
        <h4 class="modal-title">İletişim Detayları</h4>
        <button type="button" class="close" data-dismiss="modal">&times;</button>
      </div>
      <div class="modal-body m-3">
     <form method="post" action="">
	 <input type="hidden" value="'.$satir['id'].'" name="id">
	 <div class="alert alert-info">Yanıt gönderdiğiniz anda yanıtınız mail ile gönderilecektir.</div>
                        <div class="form-group">
                          <label for="inputEmail1">Ad Soyad</label>
                          <input type="text" name="ad" value="'.$satir['ad'].'" class="form-control" readonly>
                        </div>
                        <div class="form-group">
                          <label for="inputEmail1">Mail Adresi</label>
                          <input type="email" name="mail" value="'.$satir['mail'].'" class="form-control" readonly>
                        </div>
                        <div class="form-group">
                          <label for="inputEmail1">Mesaj Tarihi</label>
                          <input type="text" name="tarih" value="'.$satir['tarih'].'" class="form-control" readonly>
                        </div>
                        <div class="form-group">
                          <label for="inputEmail1">Konu</label>
                          <input type="text" name="baslik" value="'.$satir['baslik'].'" class="form-control" readonly>
                        </div>
                        <div class="form-group">
                          <label for="inputEmail1">Mesaj İçeriği</label>
                          <textarea type="text" name="mesaj" class="form-control" readonly>'.$satir['mesaj'].'</textarea>
                        </div>
                        <div class="form-group">
                          <label for="inputEmail1">Cevap</label>
                          <textarea type="text" name="cevap" class="form-control" >'.$satir['cevap'].'</textarea>
                        </div>
                        <button type="submit" class="btn btn-sm btn-primary">Yanıtla</button>
                      </form>
      </div>
    </div>

</div>
</div>';
                                                }
             ?>
                      
                      </tbody>
                    </table>
                  </div> 
              <div class="card-footer clearfix">
                <ul class="pagination pagination-sm m-0 float-right">
                 	   <?php 
                                for( $i = $sayfa - 1; $i < $sayfa + 2; $i++ ) 
                                { 
                                    if( $i > 0 && $i <= $ss ) 
                                    {
                                        echo '<li class="page-item"><a class="page-link" href="?sayfa='.$i.'">'.$i.'</a></li>';
                                    } 
                                } 
                            ?>
                </ul>
              </div>    </div>
                </div>
              </div>
            </div>
          </div>
        </div>
     <?php include("footer.php"); ?>

İptal

📁 PHP Dosya Yöneticisi

📝 talepler.php

📝 talepler.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)