1#@!#!123s

: / home / epksuofuukz9 / www / admin / php /
Filename : edit_post.php
back
<?php
 session_start();
 include("../includes/functions.php");

 $the_id=$_GET['edit'];

$get_course_detail="SELECT * FROM courses WHERE course_id='$the_id'";
$run_course_detail=query($get_course_detail);
$row_course_detail=fetch($run_course_detail);

$db_cover_image_main=$row_course_detail['cover_image'];
$db_professor_image=$row_course_detail['professor_image'];


 $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');
 
 $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");
 if(empty($cover_image))
 {
 	$cover_image=$_POST['cover_image_hidden'];
 }

 $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");
 if(empty($professor_image))
 {
 	$professor_image=$_POST['professor_image_hidden'];
 }

 $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");
}

   $update_post="UPDATE `courses` SET `meta_title`='$meta_title',`slug_url`='$slug_url',`meta_description`='$meta_description',`meta_keywords`='$meta_keywords',`course_name`='$course_name',`cover_image`='$cover_image',`professor_name`='$professor_name',`professor_image`='$professor_image',`lectures`='$lectures',`duration`='$duration',`skill_level`='$skill_level',`language`='$language', `students`='$students', `assessments`='$assessments', `description`='$course_desc',status='$status' WHERE `course_id`='$the_id'";

 $run_insert_post=query($update_post);
 confirm($run_insert_post);
 
 $delete_placement=query("DELETE FROM course_placement WHERE course_id='$the_id'");
 for ($i=0; $i < $count_add_more; $i++) { 
 	$insert_placement="INSERT INTO `course_placement`(`course_id`, `cp_name`, `cp_profession`,`cp_image`) VALUES ('$the_id','$add_more[$i]','$placement_profession[$i]','$placement_image1[$i]')";
 	$run_placement=query($insert_placement);
 	confirm($run_placement);
 }
 $delete_review=query("DELETE FROM course_review WHERE course_id='$the_id'");
 for ($j=0; $j < $count_addmore1; $j++) { 
 	$insert_review="INSERT INTO `course_review`(`course_id`, `cr_name`, `cr_company_name`, `cr_review`,`cr_image`) VALUES ('$the_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 Updated');</script>";
	 echo "<script>window.open('../view_posts.php','_self');</script>";
 }


?>