bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php
include "dbc.php"; 
page_protect();
if(isset($_POST['Submit'])){
		 if($_POST['Submit'] == 'Save') 	
    {
    
    $cat_id = $_POST['cat_id'];
    $id = $_POST['id'];
    $category = $_POST['category'];
    $category_tamil = $_POST['category_tamil'];
    $home_page = $_POST['home_page'];
    $product_page = $_POST['product_page'];
    $our_products = $_POST['our_products'];
	$status = $_POST['status'];
	$sort = $_POST['sort'];
	$short_code = $_POST['short_code'];
	$filter=implode(",",$_POST['filter']);

$meta_title = $_POST['meta_title'];
  $meta_desc = $_POST['meta_desc'];
  $meta_keyword = $_POST['meta_keyword'];
  $meta_newskeyword = $_POST['meta_newskeyword'];
  $meta_author = $_POST['meta_author'];
  $meta_classification = $_POST['meta_classification'];
  $canonical = $_POST['canonical'];
  $og_title = $_POST['og_title'];
  $og_desc = $_POST['og_desc'];
  $og_lang = $_POST['og_lang'];
  $og_url = $_POST['og_url'];
  $og_sitename = $_POST['og_sitename'];
  $page_description = $_POST['page_description'];
  $seo_id = $_POST['seo_id'];

$result_category = strtolower($category);
      $category_page = strtolower(str_replace(" ","-",$result_category));

if($seo_id=="") {

list($max) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(id) AS max FROM `seo`"));

$max=$max+1;
$seo_id="SEO".$max."";

$ins_query = mysqli_query($link,"INSERT INTO `seo` (`date`, `seo_id`, `page`, `meta_title`, `meta_desc`, `meta_keyword`, `meta_newskeyword`, `meta_author`, `meta_classification`, `canonical`, `og_title`, `og_desc`, `og_lang`, `og_url`, `og_sitename`, `status`,`cat_id`) VALUES (NOW(), '$seo_id', '$category_page', '$meta_title', '$meta_desc', '$meta_keyword', '$meta_newskeyword', '$meta_author', '$meta_classification', '$canonical', '$og_title', '$og_desc', '$og_lang', '$og_url', '$og_sitename', '$status','$cat_id')");

}

else
{
    $ins_query = mysqli_query($link,"UPDATE `seo` SET `date`=NOW(), `page`='$category_page', `meta_title`='$meta_title', `meta_desc`='$meta_desc', `meta_keyword`='$meta_keyword', `meta_newskeyword`='$meta_newskeyword', `meta_author`='$meta_author', `meta_classification`='$meta_classification', `canonical`='$canonical', `og_title`='$og_title', `og_desc`='$og_desc', `og_lang`='$og_lang', `og_url`='$og_url', `og_sitename`='$og_sitename', `cat_id`='$cat_id', `status`='$status' WHERE seo_id='$seo_id'");

}

$ins_query = mysqli_query($link,"update `category_tbl` set `cat_name_tamil`='$category_tamil',`cat_name`='$category',`home_page`='$home_page',`product_page`='$product_page',`our_products`='$our_products',`status`='$status',`sort`='$sort', `short_code`='$short_code',filter='$filter',page_description='$page_description',seo_id='$seo_id' where cat_id ='$cat_id'");

$upload_picture = $_FILES['upload_picture']['name'];
		  if($upload_picture != "")
		  {	
		  $secondname=rand(0,10000000000);
		  $uploaddir = "uploads/category/";
		  $upload_pic = $uploaddir.$secondname.$upload_picture;			
		  copy($_FILES['upload_picture']['tmp_name'], $upload_pic);
		  chmod("$upload_pic",0777);
		  mysqli_query($link,"UPDATE category_tbl SET `cat_image` = '$upload_pic' WHERE cat_id ='$cat_id'");
		  $msg[] = "Image Uploaded Sucess! "; 
		  }		
	$msg[] = "Sucessfully Saved! ";	
				
    }
  }

?>
<?php include'header.php';?>
<script type="text/javascript" src="js/jquery.1.8.3.min.js"></script>
 
          <div class="main-bar">
            <h3>
              <i class="fa fa-plus"></i>&nbsp; Update Category</h3>
          </div>
        </header>
      </div>
      <?php include'admin_admin.php';?>
      <div id="content">
        <div class="outer">
          <div class="inner bg-light lter">
            <style>
              .form-control.col-lg-6 {
                width: 50% !important;
              }
            </style>
            <div class="row">
              <div class="col-lg-12">
                <div class="box">
                  <header class="dark">
                    <div class="icons">
                      <i class="fa fa-check"></i>
                    </div>
                    <h5>Update Category</h5>
                    <div class="toolbar">
                      <div class="btn-group">
                      </div>
                    </div>

</header>
				  <div class="row-fluid sortable">
            <?php include 'msg_display.php'; ?>
            <form class="form-horizontal" method="post" enctype="multipart/form-data" >
			<fieldset>
				<div class="box span12">
					<div class="box-header" data-original-title>
						<h2><i class="halflings-icon edit"></i><span class="break"></span>Category Details</h2>
						<div class="box-icon">
							<a href="#" class="btn-setting"><i class="halflings-icon wrench"></i></a>
							<a href="#" class="btn-minimize"><i class="halflings-icon chevron-up"></i></a>
							<a href="#" class="btn-close"><i class="halflings-icon remove"></i></a>
						</div>
					</div>
					<div class="box-content">
							  <?php
							  $id = $_GET['id'];
                $sel_cms = mysqli_query($link,"select * from category_tbl where id='$id'");
							  $rw_cms = mysqli_fetch_object($sel_cms);

$seo_id = $rw_cms->seo_id;

$sel_seo = mysqli_query($link,"select * from seo where seo_id='$seo_id'");
                $rw_seo = mysqli_fetch_object($sel_seo);
               var_dump($rw_seo);
							  ?>
							  <div class="col-md-4">
                              <div class="control-group">
                                <label class="control-label">Category ID</label>
                                <div class="controls">
                                <input name="id" id="id" type="hidden" value="<?php echo $rw_cms->id; ?>" >
                                <input name="seo_id" id="seo_id" type="hidden" value="<?php echo $rw_cms->seo_id; ?>" >
                                <input class="form-control" name="cat_id" id="cat_id" type="text" value="<?php echo $rw_cms->cat_id; ?>" readonly>
                                
                              
                                </div>
					  		  </div>
							  </div>
                               <div class="col-md-4">
                               <div class="control-group">
                                <label class="control-label">Category (Tamil)</label>
                                <div class="controls">
                                <input type="text" class="validate[required] form-control" name="category_tamil" id="category_tamil" required value="<?php echo $rw_cms->cat_name_tamil; ?>">
                                </div>
					  		  </div>
							  </div>
							  <div class="col-md-4">
                               <div class="control-group">
                                <label class="control-label">Category</label>
                                <div class="controls">
                                <input type="text" class="validate[required] form-control" name="category" id="category" required value="<?php echo $rw_cms->cat_name; ?>">
                                </div>
					  		  </div>
							  </div>
                              <div class="col-md-4">
                              <div class="control-group">
                                <label class="control-label">Short Code</label>
                                <div class="controls">
                                <input type="text" class="validate[required] form-control" name="short_code" id="short_code" required value="<?php echo $rw_cms->short_code; ?>">
                                </div>
					  		  </div>
							  </div>
                              <div class="col-md-4">
                              <div class="control-group">
                                <label class="control-label">Image</label>
                                <div class="controls">
                                <img src="<?php echo $rw_cms->cat_image; ?>" class="img-circle" width="100" height="100">
                                <input type="file" name="upload_picture" id="fileUpload" class="form-control">
                                </div>
					  		  </div>
							  </div>
                              <div class="col-md-4">
                              <div class="control-group">
                                <label class="control-label">Display in page</label>
                                <div class="controls">
                                <?php 
                                $product_page = $rw_cms->product_page;
                                $home_page = $rw_cms->home_page;
                                $our_products = $rw_cms->our_products;
                                ?>
                                <input type="checkbox" class="validate[required] input-xlarge" name="home_page" id="home_page" value="1" <?php if($home_page=="1"){ ?> checked="checked" <?php }?>>Home Top Menu
                                <input type="checkbox" class="validate[required] input-xlarge" name="product_page" id="product_page" value="1" <?php if($product_page=="1"){ ?> checked="checked" <?php }?>>Left of the Product Page
                                <input type="checkbox" class="validate[required] input-xlarge" name="our_products" id="our_products" value="1" <?php if($our_products=="1"){ ?> checked="checked" <?php }?>>Home Page Our Products
                                </div>
					  		  </div>
							  </div>
                              <div class="col-md-4">
                              <div class="control-group">
								<label class="control-label" for="selectError">Status <span class="required">*</span></label>
								<div class="controls">
								  <select name="status" id="status" class="form-control" required >
									<option value="Active" selected>Active</option>
									<option value="Disabled">Disabled</option>
								  </select>
								</div>
							  </div>
							  </div>
                              <div class="col-md-4">
                              <div class="control-group">
                                <label class="control-label">Sort Order <span class="required">*</span></label>
                                <div class="controls">
                                <input class="form-control" name="sort" id="sort" type="text" placeholder="Sort" value="<?php echo $rw_cms->sort; ?>">
                                </div>
					  		  </div>
                              </div>

<div class="col-md-4">
            <div class="control-group">
              <label class="control-label">Meta Tag Title <span class="required">*</span></label>
              <div class="controls">
                <input class="form-control" name="meta_title" id="meta_title" type="text" placeholder="Meta Tag Title" required value="<?php echo $rw_seo->meta_title; ?>">
              </div>
            </div>
          </div>
          <div class="col-md-4">

<div class="control-group">
              <label class="control-label">Meta Tag Description </label>
              <div class="controls">
                <textarea rows="3" class="form-control" name="meta_desc" id="meta_desc" placeholder="Meta Tag Description"><?php echo $rw_seo->meta_desc; ?></textarea>
              </div>
            </div>
          </div>
          <div class="col-md-4">

<div class="control-group">
              <label class="control-label">Meta Tag Keywords </label>
              <div class="controls">
                <textarea rows="3" class="form-control" name="meta_keyword" id="meta_keyword" placeholder="Meta Tag Keywords"><?php echo $rw_seo->meta_keyword; ?></textarea>
              </div>
            </div>
          </div>
          <div class="col-md-4">

<div class="control-group">
              <label class="control-label">Meta Tag News Keywords </label>
              <div class="controls">
                <textarea rows="3" class="form-control" name="meta_newskeyword" id="meta_newskeyword" placeholder="Meta Tag News Keywords"><?php echo $rw_seo->meta_newskeyword; ?></textarea>
              </div>
            </div>
          </div>
          <div class="col-md-4">

<div class="control-group">
              <label class="control-label">Meta Tag Author </label>
              <div class="controls">
                <textarea rows="3" class="form-control" name="meta_author" id="meta_author" placeholder="Meta Tag Author"><?php echo $rw_seo->meta_author; ?></textarea>
              </div>
            </div>
          </div>
          <div class="col-md-4">

<div class="control-group">
              <label class="control-label">Meta Tag Classification </label>
              <div class="controls">
                <textarea rows="3" class="form-control" name="meta_classification" id="meta_classification" placeholder="Meta Tag Classification"><?php echo $rw_seo->meta_classification; ?></textarea>
              </div>
            </div>
          </div>
          <div class="col-md-4">

<div class="control-group">
              <label class="control-label">Meta Tag Canonical</label>
              <div class="controls">
                <textarea rows="3" class="form-control" name="canonical" id="canonical" placeholder="Meta Tag Canonical"><?php echo $rw_seo->canonical; ?></textarea>
              </div>
            </div>
          </div>
          <div class="col-md-4">

<div class="control-group">
              <label class="control-label">OG:Title </label>
              <div class="controls">
                <input type="text" name="og_title" id="og_title" class="validate[required] form-control" value="<?php echo $rw_seo->og_title; ?>">
              </div>
            </div>
          </div>
          <div class="col-md-4">

<div class="control-group">
              <label class="control-label">OG:Site Name </label>
              <div class="controls">
                <input type="text" name="og_sitename" id="og_sitename" class="validate[required] form-control" value="<?php echo $rw_seo->og_sitename; ?>">
              </div>
            </div>
          </div>
              <div class="col-md-8">

<div class="control-group">
              <label class="control-label">Page Description </label>
              <div class="controls">
              <textarea name="page_description" id="page_description" class="form-control" rows="5" cols="50"><?php echo $rw_cms->page_description; ?></textarea>
              </div>
            </div>
          </div>

</div>
	
			
		</div>
		</div>
		
	<div class="modal hide fade" id="myModal">
		<div class="modal-header">
			<button type="button" class="close" data-dismiss="modal">×</button>
			<h3>Settings</h3>
		</div>
		<div class="modal-body">
			<p>Here settings can be configured...</p>
		</div>
		<div class="modal-footer">
			<a href="#" class="btn" data-dismiss="modal">Close</a>
			<a href="#" class="btn btn-primary">Save changes</a>
		</div>
	</div>
                </div>
              </div>
            </div>
            
            
          </div>
        </div>
      </div>
      
            <?php include "right-side.php";?>

    </div>
    <?php include'footer.php';?>
	<script src="js/jquery-1.9.1.min.js"></script>
	<script>
        $(document).ready(function() {
         $("#status option[value='<?php echo $rw_cms->status; ?>']").attr("selected", "selected");
         });
     </script>
     <script src="js/chosen.jquery.min.js" type="text/javascript"></script>
  <script src="docsupport/prism.js" type="text/javascript" charset="utf-8"></script>
  <script type="text/javascript">
    var config = {
      '.chosen-select'           : {},
      '.chosen-select-deselect'  : {allow_single_deselect:true},
      '.chosen-select-no-single' : {disable_search_threshold:10},
      '.chosen-select-no-results': {no_results_text:'Oops, nothing found!'},
      '.chosen-select-width'     : {width:"95%"}
    }
    for (var selector in config) {
      $(selector).chosen(config[selector]);
    }
  </script>