<?php
include_once("session.php");
include_once("settings.php");
foreach ($_REQUEST as $key => $value){
	$$key = $value;
}
$Catgory_Description=addslashes($Catgory_Description);
$target_path = "../cat_images/recipe/";
$prefix=time();
$target_path = $target_path . basename($prefix.$_FILES['image']['name']);
if($_REQUEST['mode']=="Edit"){	
    $recipe_key = sanitize_data(@$Category_Name);
	if($_FILES['image']['name']!=""){
		if(move_uploaded_file($_FILES['image']['tmp_name'], $target_path)) {
			chmod($target_path,0777); 
			//echo "The file ". basename( $_FILES['file']['name']). " has been uploaded";
			$upload_image=basename($prefix.$_FILES['image']['name']);				
		}
		$sql	=	"update `tblRecipe` set `Category_Name`='$Category_Name',`recipe_key`='$recipe_key',`Category_Description`='".mysql_real_escape_string($Category_Description)."',`Category_Image`='$upload_image',`Species_Id`='$recipeCate',`Status`='$status',`featured_status`='$featured_status' where `Category_Id`='$id'";
	}
	else{
		$sql	=	"update  `tblRecipe` set `Category_Name`='$Category_Name',`recipe_key`='$recipe_key',`Category_Description`='".mysql_real_escape_string($Category_Description)."',`Species_Id`='$recipeCate',`Status`='$status',`featured_status`='$featured_status' where `Category_Id`='$id'";
	}	
}
else{

    $recipe_key = sanitize_data(@$Category_Name);
	
	if($_FILES['image']['name']!=""){
		if(move_uploaded_file($_FILES['image']['tmp_name'], $target_path)) {
			chmod($target_path,0777); 
			//echo "The file ". basename( $_FILES['file']['name']). " has been uploaded";
			$upload_image=basename($prefix.$_FILES['image']['name']);				
		}		
	}
	$sql	=	"insert into `tblRecipe` (`Category_Name`,`recipe_key`,`Species_Id`,`Category_Image`,`Category_Description`,`Status`,`featured_status`) value ('$Category_Name','$recipe_key','$recipeCate','$upload_image', '".mysql_real_escape_string($Category_Description)."','$status','$featured_status')";
}
$result	=	mysql_query($sql) or die(mysql_error());
?>
<script>
document.location="recipeProd_list.php?page=listRecipeProduct"
</script>