במ12[aspddfsdfsdfdrxcvxcvcxvxcvxcvxcvxcvxcvxcvxcvxcvxxvxcvxcvxcv;'

]]jkjjgdjffksdkdfdkfjgsldkfhgjkgjkhjkgjkdascxvxcvxcvjdklfgjslkdfgjlskdfgjdskfgj במ12[aspddfsdfsdfdrxcvxcvcxvxcvxcvxcvxcvxcvxcvxcvxcvxxvxcvxcvxcv;'

<?php
ob_start();
include_once("config/config.php");
$category=trim($_POST['category']);
$ranking=trim($_POST['ranking']);
if($_POST['submit']=='Submit' && $_POST['update']<>''){
$update_query = $mysqli->query("UPDATE category SET category='$category', ranking='$ranking' WHERE ID='".$_POST['update']."'");
    	if($update_query)
			{
			$msg="Category Updated Successfully";
			}
		else{
	        $msg="Error In Updation";
	        }
}
if($_GET['action']=='updation' && $_GET['id']<>''  && $_GET['status']<>''){
$update_query = $mysqli->query("UPDATE category SET status='".$_GET['status']."' WHERE ID='".$_GET['id']."'");
    	if($update_query)
			{
			header("location:category.php");
			}
		else{
	        $msg="Error In Disable Operation";
	        }
}
if($_GET['action']=='edit' && $_GET['id']<>''){
//echo 	"SELECT * FROM category where id='".$_GET["id"]."'";	
	    $results = $mysqli->query("SELECT * FROM category where id='".$_GET["id"]."'");
	    $row = $results->fetch_assoc();
		if(!is_array($row))
			{
			$msg="Not found ID=".$_GET["id"];
			}
		else{
			$uid=$row['id'];
			$ucat=$row['category'];
			$uranking=$row['ranking'];
		    }
}

if($_POST['submit']=='Submit' && $_POST['category'] <> '' && $_POST['ranking'] <> '' && empty($_POST['update'])){
$category = '"'.$mysqli->real_escape_string(trim($_POST['category'])).'"';
$ranking = '"'.$mysqli->real_escape_string(trim($_POST['ranking'])).'"';
$insert_row = $mysqli->query("INSERT INTO category(category, ranking, status) VALUES($category, $ranking,'1')");
if($insert_row){
	$msg="Category Inserted Successfully";
	}
	else{
	$msg="Error In Insertion";
	}
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>KVK, Ferozepur Admin Panel</title>

<link href="assets/css/bootstrap.css" rel="stylesheet" />

<link href="assets/css/font-awesome.css" rel="stylesheet" />

<link href="assets/css/custom.css" rel="stylesheet" />

<link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />
</head>
<body>
<div id="wrapper">
  <nav class="navbar navbar-default navbar-cls-top " role="navigation" style="margin-bottom: 0">
    <?php include_once("header.php"); ?>
  </nav>
  
  <nav class="navbar-default navbar-side" role="navigation">
    <?php include_once("leftside.php"); ?>
  </nav>
  
  <div id="page-wrapper" >
    <div id="page-inner">
      <div class="row">
        <div class="col-md-12">
          <h2>Manage Category</h2>
        </div>
      </div>
      
      <hr />
      <div class="row">
        <div class="col-md-12">
          
          <div class="panel panel-default">
            <div class="panel-heading"> <?php echo $msg; ?> </div>
            <div class="panel-body">
              <div class="row">
                <div class="col-md-6">
                  <h3>Add Category</h3>
                  <form role="form" action="category.php" method="post">
                    <input type="hidden" name="update" value="<?php echo $uid; ?>" >
                    <div class="form-group">
                      <label>Category Name</label>
                      <input class="form-control"  required  name="category" id="category" placeholder="Please Enter Category" value="<?php echo $ucat; ?>" />
                    </div>
                    <div class="form-group">
                      <label>Select Page</label>
                      <select class="form-control" name="ranking" id="ranking">
                       <option value="" selected="selected">Select Option</option>
					   <?php 
				   $results = $mysqli->query("SELECT * FROM php_pages");
				   while($row = $results->fetch_assoc()) {
				   ?>
                    <option value="<?php echo $row['id']; ?>"><?php echo $row['page']; ?>
                     ==><?php echo $row['title']; ?></option>
                        <?php } ?>
                      </select>
                    </div>
                    <input type="submit" class="btn btn-default" value="Submit" name="submit" >
                    &nbsp;&nbsp;
                    <input type="reset" class="btn btn-primary" value="Reset">
                  </form>
                  <br />
                </div>
              </div>
            </div>
          </div>
          
        </div>
        <div class="col-md-12">
          
          <div class="panel panel-default">
            <div class="panel-heading"> Manage Categories</div>
            <div class="panel-body">
              <div class="table-responsive">
                <table class="table table-striped table-bordered table-hover" id="dataTables-example">
                  <thead>
                    <tr>
                      <th>#</th>
                      <th>Category</th>
                      <th>Ranking</th>
                      <th align="center">Action</th>
                    </tr>
                  </thead>
                  <tbody>
                    <?php 
				   $results = $mysqli->query("SELECT a.*,b.title FROM category as a 
				   left join php_pages as b on b.id=a.ranking order by a.id ");
				   while($row = $results->fetch_assoc()) {
				   ?>
                    <tr class="odd gradeX">
                      <td width="10%"><?php echo $row['id']; ?></td>
                      <td width="10%"><?php echo $row['category']; ?></td>
                      
                      <td width="10%" ><?php echo $row['title']?$row['title']:'#'; ?></td>
                      <td width="10%" class="center"><a  class="btn btn-default" href="category.php?action=edit&id=<?php echo $row['id'];?>">Edit</a>&nbsp;&nbsp;
                      <?php if($row['status']==1){?>
                      <a  class="btn btn-default" href="category.php?action=updation&status=0&id=<?php echo $row['id'];?>">Disable</a> <?php }else {?><a  class="btn btn-default" href="category.php?action=updation&status=1&id=<?php echo $row['id'];?>">Enable</a><?php } ?></td>
                      <?php } ?>
                    </tr>
                  </tbody>
                </table>
              </div>
            </div>
          </div>
          
        </div>
      </div>
      
      
    </div>
    
  </div>
  
</div>



<script src="assets/js/jquery-1.10.2.js"></script>

<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/jquery.metisMenu.js"></script>

<script src="assets/js/custom.js"></script>
<script src="assets/js/jquery-1.10.2.js"></script>

<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/jquery.metisMenu.js"></script>

<script src="assets/js/dataTables/jquery.dataTables.js"></script>
<script src="assets/js/dataTables/dataTables.bootstrap.js"></script>
<script>
            $(document).ready(function () {
                $('#dataTables-example').dataTable();
            });
    </script>

<script src="assets/js/custom.js"></script>
</body>
</html>