1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / gceburdwan / public_html_old / Admin /
Filename : menu.php
back
<?php
if(!isset($_COOKIE['adminLogin'])){
   header('location:login.php'); 
}
include("db.php");
if(isset($_POST['submit'])){
$name = $_POST['manu_insert'];
$query = "INSERT INTO `Bcategory`(name) VALUES('$name')";
mysqli_query($con,$query);
}

if(isset($_POST['updateData'])){
$name = $_POST['manu_update'];
$id = $_POST['id'];
$query = "UPDATE `Bcategory` SET `name`='$name' WHERE `id`='$id'";
mysqli_query($con,$query);
}


if(isset($_GET['update'])){
  $id = $_GET['id'];
  $query = "SELECT * FROM Bcategory WHERE id='$id'";
  $run = mysqli_query($con,$query);
  while($row=mysqli_fetch_assoc($run)) { 
     $updateName = $row['name'];
     $updateId = $row['id'];
  }
}

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


$query = "SELECT * FROM Bcategory";
$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: 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: #014576;
    color: white;
    padding: 7px 20px;
    margin: 8px 0;
    border: none;
    border-radius: 4px;
    cursor: pointer;
}

</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 Category List</li>
        </ol>

        <!-- Page Content -->
        <!-- <h1>Blank Page</h1>
        <hr>
        <p>This is a great starting point for new custom pages.</p> -->
        <p style="font-weight:bold;color:#e05513;cursor: pointer;"><img src="images/add.png" width="25px"><a href="menu.php?add=true" style="text-decoration: none;"> Add Category</a></p>
     
      <?php if(isset($_GET['add'])) { ?>
      <form action="menu.php" method="post">
      <table id="customers">
            <tr>
              <th>Enter Category Name</th>
            </tr>
            <tr>
              <td>
                 <input type="text"  name="manu_insert" required>&nbsp<input type="submit" value="Submit" name="submit">
              </td>
              </tr>
      </table>
      </form><br>
      <?php } 
       if(isset($_GET['update'])) { 
      ?>
        <form action="menu.php" method="post">
       <table id="customers">
            <tr>
              <th>Enter Category Name</th>
            </tr>
            <tr>
              <td>
                 <input type="text" size="40" name="manu_update" value="<?php echo $updateName; ?>" required>&nbsp
                 <input type="hidden" name="id" value="<?php echo $updateId; ?>">
                 <input type="submit" value="Update" name="updateData">
              </td>
              </tr>
      </table>
    </form><br>
    <?php } ?>
       
       <table id="customers">
            <tr>
              <th>SL No</th>
              <th>Category Name</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 $row['name']; ?></td>
              
              

              <td><a href="menu.php?update=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>
      <!-- /.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="logout.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('menu.php?del=true&id='+id,'_self');
   }else{
      console.log('user click on cancel button');
   }
    
});

};

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

</body>

</html>