1#@!#!123s

: / home / epksuofuukz9 / www / admin / php /
Filename : add_menu_post.php
back
<?php
 session_start();
 include("../includes/functions.php");
 $status=$_POST['status'];
 $meta_title=escape($_POST['meta_title']);
 $slug_url=$_POST['slug_url'];
 $meta_keywords=escape($_POST['meta_keywords']);
 $meta_description=escape($_POST['meta_description']);
 $course_name=escape($_POST['new_course']);
 $course_desc=escape($_POST['course_desc']);
 $present_date=date('Y-m-d');
 $location=$_POST['location'];
 $menu_script_tag=$_POST['menu_script_tag'];
 
 $cover_image= $_FILES['cover_image']['name'];
 $cover_image_temp= $_FILES['cover_image']['tmp_name'];
 move_uploaded_file($cover_image_temp, "../images/menu/cover_image/$cover_image");

 $courses_menu_name=escape($_POST['courses_menu_name']);
 $courses_menu_image= $_FILES['courses_menu_image']['name'];
 $courses_menu_image_temp= $_FILES['courses_menu_image']['tmp_name'];
 move_uploaded_file($courses_menu_image_temp, "../images/menu/courses/$courses_menu_image");

 $ratings=$_POST['ratings'];
 $lectures=$_POST['lectures'];
 $duration=$_POST['duration'];
 $skill_level=$_POST['skill_level'];
 $language=$_POST['language'];
 $students=$_POST['students'];
 $assessments=$_POST['assessments'];

 $add_more=$_POST['addmore'];
 $placement_profession=$_POST['placement_profession'];
 $count_add_more=count($add_more);

 $placement_image1=$_FILES['placement_image']['name'];

for ($a=0; $a <$count_add_more ; $a++) { 
	$placement_image= $_FILES['placement_image']['name'][$a];
 	$placement_image_temp= $_FILES['placement_image']['tmp_name'][$a];
 	move_uploaded_file($placement_image_temp, "../images/menu/placement/$placement_image");
}
 
 $addmore1=$_POST['addmore1'];
 $company_name=$_POST['company_name'];
 $company_review=$_POST['company_review'];
 $review_image=$_FILES['review_image']['name'];
 $review_image1= $_FILES['review_image']['name'];
 $count_addmore1=count($addmore1);

 for ($b=0; $b <$count_addmore1 ; $b++) { 
	$review_image= $_FILES['review_image']['name'][$b];
 	$review_image_temp= $_FILES['review_image']['tmp_name'][$b];
 	move_uploaded_file($review_image_temp, "../images/menu/review/$review_image");
}
 $insert_post="INSERT INTO `menu_course`( `menu_course_meta_title`, `menu_course_slug_url`, `menu_course_meta_description`, `menu_course_meta_keywords`, `menu_course_course_name`, `menu_course_cover_images`, `menu_course_courses_name`,`menu_course_courses_images`, `menu_course_ratings`,`menu_course_lectures`, `menu_course_duration`, `menu_course_skill_level`, `menu_course_language`, `menu_course_students`, `menu_course_assessments`, `menu_course_description`, `menu_course_date`,`menu_course_status`,`menu_course_location`,`menu_script_tag`) VALUES ('$meta_title','$slug_url','$meta_description','$meta_keywords','$course_name','$cover_image','$courses_menu_name','$courses_menu_image','$ratings','$lectures','$duration','$skill_level','$language','$students','$assessments','$course_desc','$present_date','$status','$location','$menu_script_tag')";
 $run_insert_post=query($insert_post);
 confirm($run_insert_post);
 $course_id=insert_id();

 for ($i=0; $i < $count_add_more; $i++) { 
 	if(!empty($add_more[$i]))
 	{
 	$insert_placement="INSERT INTO `menu_course_placement`(`menu_placement_menu_course_id`, `menu_placement_name`, `menu_placement_profession`,`menu_placement_image`) VALUES ('$course_id','$add_more[$i]','$placement_profession[$i]','$placement_image1[$i]')";
 	$run_placement=query($insert_placement);
 	confirm($run_placement);
 }
 }
 for ($j=0; $j < $count_addmore1; $j++) {
 if(!empty($add_more1[$j]))
 	{ 
 	$insert_review="INSERT INTO `menu_course_review`(`menu_review_menu_course_id`, `menu_review_name`, `menu_review_company_name`, `menu_review_review`,`menu_review_image`) VALUES ('$course_id','$addmore1[$j]','$company_name[$j]','$company_review[$j]','$review_image1[$j]')";
 	$run_review=query($insert_review);
 	confirm($run_review);
 }
 }

 if($run_insert_post)
 {
	 echo "<script>alert('New Menu has been Added');</script>";
	 echo "<script>window.open('../view_all_menu.php','_self');</script>";
 }

?>