0 && $_FILES['photo']['error']==''){ $photo=time().substr($_FILES['photo']['name'],-5); $target_file = $_FILES['photo']['tmp_name']; $destination_file = "images/chef/".$photo; $upload_status = ftp_put($conn_id, $destination_file, $target_file, FTP_BINARY); if (!$upload_status) { $photo = ''; } //move_uploaded_file($_FILES['photo']['tmp_name'], WEBSITE_SITE_URL."images/chef/".$photo); } if($_FILES['video']['size']>0 && $_FILES['video']['error']==''){ $video=time().substr($_FILES['video']['name'],-5); $target_file = $_FILES['video']['tmp_name']; $destination_file = "upload_images/chef/video/".$video; $upload_status = ftp_put($conn_id, $destination_file, $target_file, FTP_BINARY); if (!$upload_status) { $video = ''; } //move_uploaded_file($_FILES['video']['tmp_name'], WEBSITE_SITE_URL."upload_images/chef/video/".$video); } if($_REQUEST['id']==''){ // $obj->query("insert into $tbl_recipe set name='$name', url='$url',image='$photo' ,brand='$brand'"); // $_SESSION['sess_msg']='Press Release added successfully'; }else{ $sql="UPDATE `tbl_recipe` SET `recipe_name`='$title',`category`='$category', `description`='$about',`tags`='$tags',`veg_non_veg`='$veg_array',`variation`='$variation', `serve_qty`='$serve_qty',`prepretion_time`='$prep',`cooking_time`='$cooking',`recipe_type`='$course', `pre_method`='$prep_array',`holiday_special`= '$holiday_array',`additional_note`='$add_array', health_benifits = '$health_benifits', recipe_notes = '$recipe_notes', pre_cooking_tips = '$pre_cooking_tips', nutrition = '$nutrition' "; // echo $sql; // exit; if(isset($photo)){ $imageArr=$obj->query("select photo from tbl_recipe where id='".$_REQUEST['id']."' "); $resultImage=$obj->fetchNextObject($imageArr); @unlink(WEBSITE_SITE_URL."images/chef/".$resultImage->photo); $sql.=" ,photo='$photo' "; } if(isset($video)){ $videoArr=$obj->query("select video from tbl_recipe where id='".$_REQUEST['id']."' "); $resultVideo=$obj->fetchNextObject($videoArr); @unlink(WEBSITE_SITE_URL."upload_images/chef/video/".$resultImage->video); $sql.=" ,video='$video' "; } $sql.=" where id='".$_REQUEST['id']."'"; $obj->query($sql); $sqldelS = $obj->query("DELETE FROM `tbl_recipe_step` WHERE recipe_id ='".$_REQUEST['id']."'"); if($step_count > 0) { for($i=0; $i<$step_count; $i++) { if(trim($_POST["step"][$i] != '')) { $step = $_POST["step"][$i]; $step_image = ''; if($_FILES['step_image']['size'][$i]>0 && $_FILES['step_image']['error'][$i]==''){ $step_image = time().substr($_FILES['step_image']['name'][$i],-5); $target_file = $_FILES['step_image']['tmp_name'][$i]; $destination_file = "upload_images/chef/step/".$step_image; $upload_status = ftp_put($conn_id, $destination_file, $target_file, FTP_BINARY); if (!$upload_status) { $step_image = ''; } //move_uploaded_file($_FILES['step_image']['tmp_name'][$i], WEBSITE_SITE_URL."upload_images/chef/step/".$step_image); } else if(!empty($_POST['step_image_old'][$i])){ $step_image = $_POST['step_image_old'][$i]; } $sql = $obj->query("INSERT INTO `tbl_recipe_step`(`recipe_id`, `step`, step_image) VALUES ('".$_REQUEST['id']."','$step', '$step_image')"); } } } // $sqldelI = $obj->query("DELETE FROM `tbl_recipe_ingredients` WHERE recipe_id ='".$_REQUEST['id']."'"); // $sqldelS = $obj->query("DELETE FROM `tbl_recipe_map_products` WHERE recipe_id ='".$_REQUEST['id']."'"); if ($pname_count > 0) { for ($j=0; $j < $pname_count; $j++) { $pname = $_POST["pname"][$j]; $qty_p = $_POST["qty_p"][$j]; $qtype = $_POST["qtype"][$j]; $product_id = $_POST["q_id"][$j]; $ingredient_id = $_POST["ingredient_id"][$j]; // $sql = $obj->query("INSERT INTO `tbl_recipe_ingredients`(`recipe_id`, `product_id`,`product_name`, `qty`, `qty_type`) // VALUES ('".$_REQUEST['id']."', '$product_id','$pname','$qty_p','$qtype')"); // $ingredients_id=$obj->lastInsertedId(); $checkdata=$obj->query("select * from tbl_recipe_ingredients where product_name='".$pname."' and recipe_id='".$_REQUEST['id']."'"); $row=$obj->fetchNextObject($checkdata); if($row->product_name==$pname) { $sql = $obj->query("UPDATE `tbl_recipe_ingredients` SET `recipe_id`='".$_REQUEST['id']."', `product_id`='$product_id',`product_name`= '$pname',`qty`='$qty_p',`qty_type`='$qtype' WHERE id='".$ingredient_id."'"); } else { $sql = $obj->query("INSERT INTO `tbl_recipe_ingredients`(`recipe_id`, `product_id`,`product_name`, `qty`, `qty_type`) VALUES ('".$_REQUEST['id']."', '$product_id','$pname','$qty_p','$qtype')"); } $psearch = $_POST["psearch"][$j]; $pids = $_POST["pids"][$j]; $map_id = $_POST["map_id"][$j]; if($map_id == ''){ $sql = $obj->query("INSERT INTO `tbl_recipe_map_products`(`recipe_id`,`ingredients_id`, `product_id`,`product_name`) VALUES ('".$_REQUEST['id']."','".$ingredient_id."','$pids','$psearch')"); }else{ $sql = $obj->query("UPDATE `tbl_recipe_map_products` SET `recipe_id`='".$_REQUEST['id']."', `ingredients_id`='".$ingredient_id."',`product_id`= '$pids',`product_name`='$psearch' WHERE id='".$map_id."'"); } } } $obj->query("delete from tbl_recipe_nutrition where recipe_id='" . $_REQUEST['id'] . "'"); if ($nutrition_name_count >= 0) { for ($k = 0; $k < $nutrition_name_count; $k++) { $nutrition_value = $_POST["nutrition_value"][$k]; $nutrition_name = $_POST["nutrition_name"][$k]; $checkdata = $obj->query("select * from tbl_recipe_nutrition where nutrition_name='" . $nutrition_name . "' and recipe_id='" . $_REQUEST['id'] . "'"); $row = $obj->fetchNextObject($checkdata); $sql = $obj->query("INSERT INTO `tbl_recipe_nutrition`(`recipe_id`, `nutrition_name`,`nutrition_value`) VALUES ('" . $_REQUEST['id'] . "', '$nutrition_name','$nutrition_value')"); } } $_SESSION['sess_msg']='Recipe updated successfully'; } header("location:recipe-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select * from tbl_recipe where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?> <?php echo SITE_TITLE; ?>
Admin: AddUpdate Recipe
Recipe Title
Tell us about your recipe
Select Category
Tags
INGREDIENTS query("SELECT * FROM `tbl_recipe_ingredients` where `recipe_id`='".$_REQUEST['id']."'"); $reccnt3=$obj->numRows($sql3); $w=1; while($row=$obj->fetchNextObject($sql3)) {?>


query("SELECT * FROM `tbl_recipe_map_products` where `recipe_id`='".$_REQUEST['id']."' and ingredients_id = '$row->id'"); $reccnt14=$obj->numRows($sql14); $row14=$obj->fetchNextObject($sql14); ?>
Steps query("SELECT * FROM `tbl_recipe_step` where `recipe_id`='".$_REQUEST['id']."'"); $reccnt5=$obj->numRows($sql5); $w= 1; while($row=$obj->fetchNextObject($sql5)) {?>
step_image)) {?> step_image)) {?>
  Remove
Recipe Tips or variations
Share a photo of your recipe photo)) {?> photo)) {?>
Share a video of your recipe video)) {?> video)) {?>
  Remove
Quantity serve
prepration time
Cooking time
Choose Your Recipe's
Veg/ Non Veg

veg_non_veg==1) { ?> checked="checked" > Veg

veg_non_veg==0) { ?> checked="checked" > Non Veg
Health Benefits Of The Recipe
Notes For Recipe
Pro Cooking Tips For Recipe
Nutrition
Nutrition Type List query("SELECT * FROM `tbl_recipe_nutrition` where `recipe_id`='" . $_REQUEST['id'] . "'"); $recentnutrition = $obj->numRows($sqlnutrition); $w = 1; while ($row = $obj->fetchNextObject($sqlnutrition)) { ?>
:
Choose Your Recipes Prep Methodp

(Select all that apply)

 pre_method); $sql5=$obj->query("SELECT * from tbl_chef_prep where status='1'"); $reccnt5=$obj->numRows($sql5); while($row=$obj->fetchNextObject($sql5)) { $id = $row->id; ?>

> name;?>
Choose A Holiday for your recipe

(Select all that apply)

 holiday_special); $sql5=$obj->query("SELECT * from tbl_chef_holiday where status='1'"); $reccnt5=$obj->numRows($sql5); while($row=$obj->fetchNextObject($sql5)) { $id = $row->id; ?>

> name;?>
Choose Additionl lable for your recipe

(Select all that apply)

 additional_note); $sql5=$obj->query("SELECT * from tbl_chef_additional where status='1'"); $reccnt5=$obj->numRows($sql5); while($row=$obj->fetchNextObject($sql5)) { $id = $row->id; ?>

> name;?>