1#@!#!123s

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

if(isset($_GET['del'])){
  $id = $_GET['id'];
    $query = "DELETE FROM tbl_news WHERE id='$id'";
    mysqli_query($con,$query);
  }

if(isset($_GET['cid'])){
  $cid = $_GET['cid'];
  $val = $_GET['val'];
  if($val == 1){
     $put =0;
  }else if($val == 0){
     $put =1;
  }

  $query = "UPDATE `tbl_news` SET `status`='$put' WHERE `id`='$cid'";
  mysqli_query($con,$query);
}



$query = "SELECT * FROM tbl_news ORDER BY id DESC";
$run = mysqli_query($con,$query);
?>
<!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: 100%;

}

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

#customers td i {
  color:#f10a7f;
}

#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: #014576;
    color: white;
    padding: 7px 20px;
    margin: 8px 0;
    border: none;
    border-radius: 4px;
    cursor: pointer;
}

input[type=checkbox] {
    width: 18px;
    height: 18px;
    cursor: pointer;
}

#table-wrapper {
  position:relative;
}
#table-scroll {
  height:700px;
  overflow:auto;  
  overflow-x: hidden;
  margin-top:20px;
}
#table-wrapper table {
  width:100%;
    
}
</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">Notice</li>
        </ol>

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

        <div id="table-wrapper">
        <div id="table-scroll">
        
        <?php if(isset($_GET['val'])) { ?>
         <div class="alert alert-success" id="msg">
           <strong>Success!</strong> Notice updated sucessfully.
        </div>
      <?php } ?>

       <table id="customers">
          <!-- <a href="newpost.php">New Post</a> -->
           <p style="font-weight:bold;color:#e05513;cursor: pointer;"><img src="images/add.png" width="25px"><a href="newpost.php" style="text-decoration: none;"> Add New Notice</a></p>
            <tr>
               <th>Sl No</th>
               <th>Description</th>
              
               <th>Status</th>

               <th>Edit</th>
               <th>Delete</th>

            </tr>
           <?php 
           $i=1;
           while($row=mysqli_fetch_assoc($run)) { ?>
            <tr>
              <td><?php echo $i; ?></td>
              <td><?php echo substr($row['news'],0,165)."...."; ?></td>

               <td><input type="checkbox" id="fruit1" name="fruit-1" value="Apple" onclick="ShowInFront(<?php echo $row['id']; ?>,<?php echo $row['status']; ?>);" <?php if($row['status'] == 1) echo "checked"; ?>></td>

            
              <td><a href="edit-post.php?edit=true&id=<?php echo $row['id']; ?>"><i class="fas fa-fw far fas fas fa-edit"></i></a></td>
              <td><i class="fas fa-fw far fas fas fa-trash-alt" onclick="Delete(<?php echo $row['id']; ?>);"></td>
            </tr>
            <?php $i++; } 
            mysqli_close($con);
            ?>
          
        </table>
</div>
</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('post.php?del=true&id='+id,'_self');
   }else{
      console.log('user click on cancel button');
   }
    
});

};


</script>
<script type="text/javascript">
     setInterval(function(){
      $("#msg").hide(500);
    }, 3000);

        function ShowInFront(cid,val){
    window.open('post.php?cid='+cid+'&val='+val,'_self');
}
   </script>
</body>

</html>