FileMaster

Edit File: banner.php

<?php 
session_start();
include('../config/config.php'); 
include('../config/sqli.php'); 
include('../config/rupiah.php');
include('pengguna.php'); 
if(isset($_SESSION['u'])) {
    if($p['akses'] == 2){
        
function uploadpic($fupload_name){
    $vdir_upload = "../upload/";
    $vfile_upload = $vdir_upload . $fupload_name;
    $tipe_file   = $_FILES['fupload']['type'];
  
    //Simpan gambar dalam ukuran sebenarnya
    move_uploaded_file($_FILES["fupload"]["tmp_name"], $vfile_upload);
  
    //identitas file asli  
    if ($tipe_file=="image/jpeg" ){
        $im_src = imagecreatefromjpeg($vfile_upload);
        }elseif ($tipe_file=="image/png" ){
        $im_src = imagecreatefrompng($vfile_upload);
        }elseif ($tipe_file=="image/gif" ){
        $im_src = imagecreatefromgif($vfile_upload);
        }elseif ($tipe_file=="image/wbmp" ){
        $im_src = imagecreatefromwbmp($vfile_upload);
      }
    $src_width = imageSX($im_src);
    $src_height = imageSY($im_src);
  
    //Simpan dalam versi small 110 pixel
    //Set ukuran gambar hasil perubahan
    $dst_width = 129;
    $dst_height = ($dst_width/$src_width)*$src_height;
  
    //proses perubahan ukuran
    $im = imagecreatetruecolor($dst_width,$dst_height);
    imagecopyresampled($im, $im_src, 0, 0, 0, 0, $dst_width, $dst_height, $src_width, $src_height);
  
    //Simpan gambar
    if ($_FILES["fupload"]["type"]=="image/jpeg" ){
        imagejpeg($im,$vdir_upload . "small_" . $fupload_name);
        }
        elseif ($_FILES["fupload"]["type"]=="image/png" ){
        imagepng($im,$vdir_upload . "small_" . $fupload_name);
        }
        elseif ($_FILES["fupload"]["type"]=="image/gif" ){
        imagegif($im,$vdir_upload . "small_" . $fupload_name);
        }
        elseif($_FILES["fupload"]["type"]=="image/wbmp" ){
        imagewbmp($im,$vdir_upload . "small_" . $fupload_name);
        }
    
    //Hapus gambar di memori komputer
    imagedestroy($im_src);
    imagedestroy($im);
  }
?>
<!DOCTYPE html>
<html lang="en">

<head>
   <meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<title>Banner</title>
	<link rel="shortcut icon" type="image/png" href="<?php echo $url; ?>admin/fav.png">
    <link href="vendor/datatables/css/jquery.dataTables.min.css" rel="stylesheet">
	<link href="vendor/bootstrap-select/dist/css/bootstrap-select.min.css" rel="stylesheet">
    <link href="css/style.css" rel="stylesheet">

</head>

<?php include('leftsidebar.php'); ?>
        <div class="content-body">
            <div class="container-fluid">
			
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
				<div class="d-flex align-items-center mb-4 flex-wrap">
					<h3 class="me-auto">Banner</h3>
					<div>
					<a href="javascript:void(0);" data-bs-toggle="modal" data-bs-target=".tambahgallery" class="btn btn-outline-secondary btn-sm"><i class="fas fa-plus me-2"></i>Tambah Banner</a>
	<div class="modal fade tambahgallery" tabindex="-1" role="dialog" aria-hidden="true">
		<div class="modal-dialog modal-lg">
			<div class="modal-content">
				<div class="modal-header">
					<h5 class="modal-title">Tambah Banner</h5>
					<button type="button" class="btn-close" data-bs-dismiss="modal">
					</button>
				</div>
				<div class="modal-body">
					<div class="row">
                                    <form class="needs-validation" method="POST" novalidate enctype="multipart/form-data">
										        <div class="mb-3 row">
                                                    <label class="col-lg-4 col-form-label" >Nama Banner
                                                        <span class="text-danger">*</span>
                                                    </label>
                                                    <div class="col-lg-8">
														<input type="text" class="form-control" placeholder="Nama Banner" name="judul_banner" required>
														<div class="invalid-feedback">
															Masukkan Nama Banner.
														</div>
                                                    </div>
                                                </div>
												<div class="mb-3 row">
                                                    <label class="col-lg-4 col-form-label" for="gambar">Gambar Banner
                                                    </label>
                                                    <div class="col-lg-8">
														<input type="file" name="fupload" id="fileToUpload">
                                                    </div>
                                                </div>
                  						
					</div>
				</div>	
				<div class="modal-footer">
					<button type="button" class="btn btn-danger light" data-bs-dismiss="modal">Tutup</button>
					<button type="submit" name="tambah" class="btn btn-outline-secondary"><i class="fa fa-plus"></i> Tambah Banner</button>
				</div>	
	</form>							
			</div>									
		</div>										
	</div>					
	
					</div>
				</div>
                <?php
 if (isset($_POST['tambah'])) {
	   
  if($_FILES['fupload']['size'] == 0){
    $idss=uniqid();
    $judul_banner = antiinjection($_POST['judul_banner']);
    
    $sql = "INSERT INTO banner(judul_banner, sesi_banner) VALUE ('$judul_banner', '$idss')";
    $result = mysqli_query($koneksi, $sql);
      echo "<div class='alert alert-secondary'>Gambar Berhasil ditambah</div>";
} else {

$lokasi_file    = $_FILES['fupload']['tmp_name'];
    $tipe_file      = $_FILES['fupload']['type'];
    $nama_file      = $_FILES['fupload']['name'];
    
    $temp = explode(".",$_FILES["fupload"]["name"]);
    $acak           = rand(1,99999) . '.' .end($temp);
    $nama_file_unik = $acak;
    $size= $_FILES['fupload']['size'];  
    $ukuran_max_foto=1500000; // Dalam bytes
    
    
    if (!($tipe_file =="image/jpeg" OR
        $tipe_file =="image/jpg" OR
		$tipe_file=="image/gif" OR
        $tipe_file=="image/png" OR
        $tipe_file=="image/wbmp" )){
	 
    echo "<div class='alert alert-danger'>Berkas Gambar yang diminta</div>";
            }

else if($size > $ukuran_max_foto){  
    
        echo "<div class='alert alert-danger'>Berkas Gambar terlalu besar</div>";      
    } else {
        if (($tipe_file =="image/jpeg" OR
        $tipe_file=="image/gif" OR
        $tipe_file=="image/png" OR
        $tipe_file=="image/wbmp" )){
              
        uploadpic($nama_file_unik);

$idss=uniqid();
     $judul_banner = antiinjection($_POST['judul_banner']);
    
    $sql = "INSERT INTO banner(judul_banner, url_banner, sesi_banner) VALUE ('$judul_banner', '$nama_file_unik', '$idss')";
    $result = mysqli_query($koneksi, $sql);
      echo "<div class='alert alert-secondary'>gambar Berhasil ditambah</div>";
}
	}

}
}

if(isset($_POST['hapus'])) {
    $idel = antiinjection($_POST['idel']);
    $cekgambar=mysqli_query($koneksi, "SELECT url_banner FROM banner WHERE sesi_banner = '$idel'");
    $cg=mysqli_fetch_assoc($cekgambar);
    if($cg['url_banner'] == ''){
    } else {
                unlink("../upload/".$cg['url_banner']);
                unlink("../upload/small_".$cg['url_banner']);
    }
        $sql = "DELETE from banner WHERE sesi_banner = '$idel'";
        $result = mysqli_query($koneksi, $sql);
        echo "<div class='alert alert-secondary'>Banner berhasil dihapus</div>";
    
    
    }

?>
                                <div class="table-responsive">
                                    <table id="example" class="display" style="min-width: 845px">
                                        <thead>
                                            <tr>
                                                <th>Gambar</th>
                                                <th>Title</th>
                                                <th>Hapus</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                              $produk = mysqli_query($koneksi, "SELECT * FROM banner ORDER BY id_banner ASC");
                                              while ($v = mysqli_fetch_array($produk)) {
                                            ?>
                                            <tr>
                                                <td> <?php
                                                    if($v['url_banner'] == ''){
													$satu = '#2769ee';
													$dua = '#7630d2';
													$tiga = '#b848ef';
													$empat = '#7e1d74';
													$lima = '#0411c2';
													$enam = '#c5c5c5';
													$array = array($satu, $dua, $tiga, $empat, $lima, $enam);
                                                ?>
                                                <svg xmlns="http://www.w3.org/2000/svg" width="71" height="71" viewBox="0 0 71 71">
															  <g  transform="translate(-457 -443)">
																<rect  width="71" height="71" rx="12" transform="translate(457 443)" fill="<?php  echo $array[rand(0, count($array) - 1)] ?>"/>
																<g  transform="translate(457 443)">
																  <rect  data-name="placeholder" width="71" height="71" rx="12" fill="<?php  echo $array[rand(0, count($array) - 1)] ?>"/>
																  <circle  data-name="Ellipse 12" cx="18" cy="18" r="18" transform="translate(15 20)" fill="#fff"/>
																  <circle  data-name="Ellipse 11" cx="11" cy="11" r="11" transform="translate(36 15)" fill="#ffe70c" style="mix-blend-mode: multiply;isolation: isolate"/>
																</g>
															  </g>
														</svg>
                                                <?php     } else {
                                                ?>    <img alt="" class="rounded-full" src="<?php echo $url."upload/".$v['url_banner']; ?>" style="width: 100px"> 
                                                <?php
                                                }
                                                ?></td>
                                                <td><?php if($v['judul_banner'] == ''){
                                                    echo " - ";
                                                } else { echo $v['judul_banner']; } ?></td>
                                               
                                        
	
    <td><a href="javascript:void(0);" data-bs-toggle="modal" data-bs-target=".delete<?php echo $v['sesi_banner']; ?>" class="btn btn-outline-danger"><i class="fa fa-trash" aria-hidden="true"></i> Hapus</a></td>
	<div class="modal fade delete<?php echo $v['sesi_banner']; ?> bg-danger" tabindex="-1" role="dialog" aria-hidden="true">
		<div class="modal-dialog modal-lg">
			<div class="modal-content">
				<div class="modal-header">
					<h5 class="modal-title">Menghapus data</h5>
					<button type="button" class="btn-close" data-bs-dismiss="modal">
					</button>
				</div>
				<div class="modal-body">
					<div class="row">
						<b>Yakin untuk menghapus, <?php echo $v['judul_banner']; ?>?</b>											
					</div>
				</div>	
				<div class="modal-footer">
					<button type="button" class="btn btn-danger light" data-bs-dismiss="modal">Tutup</button>
	<form action="" method="post">
              		<input type="hidden" name="idel" value="<?php echo $v['sesi_banner']; ?>" />
					<button type="submit" name="hapus" class="btn btn-outline-primary"><i class="fa fa-trash"></i> Hapus Banner</button>
    </form>
				</div>								
			</div>									
		</div>										
	</div>											
                                            </tr>
											<?php } ?>
                                        </tbody>
                                    </table>

<?php
                                             
                                             $produk = mysqli_query($koneksi, "SELECT * FROM banner ORDER BY id_banner ASC");
                                             while ($v = mysqli_fetch_array($produk)) {
                                            ?>
		<div class="modal fade edit<?php echo $v['sesi_banner']; ?>" tabindex="-1" role="dialog" aria-hidden="true">
		<div class="modal-dialog modal-lg">
			<div class="modal-content">
				<div class="modal-header">
					<h5 class="modal-title">Perbaharui Banner</h5>
					<button type="button" class="btn-close" data-bs-dismiss="modal">
					</button>
				</div>
			<form class="needs-validation" method="post" novalidate enctype="multipart/form-data">
				<div class="modal-body">
					<div class="row">
												<div class="mb-3 row">
                                                    <label class="col-lg-4 col-form-label" for="gallery<?php echo $v['sesi_banner']; ?>">Nama banner
                                                        <span class="text-danger">*</span>
                                                    </label>
                                                    <div class="col-lg-8">
														<input type="text" class="form-control" id="gallery<?php echo $v['sesi_banner']; ?>"  placeholder="Nama banner" name="judul_banner" required value="<?php echo $v['judul_banner']; ?>">
														<div class="invalid-feedback">
															Masukkan Nama Banner.
														</div>
                                                    </div>
                                                </div>

<div class="mb-3 row">
                                                    <label class="col-lg-4 col-form-label" for="isiberita">Gambar Gallery
                                                    </label>
                                                    <div class="col-lg-8">
														<input type="file" name="fupload" id="fileToUpload">
                                                        <br/><br/>
                                                        <img alt="" class="rounded-full" src="<?php
                                               if($v['url_banner'] == ''){
                                                echo $url."noimg.png";
                                               } else {
                                                echo $url."upload/".$v['url_banner'];
                                               }
                                               ?>" style="width: 100px" />
                                                    </div>
                                                </div>
                  						
					</div>
				</div>	
				<div class="modal-footer">
              		<input type="hidden" name="ids" value="<?php echo $v['sesi_banner']; ?>" />
					<button type="button" class="btn btn-danger light" data-bs-dismiss="modal">Tutup</button>
					<button type="submit" name="ubah" class="btn btn-outline-primary"><i class="fa fa-pencil"></i> Perbaharui Banner</button>
				</div>
				</form>
													
			</div>									
		</div>										
	</div>	
	<?php } ?>

</div>
                            </div>
                        </div>
                    </div>
				</div>
            </div>
        </div>
      
       <?php include('footer.php'); ?>
        
    </div>
    <script src="vendor/global/global.min.js"></script>
    <script src="vendor/chartjs/chart.bundle.min.js"></script>
	<script src="vendor/apexchart/apexchart.js"></script>
    <script src="vendor/datatables/js/jquery.dataTables.min.js"></script>
    <script src="js/plugins-init/datatables.init.js"></script>
	<script src="vendor/bootstrap-select/dist/js/bootstrap-select.min.js"></script>
    <script src="js/custom.min.js"></script>
	<script src="js/dlabnav-init.js"></script>
	
 
	<script>
		(function () {
		  'use strict'

// Fetch all the forms we want to apply custom Bootstrap validation styles to
		  var forms = document.querySelectorAll('.needs-validation')

// Loop over them and prevent submission
		  Array.prototype.slice.call(forms)
			.forEach(function (form) {
			  form.addEventListener('submit', function (event) {
				if (!form.checkValidity()) {
				  event.preventDefault()
				  event.stopPropagation()
				}

form.classList.add('was-validated')
			  }, false)
			})

})()
	</script>

</body>
</html>
<?php }
 else if($p['akses'] == 0){
  echo "<body>
  <meta http-equiv='refresh' content='0; url=../login'>
  </body>";
 }
} else {
  echo "<body>
  <meta http-equiv='refresh' content='0; url=../login'>
  </body>";

} ?>

Back