bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php
include "dbc.php"; 
page_protect();
srand((double) microtime( ) *1000000);
$random=rand();
$autoidcolor=$random;
if(isset($_POST['Submit'])){
if($_POST['Submit'] == 'Save') 	
{
  $id = $_POST['id'];
  $cat_id = $_POST['cat_id'];
  $subcat_id = $_POST['subcat_id'];
  $subcat_name_tamil = $_POST['subcat_name_tamil']; 
  $subcat_name = $_POST['subcat_name']; 
  $status = $_POST['status'];
  $home_status = $_POST['home_status'];
  $sort = $_POST['sort'];
  $short_code = $_POST['short_code'];

$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'];
  $short_description = $_POST['short_description'];
  $seo_id = $_POST['seo_id'];
$ad_subcat_id=$_POST['ad_subcat_id'];
$ad_product=$_POST['ad_product'];

$sel_cat = mysqli_query($link,"select cat_name from category_tbl where cat_id='$cat_id'");
  $rw_cat = mysqli_fetch_object($sel_cat);

$result_category = strtolower($rw_cat->cat_name);
  $category_page = strtolower(str_replace(" ","-",$result_category));

$result_subcategory = strtolower($subcat_name);
  $subcategory_page = strtolower(str_replace(" ","-",$result_subcategory));

$page = $category_page."/".$subcategory_page;

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`,`subcat_id`) VALUES (NOW(), '$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','$subcat_id')");

}
else
{
    $ins_query = mysqli_query($link,"UPDATE `seo` SET `date`=NOW(), `page`='$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',`subcat_id`='$subcat_id', `status`='$status' WHERE seo_id='$seo_id'");

}
  $update_cms = mysqli_query($link,"UPDATE `subcategory_tbl` SET `cat_id`='$cat_id',`subcat_name_tamil`='$subcat_name_tamil',`subcat_name`='$subcat_name',`status`='$status',`home_status`='$home_status',`sort`='$sort',another_product='$ad_product',another_subcat_id='$ad_subcat_id',`short_code`='$short_code',page_description='$page_description',short_desc='$short_description',seo_id='$seo_id' WHERE `subcat_id`='$subcat_id'");

$img = $_FILES['img']['name'];

if($img != "")

{

$secondname=rand(0,10000000000);

$uploaddir = "uploads/subcategory/";

$upload_pic = $uploaddir.$secondname.$img;

copy($_FILES['img']['tmp_name'], $upload_pic);

chmod("$upload_pic",0777);

mysqli_query($link,"UPDATE subcategory_tbl SET `img` = '$upload_pic' WHERE subcat_id ='$subcat_id'");

$msg[] = "Image Uploaded Sucess! ";

}
  
    
  $upload_picture = $_FILES['upload_picture']['name'];
  if($upload_picture != "")
  {	
    $secondname=rand(0,10000000000);
    $uploaddir = "uploads/subcategory/";
    $upload_pic = $uploaddir.$secondname.$upload_picture;			
    copy($_FILES['upload_picture']['tmp_name'], $upload_pic);
    chmod("$upload_pic",0777);
    mysqli_query($link,"UPDATE subcategory_tbl SET `subcat_image` = '$upload_pic' WHERE subcat_id ='$subcat_id'");
    $msg[] = "Image Uploaded Sucess! "; 
  }	
  $msg[] = "Sucessfully Updated! ";
}
}
?>
<?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-edit"></i>&nbsp; Update Sub 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>

</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>Sub 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']; ?>
               <?php
               $sel_cms = mysqli_query($link,"select * from subcategory_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);

?>
               <div class="col-md-4">
                <div class="control-group">
                  <label class="control-label">Sub Category ID</label>
                  <div class="controls">

<input name="id" id="id" type="hidden" value="<?php echo $rw_cms->id; ?>" >
                    <input class="form-control" name="subcat_id" id="subcat_id" type="text" value="<?php echo $rw_cms->subcat_id; ?>" readonly>
                    <input class="form-control" name="seo_id" id="seo_id" type="hidden" value="<?php echo $rw_cms->seo_id; ?>" readonly>

</div>
                </div>
              </div>
              <div class="col-md-4">
               <div class="control-group">
                <label class="control-label" for="selectError">Category</label>
                <div class="controls">
                  <?php $cat_id1 = $rw_cms->cat_id;?>
                  <select name="cat_id" id="cat_id" class="form-control" required >
                    <?php $sel_category = mysqli_query($link,"select * from category_tbl where status='Active'");					 while($rw_ctegory = mysqli_fetch_object($sel_category)){?>
                    <option value="<?php echo $rw_ctegory->cat_id;?>" <?php if($cat_id1==$rw_ctegory->cat_id) { echo 'selected="selected"';}?> ><?php echo $rw_ctegory->cat_name;?> </option>

<?php }?>
                  </select>
                </div>
              </div>
            </div>
            <div class="col-md-4">
             <div class="control-group">
              <label class="control-label">Sub Category Name (Tamil)</label>
              <div class="controls">
                <input type="text" class="validate[required] form-control" name="subcat_name_tamil" id="subcat_name_tamil" required value="<?php echo $rw_cms->subcat_name_tamil;?>">
              </div>
            </div>
          </div>
          <div class="col-md-4">
             <div class="control-group">
              <label class="control-label">Sub Category Name</label>
              <div class="controls">
                <input type="text" class="validate[required] form-control" name="subcat_name" id="subcat_name" required value="<?php echo $rw_cms->subcat_name;?>">
              </div>
            </div>
          </div>
          <div class="col-md-4">

<label class="control-label">Image <span class="required">*</span></label>

<input type="file" name="img" id="fileUpload" class="validate[required] form-control" ><br>
                <img src="<?php echo $rw_cms->img; ?>" height="100">
            </div>

</div>

</div>
        
        <div class="col-md-4">
            <div class="control-group">
              <label class="control-label">Breadcrumb Image</label>
              <div class="controls">
                <input type="file" name="upload_picture" id="fileUpload" class="form-control"><br>
                <img src="<?php echo $rw_cms->subcat_image; ?>" height="100">
                
              </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" for="selectError">Provide with Additional Product<span class="required">*</span></label>
              <div class="controls">
			  <?php $a_product = $rw_cms->another_product;?>
                <select name="ad_product" id="ad_product" class="form-control" required >
                 <option value="1" <?php if($a_product== '1') { echo 'selected="selected"';}?>>Active</option>
                 <option value="0" <?php if($a_product== '0') { echo 'selected="selected"';}?>>Disabled</option>
               </select>
             </div>
           </div>
         </div>
		 
		   <div class="col-md-4">							  
               <div class="control-group">
                <label class="control-label" for="selectError">Select Additional Sub-Category</label>
                <div class="controls">
				 <?php $acat_id = $rw_cms->another_subcat_id;?>
                  <select id="selectError" data-rel="chosen" name="ad_subcat_id" class="form-control">
                   <option value="">Please Select  </option>
                   <?php $sel_category2= mysqli_query($link,"select * from subcategory_tbl where status='Active'");					 while($rw_ctegory2 = mysqli_fetch_object($sel_category2)){?>
                   <option value="<?php echo $rw_ctegory2->subcat_id;?>" <?php if($acat_id== $rw_ctegory2->subcat_id) { echo 'selected="selected"';}?>><?php echo $rw_ctegory2->subcat_name;?> </option>
                   <?php }?>
                 </select>
               </div>
             </div>
           </div>
          <div class="clearfix"></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" for="selectError">Home Status <span class="required">*</span></label>
              <div class="controls">
                <select name="home_status" id="home_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-12">

<div class="control-group">
            <label class="control-label">Short Description </label>
            <div class="controls">
              <textarea name="short_description" id="short_description" class="ckeditor" rows="5" cols="50"><?php echo $rw_cms->short_desc; ?></textarea>
            </div>
          </div>
        </div>
         <div class="col-md-12">

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

</div>
    </div>

</fieldset>
</form>

</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() {
   $("#cat_id option[value='<?php echo $cat_id1; ?>']").attr("selected", "selected");
   $("#status option[value='<?php echo $rw_cms->status; ?>']").attr("selected", "selected");
   $("#home_status option[value='<?php echo $rw_cms->home_status; ?>']").attr("selected", "selected");
 });
</script>