1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / gceburdwan / public_html / Admin /
Filename : gallery.php
back
<?php
if(!isset($_COOKIE['adminLogin'])){
   header('location:login.php'); 
}
include("db.php");
if(isset($_GET['del'])){
  $id = $_GET['id'];

  $q = "SELECT * FROM tbl_gallery WHERE id='$id'";
  $r = mysqli_query($con,$q);
  while($del=mysqli_fetch_assoc($r)) {
    $file = "Banner-and-Gallery/".$del['gallery_name']; 
    unlink($file);
  }

  $query = "DELETE FROM tbl_gallery WHERE id='$id'";
  mysqli_query($con,$query);
}

       if(isset($_POST['submit'])){
        foreach($_FILES['files']['tmp_name'] as $key => $tmp_name ){
        $file_name = $key.$_FILES['files']['name'][$key];
        $file_size =$_FILES['files']['size'][$key];
        $file_tmp =$_FILES['files']['tmp_name'][$key];
        $file_type=$_FILES['files']['type'][$key];  
         
        $galleryCategory = $_POST['galleryCategory'];                                      
                                            
        $file_name_time = time()."-".$file_name;
        move_uploaded_file($file_tmp,"Banner-and-Gallery/".$file_name_time);
       
        $query = "INSERT INTO tbl_gallery(gallery_name,cid) VALUES('$file_name_time','$galleryCategory')";
        mysqli_query($con,$query);

        }   
       }


$query = "SELECT * FROM tbl_gallery ORDER BY id DESC";
$run = mysqli_query($con,$query);

$query_11 = "SELECT * FROM Bcategory";
$run_11 = mysqli_query($con,$query_11);
while($row=mysqli_fetch_assoc($run_11)) { 
   $arrData[] = $row;                  
}

?>
<!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, shrink-to-fit=no">
  <meta name="description" content="">
  <meta name="author" content="">

  <title>GCE | Dashboard</title> 

  <!-- Custom fonts for this template-->
  <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">

  <!-- Page level plugin CSS-->
  <link href="vendor/datatables/dataTables.bootstrap4.css" rel="stylesheet">

  <!-- Custom styles for this template-->
  <link href="css/sb-admin.css" rel="stylesheet">
<style>
#customers {
  font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
  border-collapse: collapse;
  width: 50%;

}

#customers td{
  border: 1px solid #ddd;
  padding: 8px;
  text-align: center;
  cursor: pointer;
  background-color: burlywood;
}

#customers td i {
  color:#f5065e;
}

#customers tr:nth-child(even){background-color: #f2f2f2;}

#customers tr:hover {background-color: #ddd;}

#customers th {
  padding-top: 12px;
  padding-bottom: 12px;
  text-align: left;
  background-color: #085fff;
  color: white;
  text-align: center;
}

input[type=text]{
    /*width: 100%;*/
    padding: 6px 83px;
    margin: 8px 0;
    display: inline-block;
    border: 1px solid #4caf50;
    border-radius: 4px;
    box-sizing: border-box;
}

input[type=submit] {
    /*width: 100%;*/
    background-color: #085fff;
    color: white;
    padding: 7px 20px;
    margin: 8px 0;
    border: none;
    border-radius: 4px;
    cursor: pointer;
}
  input[type="file"]{
    color: #014373;
    width: 233px;
}


.bg-primary001 {
    background-color: #f6f7f030 !important;
}
.bg-primary002 {
    background-color: #cecccc !important;
}
</style>
</head>

<body id="page-top">
 
  <?php include("navbar.php");?>
  

  <div id="wrapper">

    <?php include("side.php");?>

    <!-- Sidebar -->
 

    <div id="content-wrapper">

      <div class="container-fluid">

        <!-- Breadcrumbs-->
        <ol class="breadcrumb">
          <li class="breadcrumb-item">
            <a href="index.php">Dashboard</a>
          </li>
          <li class="breadcrumb-item active">Gallery Images</li>
        </ol>

        <!-- Page Content -->
        <!-- <h1>Blank Page</h1>
        <hr>
        <p>This is a great starting point for new custom pages.</p> -->
  

    <form action="gallery.php" method="post" enctype="multipart/form-data">
        <div class="row">
            <div class="col-xl-3 col-sm-6 mb-3">
              <ol class="breadcrumb">
         
              <select name="galleryCategory" required="">
                <option value="">--select category--</option>
               <?php foreach($arrData as $data){ ?>
                <option value="<?php echo $data['id'];?>"><?php echo $data['name'];?></option>
               <?php } ?>
              </select>
        
          
          <li class="breadcrumb-item">
              <br>
              <input type="file" name="files[]" multiple="" required="">
          </li>
             <input type="submit" name="submit" value="Submit">
         </ol>
          </div>
      </div>
        </form>
      
         <div class="row">
           <?php while($row=mysqli_fetch_assoc($run)) { ?>
           <div class="col-xl-3 col-sm-6 mb-3">
            <div class="card text-white bg-primary002 asmu o-hidden h-100">
              <div class="card-body">
                <div class="card-body-icon">
                  <!-- <i class="fas fa-fw fa-comments"></i> -->
                </div>
                <div class="mr-5"><img src="Banner-and-Gallery/<?php echo $row['gallery_name']; ?>" width="233px" height="150px"></div>
              </div>
              <a class="card-footer text-white clearfix small z-1" href="#">
                <span class="float-left b"><i style="color:red;" class="fas fa-fw far fas fas fa-trash-alt" onclick="Delete(<?php echo $row['id']; ?>);"></i></span>
              </a>
            </div>
          </div>
        
        <?php }  mysqli_close($con);  ?>

        </div>



      </div>
      <!-- /.container-fluid -->

      <!-- Sticky Footer -->
     <!--  <footer class="sticky-footer">
        <div class="container my-auto">
          <div class="copyright text-center my-auto">
            <span>Copyright © Your Website 2019</span>
          </div>
        </div>
      </footer> -->

    </div>
    <!-- /.content-wrapper -->
   







  </div>
  <!-- /#wrapper -->

  <!-- Scroll to Top Button-->
  <a class="scroll-to-top rounded" href="#page-top">
    <i class="fas fa-angle-up"></i>
  </a>

  <!-- Logout Modal-->
  <div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
      <div class="modal-content">
        <div class="modal-header">
          <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
          <button class="close" type="button" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">×</span>
          </button>
        </div>
        <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
        <div class="modal-footer">
          <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
          <a class="btn btn-primary" href="login.php">Logout</a>
        </div>
      </div>
    </div>
  </div>

  <!-- Bootstrap core JavaScript-->
  <script src="vendor/jquery/jquery.min.js"></script>
  <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

  <!-- Core plugin JavaScript-->
  <script src="vendor/jquery-easing/jquery.easing.min.js"></script>

  <!-- Custom scripts for all pages-->
  <script src="js/sb-admin.min.js"></script>
  <script src="js/exConfirm.js"></script>

  <script type="text/javascript">
 function Delete(id){ 
var configOpt = {
    title: "Alert!",
    message : "Are you sure, you want to delete.?",

    zIndex: 9999, //Integer
    overlayBackground: "rgba(255,255,255,0)", //String [HEX, RGB, RGBA]
    bodyBackground: "rgba(255,255,255,1)", //String [HEX, RGB, RGBA]
    bodyBorder: "2px solid #1c84ef", //String
    titleBackground: "rgb(28, 132, 239)", //String [HEX, RGB, RGBA]
    textColor: "#000000", //String [HEX, RGB, RGBA]
    titleColor: "#ffffff", //String [HEX, RGB, RGBA]
    btnPosition: "right", //String [left, center, right]
    top: "40%", //String [px, %]
    right: "38%" //String [px, %]
};

exConfirmPromise.make(configOpt).then(function (e) {
   if(e == true){
      window.open('gallery.php?del=true&id='+id,'_self');
   }else{
      console.log('user click on cancel button');
   }
    
});

};


</script>

</body>

</html>