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

$childcat_id = $_POST['childcat_id'];
  
  $childcat_name_tamil = $_POST['childcat_name_tamil'];

$childcat_name = $_POST['childcat_name'];

$status = $_POST['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'];

$seo_id = $_POST['seo_id'];

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

$sel_subcategory = mysqli_query($link,"select subcat_name from subcategory_tbl where subcat_id='$subcat_id'");

$rw_subcategory = mysqli_fetch_object($sel_subcategory);

$result_subcategory = strtolower($rw_subcategory->subcat_name);

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

$result_childcategory = strtolower($childcat_name);

$childcategory_page = strtolower(str_replace(" ","-",$result_childcategory));

$page = $category_page."/".$subcategory_page."/".$childcategory_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`,`childcat_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','$childcat_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',`childcat_id`='$childcat_id', `status`='$status' WHERE seo_id='$seo_id'");

}

$update_cms = mysqli_query($link,"UPDATE `childcategory_tbl` SET `cat_id`='$cat_id',`subcat_id`='$subcat_id',`childcat_name_tamil`='$childcat_name_tamil',`childcat_name`='$childcat_name',`status`='$status',`sort`='$sort',`short_code`='$short_code',page_description='$page_description',seo_id='$seo_id' WHERE childcat_id='$childcat_id'");

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

if($upload_picture != "")

{

$secondname=rand(0,10000000000);

$uploaddir = "uploads/childcategory/";

$upload_pic = $uploaddir.$secondname.$upload_picture;

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

chmod("$upload_pic",0777);

mysqli_query($link,"UPDATE childcategory_tbl SET `childcat_image` = '$upload_pic' WHERE childcat_id ='$childcat_id'");

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

}

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

if($breadcrumb_img != "")

{

$secondname=rand(0,10000000000);

$uploaddir = "uploads/childcategory/";

$upload_pic1 = $uploaddir.$secondname.$breadcrumb_img;

copy($_FILES['breadcrumb_img']['tmp_name'], $upload_pic1);

chmod("$upload_pic1",0777);

mysqli_query($link,"UPDATE childcategory_tbl SET `breadcrumb_img` = '$upload_pic1' WHERE childcat_id ='$childcat_id'");

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

}

$msg[] = "Sucessfully Updated! ";

}

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

<h3>

<i class="fa fa-edit"></i>&nbsp; Update Child Category</h3>

</div>

</header>

</div>

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

<style>

.form-control.col-lg-6 {

width: 50% !important;

}

</style>

</div>

</div>

</header>

<?php $id = $_GET['id']; ?>

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

<h2><i class="halflings-icon edit"></i><span class="break"></span>Child Category Details</h2>

</div>

<?php

$sel_cms = mysqli_query($link,"select * from childcategory_tbl where id='$id'");

$rw_cms = mysqli_fetch_object($sel_cms);

$seo_id = $rw_cms->seo_id;

// print_r($rw_cms);

$sel_seo = mysqli_query($link,"select * from seo where seo_id='$seo_id'");

$rw_seo = mysqli_fetch_object($sel_seo);

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

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

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

</div>

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

<option>Please Select</option>

<?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($rw_ctegory->cat_id==$rw_cms->cat_id){ echo "selected";}?>><?php echo $rw_ctegory->cat_name;?> </option>

<?php }?>

</select>

</div>

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

<?php $subcat_id = $rw_cms->subcat_id;?>

<option>Please Select</option>

<?php $sel_category1 = mysqli_query($link,"select * from subcategory_tbl where status='Active'");					 
                 while($rw_ctegory1 = mysqli_fetch_object($sel_category1)){?>

<option value="<?php echo $rw_ctegory1->subcat_id;?>" <?php if($rw_ctegory1->subcat_id==$rw_cms->subcat_id){ echo "selected";} ?>>
                  <?php echo $rw_ctegory1->subcat_name;?> </option>

<?php }?>

</select>

</div>

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

<input type="text" class="validate[required] form-control" name="childcat_name_tamil" id="childcat_name_tamil" required value="<?php echo $rw_cms->childcat_name_tamil;?>">

</div>

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

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

<input type="text" class="validate[required] form-control" name="childcat_name" id="childcat_name" required value="<?php echo $rw_cms->childcat_name;?>">

</div>

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

<input type="text" class="validate[required] form-control" name="short_code" id="short_code" required value="<?php echo $rw_cms->short_code;?>">

</div>

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

<img src="<?php echo $rw_cms->childcat_image; ?>" class="img-circle" width="100" height="100">

</div>

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

<img src="<?php echo $rw_cms->breadcrumb_img; ?>" height="100">

</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>

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

</div>

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

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

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

</div>

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

<textarea rows="3" class="form-control" name="meta_keyword" id="meta_keyword" placeholder="Meta Tag Keywords"><?php echo $rw_seo->meta_keyword; ?></textarea>

</div>

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

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

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

<textarea rows="3" class="form-control" name="meta_author" id="meta_author" placeholder="Meta Tag Author"><?php echo $rw_seo->meta_author; ?></textarea>

</div>

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

<textarea rows="3" class="form-control" name="meta_classification" id="meta_classification" placeholder="Meta Tag Classification"><?php echo $rw_seo->meta_classification; ?></textarea>

</div>

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

<textarea rows="3" class="form-control" name="canonical" id="canonical" placeholder="Meta Tag Canonical"><?php echo $rw_seo->canonical; ?></textarea>

</div>

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

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

<input type="text" name="og_sitename" id="og_sitename" class="validate[required] form-control" value="<?php echo $rw_seo->og_sitename; ?>">

</div>

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

<textarea name="page_description" id="page_description" class="form-control" rows="5" cols="50"><?php echo $rw_cms->page_description; ?></textarea>

</div>

<br>

</div>

</center>

</div>

</div>

</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>

</div>

</div>

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

</div>

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

$(document).ready(function() {

$("#cat_id option[value='<?php echo $cat_id1; ?>']").attr("selected", "selected");

$("#subcat_id option[value='<?php echo $subcat_id1; ?>']").attr("selected", "selected");

$("#status option[value='<?php echo $rw_cms->status; ?>']").attr("selected", "selected");

});

</script>