1#@!#!123s

: / home / epksuofuukz9 / www / admin / php /
Filename : add_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']);
 $menu_name=$_POST['menu_name'];
 $ratings=$_POST['ratings'];
 $course_desc=escape($_POST['course_desc']);
 $present_date=date('Y-m-d');
 $location=$_POST['location'];
 $script_tag=$_POST['script_tag'];
 
 $cover_image= $_FILES['cover_image']['name'];
 $cover_image_temp= $_FILES['cover_image']['tmp_name'];
 move_uploaded_file($cover_image_temp, "../images/cover_image/$cover_image");

 $professor_name=escape($_POST['professor_name']);
 $professor_image= $_FILES['professor_image']['name'];
 $professor_image_temp= $_FILES['professor_image']['tmp_name'];
 move_uploaded_file($professor_image_temp, "../images/professor/$professor_image");

 $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/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/review/$review_image");
}
 $insert_post="INSERT INTO `courses`(`menu_id`,`ratings`,`meta_title`, `slug_url`, `meta_description`, `meta_keywords`, `course_name`, `cover_image`, `professor_name`,`professor_image`, `lectures`, `duration`, `skill_level`, `language`, `students`, `assessments`, `description`, `date`,`status`,`sub_menu_location`,`script_tag`) VALUES ('$menu_name','$ratings','$meta_title','$slug_url','$meta_description','$meta_keywords','$course_name','$cover_image','$professor_name','$professor_image','$lectures','$duration','$skill_level','$language','$students','$assessments','$course_desc','$present_date','$status','$location','$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 `course_placement`(`course_id`, `cp_name`, `cp_profession`,`cp_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 `course_review`(`course_id`, `cr_name`, `cr_company_name`, `cr_review`,`cr_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 Course has been Added');</script>";
	 echo "<script>window.open('../view_posts.php','_self');</script>";
 }
?>