bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php

include "dbc.php";

page_protect();

if(isset($_POST['Submit'])){
if($_POST['Submit'] == 'Save')

{

$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'];

$ad_product=$_POST['ad_product'];

$ad_subcat_id=$_POST['ad_subcat_id'];

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

$max=$max+1;

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

$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;

$ins_query = mysqli_query($link,"INSERT INTO `subcategory_tbl`(`subcat_id`,`cat_id`,`subcat_name_tamil`, `subcat_name`, `status`, `home_status`, `created_on`,`sort`,`short_code`,`page_description`,`short_desc`,`seo_id`,`another_product`,`another_subcat_id`) VALUES ('$subcat_id','$cat_id','$subcat_name_tamil', '$subcat_name','$status','$home_status',NOW(),'$sort','$short_code','$page_description','$short_description','$seo_id','$ad_product','$ad_subcat_id')");

$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')");

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

if($img != "")

{

$secondname=rand(0,10000000000);

$uploaddir = "uploads/subcategory/";

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

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

chmod("$upload_pic",0777);

mysqli_query($link,"UPDATE subcat_image 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['img']['tmp_name'], $upload_pic);

chmod("$upload_pic",0777);

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

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

}

$msg[] = "Sucessfully Saved! ";

}

<?php include'header.php';?>

<h3>

<i class="fa fa-plus"></i>&nbsp; Sub Category</a>

</li></h3>

</div>

</header>

</div>

<?php include'admin_admin.php';?>

<style>

.form-control.col-lg-6 {

width: 50% !important;

}

</style>

</div>

<h5>Add Sub Category</h5>

</div>

</header>

<?php include 'msg_display.php'; ?>

<?php

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

$max=$max+1;

$auto="SC".$max."";

<label class="control-label">Sub Category ID</label>

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

</div>

<label class="control-label" for="selectError">Category</label>

<option value="">Please Select  </option>

<?php $sel_category = mysqli_query($link,"select * from category_tbl where status='Active'");					 
                   while($rw_ctegory = mysqli_fetch_object($sel_category)){?>

<?php }?>

</select>

</div>

</div>
           
           <div class="col-md-4">

<label class="control-label">Sub Category Name (Tamil)</label>

</div>

<label class="control-label">Sub Category Name</label>

</div>

</div>
          <div class="col-md-4">

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

</div>

</div>
        
        <div class="col-md-4">

<label class="control-label">Breadcrumb Image</label>

</div>

<label class="control-label">Short Code</label>

</div>

<label class="control-label">Display in page</label>

<input type="checkbox" class="validate[required] input-xlarge" name="home_page" id="home_page" value="1">Home Page

<input type="checkbox" class="validate[required] input-xlarge" name="product_page" id="product_page" value="1">Product Page

</div>

<label class="control-label" for="selectError">Status <span class="required">*</span></label>

<option value="Active" selected>Active</option>

<option value="Disabled">Disabled</option>

</select>

</div>

</div> 
         <div class="col-md-4">

<label class="control-label" for="selectError">Home Status <span class="required">*</span></label>

<option value="Active" selected>Active</option>

<option value="Disabled">Disabled</option>

</select>

</div>

<label class="control-label" for="selectError">Provide with Additional Product<span class="required">*</span></label>

<option value="1" >Active</option>

<option value="0" selected>Disabled</option>

</select>

</div>

<label class="control-label" for="selectError">Select Additional Sub-Category</label>

<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 echo $rw_ctegory2->subcat_name;?> </option>

<?php }?>

</select>

</div>

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

<?php
              list($smax) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(sort) AS max FROM `subcategory_tbl`"));
             
              $smax=$smax+1;

</div>

<label class="control-label">Meta Tag Title <span class="required">*</span></label>

</div>

<label class="control-label">Meta Tag Description </label>

</div>

<label class="control-label">Meta Tag Keywords </label>

</div>

<label class="control-label">Meta Tag News Keywords </label>

</div>

<label class="control-label">Meta Tag Author </label>

</div>

<label class="control-label">Meta Tag Classification </label>

</div>

<label class="control-label">Meta Tag Canonical</label>

</div>

<label class="control-label">OG:Title </label>

</div>

</div>

</div>

</div>

</div>

<label class="control-label">Short Description </label>

</div>

</div>
        
          <div class="col-md-12">

<label class="control-label">Page Description </label>

</div>

<br>

</div>

</center>

</fieldset>

</form>

</div>

</div>

</div>

</div>

<h3>Settings</h3>

</div>

<p>Here settings can be configured...</p>

</div>

<a href="#" class="btn" data-dismiss="modal">Close</a>

<a href="#" class="btn btn-primary">Save changes</a>

</div>

</div>

</div>

</div>

<?php include "right-side.php";?>

</div>

<?php include'footer.php';?>