23 lines
729 B
PHP
23 lines
729 B
PHP
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
$sub_cat_id=$_POST['sub_cat_id'];
|
||
|
|
$cat_id= $_POST['cat_id'];
|
||
|
|
$sub_cat_name = $_POST['sub_cat_name'];
|
||
|
|
$remarks = $_POST['remarks'];
|
||
|
|
$status =$_POST['status'];
|
||
|
|
|
||
|
|
$query="";
|
||
|
|
if(!empty($sub_cat_id)){
|
||
|
|
$query = "update sub_category set cat_id ='$cat_id',sub_cat_name='$sub_cat_name',remarks ='$remarks',status='$status',modified_by = '".$_SESSION['user_id']."' where sub_cat_id =
|
||
|
|
'".$sub_cat_id."'";
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
$query = "insert into sub_category(cat_id,sub_cat_name,remarks,status,modified_by)
|
||
|
|
values ('$cat_id','$sub_cat_name','$remarks','$status ','".$_SESSION['user_id']."' )";
|
||
|
|
}
|
||
|
|
echo $query;
|
||
|
|
if (!$result = @mysqli_query($conn,$query)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
?>
|