Viewing file:  activate_action.php (2.11 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require 'connection.php';
$enrollid=$_POST['enrollid'];
$days=$_POST['days'];
$startdate=$_POST['startdate'];
$enddate=$_POST['enddate'];
$day=implode(" , ",$days);
$exam=$_POST['exam_date'];
$exam_date=implode(" , ",$exam);
$sql5 = "UPDATE enrolldetails SET admin_status= 1 WHERE `enrollid`=$enrollid";
$result5=$con->query($sql5);
$sql="select * from `enrolldetails` where enrollid='$enrollid'";
$result=$con->query($sql);
$count=$result->num_rows;
$row=$result->fetch_assoc();
$course_id=$row['course_id'];
$userid=$row['user_id'];
$sql2="select * from `syllabus` where package='$course_id'";
$result2=$con->query($sql2);
$count2=$result2->num_rows;
$row2=$result2->fetch_assoc();
$syllabus=$row2['id'];
// $sql3="select * from `syllabus_topics` where syllabus_id=$syllabus";
// $result3=$con->query($sql3);
// $count3=$result3->num_rows;
// $no_days=0;
// while($row3=$result3->fetch_assoc()){
// $no=$row3['no_of_days'];
// $syllabus_id=$row3['id'];
// $no_days+=$row3['no_of_days'];
// }
$sql4="insert into `student_batch_plan`(enrollid,start_date,days,no_days,end_date,exam_dates) values('$enrollid','$startdate','$day','0','$enddate','$exam_date')";
$result4=$con->query($sql4);
$count4=$con->affected_rows;
if($count4>0){
$sq="select * from user_details where user_id=$userid";
$sqResult=$con->query($sq);
$sqRow=$sqResult->fetch_assoc();
$email=$sqRow['email'];
$to_1 =$email;
$from_1='srishticampusteam@srishtis.com';
$subject_1="Srishti Campus Team";
$headers_1 = 'MIME-Version: 1.0' . "\n";
$headers_1 .= 'Content-type: text/html; charset=iso-8859-1' . "\n";
$headers_1 .= "From:Srishti\n" .
"Reply-To: srishticampusteam@srishtis.com\n".
"X-Mailer: php/". phpversion();
$output_1="Thank you ,Your course has been Activated ,Please check your dashboard for Class Schedule and Topics to be covered.
<br>
<br>
Thanks <br>
Srishti Campus Team ";
$sent_1= mail($to_1,$subject_1, $output_1, $headers_1);
header("location:new_requests.php?id=success");
}
else{
header("location:new_requests.php?failed");
}
?>
|