bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php

include '../connection.php';

use Aws\S3\S3Client;
use Aws\S3\Exception\S3Exception;
use Aws\Exception\AwsException;

require '../app/start.php';

if(isset($_POST['type'])&& $_POST['type']=='add_category'){

extract($_POST);

$success = false;

$message = '';

$sql = mysqli_query($conn,"SELECT * FROM category WHERE category = '$category'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$message = 'This Category Already Added...!';

}

else{

$sql01 = mysqli_query($conn,"INSERT INTO category(category) VALUES('$category')") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Category Added Successfully...!';

}

else{

$message = 'Category Not Added';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='add_sub_category'){

extract($_POST);

$success = false;

$message = '';

$count = sizeof($sub_category);

for($i=0;$i<$count;$i++){

$sub_category1=$sub_category[$i];

$sql = mysqli_query($conn,"INSERT INTO sub_category(category_id,sub_category) VALUES('$category_id','$sub_category1')") OR die(mysqli_error($conn));

}

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Sub Category Added Successfully...!';

}

else{

$message = 'Sub Category Not Added';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='edit_category'){

extract($_POST);

$success = false;

$message = '';

$sql = mysqli_query($conn,"SELECT * FROM category WHERE category = '$category'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$message = 'This Category Already Added...!';

}

else{

$sql01 = mysqli_query($conn,"UPDATE category SET category='$category' WHERE id = '$category_id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Category Updated Successfully...!';

}

else{

$message = 'Category Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='delete_category'){

extract($_POST);

$success = false;

$message = '';

$sql = mysqli_query($conn,"DELETE FROM category WHERE id = '$id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'This Category Deleted';

$sql01 = mysqli_query($conn,"DELETE FROM sub_category WHERE category_id = '$id'") OR die(mysqli_error($conn));

}

else{

$message = 'Category Not Deleted';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='edit_sub_category'){

extract($_POST);

$success = false;

$message = '';

$sql01 = mysqli_query($conn,"UPDATE sub_category SET category_id='$category_id',sub_category='$sub_category' WHERE id = '$sub_category_id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Sub Category Updated Successfully...!';

}

else{

$message = 'Sub Category Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='delete_sub_category'){

extract($_POST);

$success = false;

$message = '';

$sql = mysqli_query($conn,"DELETE FROM sub_category WHERE id = '$id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'This Sub Category Deleted';

}

else{

$message = 'Sub Category Not Deleted';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='add_course'){

extract($_POST);

$success = false;

$message = '';

$author_description = mysqli_real_escape_string($conn, $author_description);

$small_description = mysqli_real_escape_string($conn, $small_description);

$what_you_learn = mysqli_real_escape_string($conn, $what_you_learn);

$requirements = mysqli_real_escape_string($conn, $requirements);

$descrption = mysqli_real_escape_string($conn, $descrption);

$who_this_course_is_for = mysqli_real_escape_string($conn, $who_this_course_is_for);

$course_image=time().$_FILES['course_img']['name'];

$tmpname=$_FILES['course_img']['tmp_name'];

$video_thumbnail=time().$_FILES['video_thumbnail']['name'];

$tmpname_1=$_FILES['video_thumbnail']['tmp_name'];

$course_video=time().$_FILES['course_video']['name'];

$tmpname1=$_FILES['course_video']['tmp_name'];

$author_image=time().$_FILES['author_img']['name'];

$tmpname2=$_FILES['author_img']['tmp_name'];

$author_sign=time().$_FILES['author_sign']['name'];

$tmpname3=$_FILES['author_sign']['tmp_name'];

$sql = mysqli_query($conn,"SELECT * FROM courses WHERE course_name = '$course_name'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$message = 'Course Name Already Added...!';

}

else{

$query = "INSERT INTO courses(lang,sub_category_id,course_img,course_video,course_name,price,duration,what_you_learn,requirements,description,who_this_course_is_for,small_description,author,author_img,author_description,author_sign,video_thumbnail) VALUES('".$language."','".$topic."','".$course_image."','".$course_video."','".$course_name."','".$price."','".$duration."','".$what_you_learn."','".$requirements."','".$descrption."','".$who_this_course_is_for."','".$small_description."','".$author."','".$author_image."','$author_description','$author_sign','$video_thumbnail')";

$sql01 = mysqli_query($conn,$query) OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

move_uploaded_file($tmpname,'course_img/'.$course_image);
			
			move_uploaded_file($tmpname_1,'course_img/'.$video_thumbnail);

move_uploaded_file($tmpname1,'course_video/'.$course_video);

move_uploaded_file($tmpname2,'course_img/'.$author_image);

var_dump($e->toArray());
			 }

$success = true;

$message = 'Course Added Successfully...!';

}

else{

$message = 'Course Not Added';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='edit_course'){

extract($_POST);

$success = false;

$message = '';

$author_description = mysqli_real_escape_string($conn, $author_description);

$small_description = mysqli_real_escape_string($conn, $small_description);

$what_you_learn = mysqli_real_escape_string($conn, $what_you_learn);

$requirements = mysqli_real_escape_string($conn, $requirements);

$descrption = mysqli_real_escape_string($conn, $descrption);

$who_this_course_is_for = mysqli_real_escape_string($conn, $who_this_course_is_for);

if($_FILES['course_img']['name']=='' && $_FILES['video_thumbnail']['name']=='' && $_FILES['course_video']['name']=='' && $_FILES['author_img']['name']=='' && $_FILES['author_sign']['name']==''){

$course_image = $img;

$course_video = $video;

$author_img = $img2;

$author_sign = $img3;

$video_thumbnail = $img4;
		
		$tmpname_1='';

$tmpname='';

$tmpname1='';

$tmpname2='';

$tmpname3='';

}

elseif($_FILES['course_img']['name']=='' && $_FILES['video_thumbnail']['name']=='' && $_FILES['course_video']['name']=='' && $_FILES['author_sign']['name']==''){

$course_image = $img;

$course_video = $video;

$author_sign = $img3;

$author_img = time().$_FILES['author_img']['name'];

$tmpname2=$_FILES['author_img']['tmp_name'];

$video_thumbnail = $img4;

$tmpname='';
		 
		 $tmpname_1='';

$tmpname1 ='';

$tmpname3 ='';

}

elseif($_FILES['course_video']['name']=='' && $_FILES['video_thumbnail']['name']=='' && $_FILES['author_img']['name']==''  && $_FILES['author_sign']['name']==''){

$course_video = $video;

$author_img = $img2;

$author_sign = $img3;

$course_image = time().$_FILES['course_img']['name'];

$video_thumbnail = $img4;
		
		$tmpname_1='';

$tmpname=$_FILES['course_img']['tmp_name'];

$tmpname1='';

$tmpname2='';

$tmpname3 ='';

}

elseif($_FILES['author_img']['name']=='' && $_FILES['video_thumbnail']['name']=='' && $_FILES['course_img']['name']=='' && $_FILES['author_sign']['name']==''){

$author_img = $img2;

$course_image = $img;

$author_sign = $img3;

$course_video = time().$_FILES['course_video']['name'];

$tmpname1=$_FILES['course_video']['tmp_name'];

$video_thumbnail = $img4;
		
		$tmpname_1='';

$tmpname2='';

$tmpname ='';

$tmpname3 ='';

}

elseif($_FILES['author_img']['name']=='' && $_FILES['video_thumbnail']['name']=='' && $_FILES['course_img']['name']=='' && $_FILES['course_video']['name']==''){

$author_img = $img2;

$course_image = $img;

$course_video = $video;

$video_thumbnail = $img4;

$author_sign = time().$_FILES['author_sign']['name'];

$tmpname3=$_FILES['author_sign']['tmp_name'];

$tmpname_1='';

$tmpname1='';

$tmpname2='';

$tmpname ='';

}

elseif($_FILES['author_img']['name']=='' && $_FILES['course_img']['name']=='' && $_FILES['course_video']['name']=='' && $_FILES['author_sign']['name']==''){

$author_img = $img2;

$course_image = $img;

$course_video = $video;

$author_sign = $img3;

$tmpname3='';

$video_thumbnail = time().$_FILES['video_thumbnail']['name'];
		
		$tmpname_1=$_FILES['video_thumbnail']['tmp_name'];

$tmpname1='';

$tmpname2='';

$tmpname ='';

}

else{

$course_image=time().$_FILES['course_img']['name'];

$course_video=time().$_FILES['course_video']['name'];

$author_img = time().$_FILES['author_img']['name'];

$author_sign = time().$_FILES['author_sign']['name'];

$video_thumbnail = time().$_FILES['video_thumbnail']['name'];

$tmpname=$_FILES['course_img']['tmp_name'];

$tmpname_1=$_FILES['video_thumbnail']['tmp_name'];

$tmpname1=$_FILES['course_video']['tmp_name'];

$tmpname2=$_FILES['author_img']['tmp_name'];

$tmpname3=$_FILES['author_sign']['tmp_name'];

}

$query = "UPDATE courses SET

lang='$language',

sub_category_id='$topic',

course_img='$course_image',

video_thumbnail='$video_thumbnail',

course_video='$course_video',

course_name='$course_name',

price='$price',

duration='$duration',

what_you_learn='".$what_you_learn."',

requirements='".$requirements."',

description='".$descrption."',

who_this_course_is_for='".$who_this_course_is_for."',

small_description='".$small_description."',

author='".$author."',

author_img='$author_img',

author_description='$author_description',

author_sign='$author_sign'

WHERE id='$course_id' ";

$sql01 = mysqli_query($conn,$query) OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

move_uploaded_file($tmpname,'course_img/'.$course_image);

move_uploaded_file($tmpname_1,'course_img/'.$video_thumbnail);

move_uploaded_file($tmpname1,'course_video/'.$course_video);

move_uploaded_file($tmpname2,'course_img/'.$author_img);

move_uploaded_file($tmpname3,'course_img/'.$author_sign);
		
		
			 try{
				 $s3->putObject([
					'Bucket' => 'code-bharat-course-videos',
					'Key' => "course_video/{$course_video}",
					'SourceFile' => "course_video/{$course_video}",
				 ]);
				 
				 unlink('course_video/'.$course_video);
				 
			 } catch (S3Exception $e) {
				// Catch an S3 specific exception.
				echo $e->getMessage();
			} catch (AwsException $e) {
				// This catches the more generic AwsException. You can grab information
				// from the exception using methods of the exception object.
				echo $e->getAwsRequestId() . "\n";
				echo $e->getAwsErrorType() . "\n";
				echo $e->getAwsErrorCode() . "\n";
			
				// This dumps any modeled response data, if supported by the service
				// Specific members can be accessed directly (e.g. $e['MemberName'])
				var_dump($e->toArray());
			}

$success = true;

$message = 'Course Updated Successfully...!';

}

else{

$message = 'Course Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='delete_course'){

extract($_POST);

$success = false;

$message = '';

mysqli_query($conn,"DELETE FROM courses WHERE id = '$id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'This Course Deleted';

mysqli_query($conn,"DELETE FROM course_content WHERE course_id = '$id'") OR die(mysqli_error($conn));

mysqli_query($conn,"DELETE FROM quiz WHERE course = '$id'") OR die(mysqli_error($conn));

}

else{

$message = 'Course Not Deleted';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='add_featured_course'){

extract($_POST);

$success = false;

$message = '';

mysqli_query($conn,"UPDATE courses SET feature_course=1 WHERE id = '$id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Course Added to featured Course List.';

}

else{

$message = 'Course Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='remove_featured_course'){

extract($_POST);

$success = false;

$message = '';

mysqli_query($conn,"UPDATE courses SET feature_course=0 WHERE id = '$id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Course removed from the Featured Course List.';

}

else{

$message = 'Course Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='add_course_content'){

extract($_POST);

$success = false;

$message = '';

$count = sizeof($topic);

for($i=0;$i<$count;$i++){

$video01=time().$_FILES['video']['name'][$i];

$tmpname=$_FILES['video']['tmp_name'][$i];

if(isset($_FILES['resource']) && $_FILES['resource']['name'][$i] == 'jugad.txt'){
			$file01='';
			$tmp_filename='';
		} else {
			$file01=time().".".$_FILES['resource']['name'][$i];
			$tmp_filename=$_FILES['resource']['tmp_name'][$i];
			move_uploaded_file($tmp_filename,'course_downloads/'.$file01);
		}

$topic01=$topic[$i];

$time_duration01=$time_duration[$i];

$quiz01=$quiz[$i];

move_uploaded_file($tmpname,'course_video/'.$video01);
		
		try{
			$s3->putObject([
			'Bucket' => 'code-bharat-course-videos',
			'Key' => "course_video/{$video01}",
			'SourceFile' => "course_video/{$video01}",
			]);
			
		unlink('course_video/'.$video01);
		
			
		} catch (S3Exception $e){
			
			die("There was an error uploading that file");
		
		}

$sql = mysqli_query($conn,"INSERT INTO course_content(course_id,section,topic,video,time_duration,quiz,section_download) VALUES('$course_id','$section','$topic01','$video01','$time_duration01','$quiz01','$file01')") OR die(mysqli_error($conn));

}

$success = true;

$message = 'Course Content Added Successfully...!';

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='edit_course_content'){

extract($_POST);

$success = false;

$message = '';

$video01=time().$_FILES['video']['name'];

$tmpname=$_FILES['video']['tmp_name'];

if($_FILES['file']['name']==''){
		$file01='';
		$tmp_filename='';
	} else {
		$file01=time().".".$_FILES['file']['name'];
		$tmp_filename=$_FILES['file']['tmp_name'];
	}

$topic01=$topic;

$time_duration01=$time_duration;

if($_FILES['video']['name']==''  && $_FILES['file']['name']==''   ){

$query = "UPDATE course_content SET section='$section',topic='$topic01',time_duration='$time_duration01',quiz='$quiz' WHERE id='$ccid'";

}

else{

$query = "UPDATE course_content SET section='$section',topic='$topic01',time_duration='$time_duration01',video='$video01', quiz = '$quiz', section_download = '$file01' WHERE id='$ccid'";

}

mysqli_query($conn,$query) OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

move_uploaded_file($tmpname,'course_video/'.$video01);

move_uploaded_file($tmp_filename,'course_downloads/'.$file01);
		
		try{
			$s3->putObject([
			'Bucket' => 'code-bharat-course-videos',
			'Key' => "course_video/{$video01}",
			'SourceFile' => "course_video/{$video01}",
			]);

unlink('course_video/'.$video01);
			
		} catch (S3Exception $e){
			
			die("There was an error uploading that file");
			
		}

$success = true;

$message = 'Course Content Updated Successfully...!';

}

else{

$message = 'Course Content Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='delete_course_content'){

extract($_POST);

$success = false;

$message = '';

$sql = mysqli_query($conn,"DELETE FROM course_content WHERE id = '$id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'This Course Content Deleted';

}

else{

$message = 'Course content Not Deleted';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='add_blog'){

extract($_POST);

$success = false;

$message = '';

$blog_image=time().$_FILES['blog_img']['name'];

$tmpname=$_FILES['blog_img']['tmp_name'];

$sql = mysqli_query($conn,"SELECT * FROM blog WHERE blog_name = '$blog_name'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$message = 'Blog Name Already Added...!';

}

else{

$query = "INSERT INTO blog(lang,blog_image,blog_name,blog_description,small_description,author,blog_date) VALUES('$language','$blog_image','$blog_name','$blog_description','$small_description','$author','$blog_date')";

$sql01 = mysqli_query($conn,$query) OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

move_uploaded_file($tmpname,'blog/'.$blog_image);

$success = true;

$message = 'Blog Added Successfully...!';

}

else{

$message = 'Blog Not Added';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='edit_blog'){

extract($_POST);

$success = false;

$message = '';

$blog_image=time().$_FILES['blog_img']['name'];

$tmpname=$_FILES['blog_img']['tmp_name'];

if($_FILES['blog_img']['name']==''){

$sql = "UPDATE blog SET blog_name='$blog_name',blog_description='$blog_description',small_description='$small_description',author='$author',blog_date='$blog_date',lang='$language' WHERE id='$id'";

}

else{

$sql = "UPDATE blog SET blog_name='$blog_name',blog_description='$blog_description',small_description='$small_description',author='$author',blog_date='$blog_date',blog_image='$blog_image' WHERE id='$id'";

}

mysqli_query($conn,$sql) OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

move_uploaded_file($tmpname,'blog/'.$blog_image);

$success = true;

$message = 'Blog Updated Successfully...!';

}

else{

$message = 'Blog Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='delete_blog'){

extract($_POST);

$success = false;

$message = '';

$sql = mysqli_query($conn,"DELETE FROM blog WHERE id = '$id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Blog Deleted';

}

else{

$message = 'Blog Not Deleted';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type'] == 'get_subcategory'){

extract($_POST);

$sql = "SELECT * FROM sub_category WHERE category_id = '$category_id'";

$query = mysqli_query($conn,$sql) or die(mysqli_error($conn));

$option = '<option value="">Select Sub Category</option>';

while($row = mysqli_fetch_assoc($query)){

$option .= '<option value="'.$row["id"].'">'.$row["sub_category"].'</option>';

}

echo $option;

}

if(isset($_POST['type'])&& $_POST['type'] == 'get_course'){

extract($_POST);

$sql = "SELECT * FROM courses WHERE sub_category_id = '$sub_category_id'";

$query = mysqli_query($conn,$sql) or die(mysqli_error($conn));

$option = '<option value="">Select Course</option>';

while($row = mysqli_fetch_assoc($query)){

$option .= '<option value="'.$row["id"].'">'.$row["course_name"].'</option>';

}

echo $option;

}

if(isset($_POST['type'])&& $_POST['type']=='add_coupon'){

extract($_POST);

$success = false;

$message = '';

$exp_date = date('Y-m-d',strtotime($expiry_date));

$current_date = date('Y-m-d');

if($current_date>=$exp_date){

$message = 'Expiry date should be greater than current date..!';

}

else{

$sql = mysqli_query($conn,"SELECT * FROM coupon WHERE coupon_code = '$coupon_code'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$message = 'Coupon Code Already Added...!';

}

else{

$query = "INSERT INTO coupon(category,sub_category,course,coupon_code,coupon_type,price,purchase_limit,user_limit,expiry_date) VALUES('$category','$sub_category','$course','$coupon_code','$coupon_type','$price','$purchase_limit','$user_limit','$expiry_date')";

$sql01 = mysqli_query($conn,$query) OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Coupon Code Added Successfully...!';

}

else{

$message = 'Coupon Code Not Added';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type'] == 'get_subcategory_for_update'){

extract($_POST);

$sql = "SELECT * FROM sub_category WHERE category_id = '$category_id'";

$query = mysqli_query($conn,$sql) or die(mysqli_error($conn));

while($row = mysqli_fetch_assoc($query)){

<option value="">Select Sub Category</option>

<option value="<?=$row['id']?>" <?php if($subcat_id==$row['id']){ ?>selected <?php } ?> ><?=$row["sub_category"]?></option>

<?php }

}

if(isset($_POST['type'])&& $_POST['type'] == 'get_course_for_update'){

extract($_POST);

$sql = "SELECT * FROM courses WHERE sub_category_id = '$sub_category_id'";

$query = mysqli_query($conn,$sql) or die(mysqli_error($conn));

while($row = mysqli_fetch_assoc($query)){

<option value="">Select Course</option>

<option value="<?=$row['id']?>" <?php if($course_id==$row['id']){ ?>selected <?php } ?> ><?=$row["course_name"]?></option>

<?php }

}

if(isset($_POST['type'])&& $_POST['type']=='update_coupon_code'){

extract($_POST);

$success = false;

$message = '';

$sql = mysqli_query($conn,"SELECT * FROM coupon WHERE coupon_code = '$coupon_code'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$message = 'Coupon Code Already Added...!';

}

else{

$query = "UPDATE coupon SET coupon_code = '$coupon_code' WHERE id = '$coupon_id'";

$sql01 = mysqli_query($conn,$query) OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Coupon Code Updated Successfully...!';

}

else{

$message = 'Coupon Code Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='update_coupon_details'){

extract($_POST);

$success = false;

$message = '';

$exp_date = date('Y-m-d',strtotime($expiry_date));

$current_date = date('Y-m-d');

if($current_date>=$exp_date){

$message = 'Expiry date should be greater than current date..!';

}

else{

$query = "UPDATE coupon SET category = '$category', sub_category = '$sub_category',course = '$course',coupon_type='$coupon_type',price = '$price',purchase_limit = '$purchase_limit',user_limit = '$user_limit',expiry_date = '$expiry_date' WHERE id = '$coupon_id'";

$sql01 = mysqli_query($conn,$query) OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Coupon Code Updated Successfully...!';

}

else{

$message = 'Coupon Code Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='add_quiz'){

extract($_POST);

$success = false;

$message = '';

$count = sizeof($question);

for($i=0;$i<$count;$i++){

$question01 = $question[$i];

$option01 = $option1[$i];

$option02 = $option2[$i];

$option03 = $option3[$i];

$option04 = $option4[$i];

$answer01 = $answer[$i];

$total_ques = $i + 1;

$sql01 = "SELECT * FROM quiz WHERE course = '$course' AND topic = '$topic' ORDER BY id DESC limit 1";

$query01 = mysqli_query($conn,$sql01) or die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$row = mysqli_fetch_assoc($query01);

$total_ques = $row['total_ques'] + 1;

}

$sql = "INSERT INTO quiz(course,topic,question,option1,option2,option3,option4,answer,total_ques) VALUES('$course','$topic','$question01','$option01','$option02','$option03','$option04','$answer01','$total_ques')";

$query = mysqli_query($conn,$sql) or die(mysqli_error($conn));

}

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Quiz added Successfully...!';

}

else{

$message = 'Quiz Not Successfully';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='delete_quiz'){

extract($_POST);

$success = false;

$message = '';

$sql = mysqli_query($conn,"DELETE FROM quiz WHERE id = '$id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Quiz Deleted';

}

else{

$message = 'Quiz Not Deleted';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='edit_quiz'){

extract($_POST);

$success = false;

$message = '';

$sql = "UPDATE quiz SET course = '$course', topic = '$topic', question = '$question', option1 = '$option1',option2 = '$option2',option3 = '$option3',option4 = '$option4',answer = '$answer' WHERE id = '$quiz_id'";

mysqli_query($conn,$sql) OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Quiz Updated';

}

else{

$message = 'Quiz Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type']=='delete_rating'){

extract($_POST);

$success = false;

$message = '';

$sql = mysqli_query($conn,"DELETE FROM course_rating WHERE id = '$id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Rating Deleted';

}

else{

$message = 'Rating Not Deleted';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}

if(isset($_POST['type'])&& $_POST['type'] == 'edit_rating'){

extract($_POST);

$success = false;

$message = '';

$sql01 = mysqli_query($conn,"UPDATE course_rating SET rating = '$rating', comment = '$comment' WHERE id = '$rating_id'") OR die(mysqli_error($conn));

if(mysqli_affected_rows($conn)){

$success = true;

$message = 'Rating Updated Successfully...!';

}

else{

$message = 'Rating Not Updated';

}

$result = array(

"success" => $success,

"message" => $message,

);

echo json_encode($result);

}