alert('sub Category created successfully...'); location.replace('sub-category.php'); "; } } else{ echo " "; } } else{ echo " "; } } else{ echo " "; } } /*if(isset($_POST['update'])) { //var_dump($_POST);exit(); extract($_POST); $id=$_POST["cat_id"]; $sql1 ="UPDATE sub_category SET category_id='$cat_name',sub_category_name='$subcat_name' WHERE id='$id'"; $res=mysqli_query($conn,$sql1) or die(mysqli_error()); if($res){ $sqlg = "SELECT * from sub_category where id = $id"; $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error()); $resg = mysqli_fetch_object($resultg); if($_FILES["subcat_img"]["name"] != ""){ $oname=$_FILES["subcat_img"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["subcat_img"]["tmp_name"]; $path = "product/subcat/".$resg->id.'12'.'.'.$extension; $upath = "product/subcat/".$resg->sub_categoryimg; unlink($upath); move_uploaded_file($tn,$path); $image = $resg->id.'12'.'.'.$extension; } else { $image = $resg->sub_categoryimg; } if($_FILES["subcat_bnimg"]["name"] != ""){ $oname=$_FILES["subcat_bnimg"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["subcat_bnimg"]["tmp_name"]; $path = "product/subcat/".$resg->id.'89'.'.'.$extension; $upath = "product/subcat/".$resg->subcat_banner; unlink($upath); move_uploaded_file($tn,$path); $image_ban = $resg->id.'89'.'.'.$extension; } else { $image_ban = $resg->subcat_banner; } $sqlup = "UPDATE sub_category SET sub_categoryimg = '$image',subcat_banner='$image_ban' WHERE id = $resg->id"; $resultup = mysqli_query($conn,$sqlup) or die(mysqli_error()); } }*/ if(isset($_POST['update'])) { //var_dump($_FILES); extract($_POST); $id=$_POST["cat_id"]; $cat_name=$_POST["cat_name"]; $sql_cat="SELECT * from category where id='".$cat_name."'"; $exe_cat=mysqli_query($conn,$sql_cat); $res_cat=mysqli_fetch_array($exe_cat); //$category_page=$res_cat['cat_name']; $category_page = strtolower(str_replace(" ", "-", $res_cat['cat_name'])); $subcategory_old_page = strtolower(str_replace(" ", "-", $old_subcat_name)); $subcategory_new_page = strtolower(str_replace(" ", "-", $subcat_name)); //if(!file_exists('../'.$category_new_page)) { if(!file_exists('../'.$category_page.'/'.$subcategory_new_page)){ if(file_exists('../'.$category_page.'/'.$subcategory_old_page)){ if(rename("../$category_page/$subcategory_old_page", "../$category_page/$subcategory_new_page")){ if(rename("../$category_page/$subcategory_new_page/".strtolower(str_replace(" ", "-", $old_subcat_name)).".php", "../$category_page/$subcategory_new_page/".strtolower(str_replace(" ", "-", $subcat_name)).".php")){ $sql1 ="UPDATE sub_category SET category_id='$cat_name',sub_category_name='$subcat_name' WHERE id='$id'"; $res=mysqli_query($conn,$sql1) or die(mysqli_error()); if($res){ $sqlg = "SELECT * from sub_category where id = $id"; $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error()); $resg = mysqli_fetch_object($resultg); if($_FILES["subcat_img"]["name"] != ""){ $oname=$_FILES["subcat_img"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["subcat_img"]["tmp_name"]; $path = "product/subcat/".$resg->id.'12'.'.'.$extension; $upath = "product/subcat/".$resg->sub_categoryimg; unlink($upath); move_uploaded_file($tn,$path); $image = $resg->id.'12'.'.'.$extension; } else { $image = $resg->sub_categoryimg; } if($_FILES["subcat_bnimg"]["name"] != ""){ $oname=$_FILES["subcat_bnimg"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["subcat_bnimg"]["tmp_name"]; $path = "product/subcat/".$resg->id.'89'.'.'.$extension; $upath = "product/subcat/".$resg->subcat_banner; unlink($upath); move_uploaded_file($tn,$path); $image_ban = $resg->id.'89'.'.'.$extension; } else { $image_ban = $resg->subcat_banner; } $sqlup = "UPDATE sub_category SET sub_categoryimg = '$image',subcat_banner='$image_ban' WHERE id = $resg->id"; $resultup = mysqli_query($conn,$sqlup) or die(mysqli_error()); if($resultup){ echo " "; } } } else{ echo " "; } } else{ echo " "; } } else{ if(mkdir('../'.$category_page.'/'.$subcategory_new_page, 0777, true)){ if(copy('../includes/css.php', '../'.$category_page.'/'.$subcategory_new_page.'/css.php') && copy('../includes/js.php', '../'.$category_page.'/'.$subcategory_new_page.'/js.php') && copy('../includes/header.php', '../'.$category_page.'/'.$subcategory_new_page.'/header.php') && copy('../includes/footer.php','../'.$category_page.'/'.$subcategory_new_page.'/footer.php') && copy('../includes/db_config.php', '../'.$category_page.'/'.$subcategory_new_page.'/db_config.php') && copy('../shop-item.php', '../'.$category_page.'/'.$subcategory_new_page.'/'.$subcategory_new_page.'.php') ){ $sql1 ="UPDATE sub_category SET category_id='$cat_name',sub_category_name='$subcat_name' WHERE id='$id'"; $res=mysqli_query($conn,$sql1) or die(mysqli_error()); if($res){ $sqlg = "SELECT * from sub_category where id = $id"; $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error()); $resg = mysqli_fetch_object($resultg); if($_FILES["subcat_img"]["name"] != ""){ $oname=$_FILES["subcat_img"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["subcat_img"]["tmp_name"]; $path = "product/subcat/".$resg->id.'12'.'.'.$extension; $upath = "product/subcat/".$resg->sub_categoryimg; unlink($upath); move_uploaded_file($tn,$path); $image = $resg->id.'12'.'.'.$extension; } else { $image = $resg->sub_categoryimg; } if($_FILES["subcat_bnimg"]["name"] != ""){ $oname=$_FILES["subcat_bnimg"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["subcat_bnimg"]["tmp_name"]; $path = "product/subcat/".$resg->id.'89'.'.'.$extension; $upath = "product/subcat/".$resg->subcat_banner; unlink($upath); move_uploaded_file($tn,$path); $image_ban = $resg->id.'89'.'.'.$extension; } else { $image_ban = $resg->subcat_banner; } $sqlup = "UPDATE sub_category SET sub_categoryimg = '$image',subcat_banner='$image_ban' WHERE id = $resg->id"; $resultup = mysqli_query($conn,$sqlup) or die(mysqli_error()); } } else{ echo " "; } } else{ echo " "; } } } else{ $sqlg = "SELECT * from sub_category where id = $id"; $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error()); $resg = mysqli_fetch_object($resultg); if($_FILES["subcat_img"]["name"] != ""){ $oname=$_FILES["subcat_img"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["subcat_img"]["tmp_name"]; $path = "product/subcat/".$resg->id.'12'.'.'.$extension; $upath = "product/subcat/".$resg->sub_categoryimg; unlink($upath); move_uploaded_file($tn,$path); $image = $resg->id.'12'.'.'.$extension; } else { $image = $resg->sub_categoryimg; } if($_FILES["subcat_bnimg"]["name"] != ""){ $oname=$_FILES["subcat_bnimg"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["subcat_bnimg"]["tmp_name"]; $path = "product/subcat/".$resg->id.'89'.'.'.$extension; $upath = "product/subcat/".$resg->subcat_banner; unlink($upath); move_uploaded_file($tn,$path); $image_ban = $resg->id.'89'.'.'.$extension; } else { $image_ban = $resg->subcat_banner; } $sqlup = "UPDATE sub_category SET sub_categoryimg = '$image',subcat_banner='$image_ban' WHERE id = $resg->id"; $resultup = mysqli_query($conn,$sqlup) or die(mysqli_error()); echo " "; } } ?> Orange Groceries

Sub-Category

S. No Category Sub-Category Sub-Category Image Sub-Category Banner Edit Delete
" class="btn btn-md btn-success edit_data" />

Add New Sub-Category