Course & Location
Duration
Dates
End
Choose to
$order_by = "start_date";
if($filterby=='course'){
$order_by = "title";
}elseif($filterby=='duration'){
$order_by = "CAST(duration AS DECIMAL)";
}elseif($filterby=='enddate'){
$order_by = "end_date";
}
$current_date = date('Y-m-d');
$calendar_handler = mysqli_query($dbhandle, "select * from calendar where status='active' order by $order_by $order");
if(mysqli_num_rows($calendar_handler)>0){
?>
while($calendar = mysqli_fetch_assoc($calendar_handler)){
$rowid = $calendar['rowid'];
$courseid = $calendar['courseid'];
$enccourseid = base64_encode($courseid);
$title = $calendar['title'];
$subtitle = $calendar['subtitle'];
$duration = $calendar['duration'];
$startdate = $calendar['start_date'];
$enddate = $calendar['end_date'];
$url_text = $calendar['ancor_text'];
$url_link = $calendar['url'];
$title_url = $url_link;
if($courseid!=""){
// $url_text = ($startdate>=$current_date)?"Apply Now+":"Learn More+";
// $url_link = ($startdate>=$current_date)?"course-registration?c=$enccourseid&b=$ecnbatchid":"courses-detail?c=$enccourseid";
$title_url = "courses-detail?c=".base64_encode($courseid);
}
?>
Jan, 01st 1970
Jan, 01st 1970
} ?>
} ?>
// $upnext_batch_handler = mysqli_query($dbhandle, "select batch.bid,batch.courseid,batch.startdate,crs.name,crs.short_description,crs.box_image,crs.pdf from batch_calendar batch inner join course crs on batch.courseid=crs.courseid where crs.status='active' and batch.startdate>='$current_date' order by startdate asc");
// if(mysqli_num_rows($upnext_batch_handler)>0){
?>
Mussoorie Mountain Festival
// } ?>