alert('Category created successfully...'); location.replace('category.php'); "; } } else{ echo " "; } } else{ echo " "; } } else{ echo " "; } } /*if(isset($_POST['update'])) { //var_dump($_FILES);exit(); extract($_POST); $id=$_POST["cat_id"]; $sql1 ="UPDATE category SET cat_name='$cat_name' WHERE id='$id'"; $res=mysqli_query($conn,$sql1) or die(mysqli_error()); if($res){ $sqlg = "SELECT * from category where id = $id"; $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error()); $resg = mysqli_fetch_object($resultg); if($_FILES["cat_img"]["name"] != ""){ $oname=$_FILES["cat_img"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["cat_img"]["tmp_name"]; $path = "product/category/".$resg->id.'32'.'.'.$extension; $upath = "product/category/".$resg->cat_image; unlink($upath); move_uploaded_file($tn,$path); $image = $resg->id.'32'.'.'.$extension; } else { $image = $resg->cat_image; } if($_FILES["cat_banner_imag"]["name"] != ""){ $oname=$_FILES["cat_banner_imag"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["cat_banner_imag"]["tmp_name"]; $path = "product/category/".$resg->id.'66'.'.'.$extension; $upath = "product/category/".$resg->cat_banner; unlink($upath); move_uploaded_file($tn,$path); $image_bn = $resg->id.'66'.'.'.$extension; } else { $image_bn = $resg->cat_banner; } $sqlup = "UPDATE category SET cat_image = '$image', cat_banner = '$image_bn' WHERE id = $resg->id"; $resultup = mysqli_query($conn,$sqlup) or die(mysqli_error()); } } */ if(isset($_POST['update'])) { //var_dump($_FILES);exit(); extract($_POST); $id=$_POST["cat_id"]; $category_old_page = strtolower(str_replace(" ", "-", $cat_name_old)); $category_new_page = strtolower(str_replace(" ", "-", $cat_name)); if(!file_exists('../'.$category_new_page)) { if(file_exists('../'.$category_old_page)){ if(rename("../$category_old_page", "../$category_new_page")){ if(rename("../$category_new_page/".strtolower(str_replace(" ", "-", $cat_name_old)).".php", "../$category_new_page/".strtolower(str_replace(" ", "-", $cat_name)).".php")){ $sql1 ="UPDATE category SET cat_name='$cat_name' WHERE id='$id'"; $res=mysqli_query($conn,$sql1) or die(mysqli_error()); if($res){ $sqlg = "SELECT * from category where id = $id"; $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error()); $resg = mysqli_fetch_object($resultg); if($_FILES["cat_img"]["name"] != ""){ $oname=$_FILES["cat_img"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["cat_img"]["tmp_name"]; $path = "product/category/".$resg->id.'32'.'.'.$extension; $upath = "product/category/".$resg->cat_image; unlink($upath); move_uploaded_file($tn,$path); $image = $resg->id.'32'.'.'.$extension; } else { $image = $resg->cat_image; } if($_FILES["cat_banner_imag"]["name"] != ""){ $oname=$_FILES["cat_banner_imag"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["cat_banner_imag"]["tmp_name"]; $path = "product/category/".$resg->id.'66'.'.'.$extension; $upath = "product/category/".$resg->cat_banner; unlink($upath); move_uploaded_file($tn,$path); $image_bn = $resg->id.'66'.'.'.$extension; } else { $image_bn = $resg->cat_banner; } $sqlup = "UPDATE category SET cat_image = '$image', cat_banner = '$image_bn' WHERE id = $resg->id"; $resultup = mysqli_query($conn,$sqlup) or die(mysqli_error()); } } else{ echo " "; } } } else{ if(mkdir('../'.$category_new_page, 0777, true)){ if(copy('../includes/css.php', '../'.$category_new_page.'/css.php') && copy('../includes/js.php', '../'.$category_new_page.'/js.php') && copy('../includes/header.php', '../'.$category_new_page.'/header.php') && copy('../includes/footer.php', '../'.$category_new_page.'/footer.php') && copy('../includes/db_config.php', '../'.$category_new_page.'/db_config.php') && copy('../item.php', '../'.$category_new_page.'/'.$category_new_page.'.php') ){ $sql1 ="UPDATE category SET cat_name='$cat_name' WHERE id='$id'"; $res=mysqli_query($conn,$sql1) or die(mysqli_error()); if($res){ $sqlg = "SELECT * from category where id = $id"; $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error()); $resg = mysqli_fetch_object($resultg); if($_FILES["cat_img"]["name"] != ""){ $oname=$_FILES["cat_img"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["cat_img"]["tmp_name"]; $path = "product/category/".$resg->id.'32'.'.'.$extension; $upath = "product/category/".$resg->cat_image; unlink($upath); move_uploaded_file($tn,$path); $image = $resg->id.'32'.'.'.$extension; } else { $image = $resg->cat_image; } if($_FILES["cat_banner_imag"]["name"] != ""){ $oname=$_FILES["cat_banner_imag"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["cat_banner_imag"]["tmp_name"]; $path = "product/category/".$resg->id.'66'.'.'.$extension; $upath = "product/category/".$resg->cat_banner; unlink($upath); move_uploaded_file($tn,$path); $image_bn = $resg->id.'66'.'.'.$extension; } else { $image_bn = $resg->cat_banner; } $sqlup = "UPDATE category SET cat_image = '$image', cat_banner = '$image_bn' WHERE id = $resg->id"; $resultup = mysqli_query($conn,$sqlup) or die(mysqli_error()); } } else{ echo " "; } } else{ echo " "; } } } else{ $sql1 ="UPDATE category SET cat_name='$cat_name' WHERE id='$id'"; $res=mysqli_query($conn,$sql1) or die(mysqli_error()); if($res){ $sqlg = "SELECT * from category where id = $id"; $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error()); $resg = mysqli_fetch_object($resultg); if($_FILES["cat_img"]["name"] != ""){ $oname=$_FILES["cat_img"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["cat_img"]["tmp_name"]; $path = "product/category/".$resg->id.'32'.'.'.$extension; $upath = "product/category/".$resg->cat_image; unlink($upath); move_uploaded_file($tn,$path); $image = $resg->id.'32'.'.'.$extension; } else { $image = $resg->cat_image; } if($_FILES["cat_banner_imag"]["name"] != ""){ $oname=$_FILES["cat_banner_imag"]["name"]; $pos = strrpos($oname, "."); $extension=substr($oname,$pos+1); $tn = $_FILES["cat_banner_imag"]["tmp_name"]; $path = "product/category/".$resg->id.'66'.'.'.$extension; $upath = "product/category/".$resg->cat_banner; unlink($upath); move_uploaded_file($tn,$path); $image_bn = $resg->id.'66'.'.'.$extension; } else { $image_bn = $resg->cat_banner; } $sqlup = "UPDATE category SET cat_image = '$image', cat_banner = '$image_bn' WHERE id = $resg->id"; $resultup = mysqli_query($conn,$sqlup) or die(mysqli_error()); } echo " "; } } ?> Orange Groceries

Category

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

Add New Category