<?php

function show_menu_course($con){

	$courses = '';
	$courses .= generate_menu_multilevel_course($con);
	
	$courses = str_replace("<ul class='sub-menu'></ul>","",$courses);
	return $courses;
 }

 function generate_menu_multilevel_course($con, $parent_course_id =NULL){
 	$course = '';
 	$sql = '';
 	

 	if( is_null($parent_course_id)){
 		$sql = "SELECT * FROM `courses` WHERE `parent_course_id` IS NULL AND delete_status = 'N' ORDER BY `sort_order` ASC";
 	}
 	else{
 		$sql = "SELECT * FROM `courses` WHERE `parent_course_id`= $parent_course_id  AND delete_status = 'N' ORDER BY `courses`.`id` ASC ";
 	}

 	$result = mysqli_query($con, $sql);
 	while($row = mysqli_fetch_assoc($result)){
 		if(is_null($row['parent_course_id'])){
 			
 			// $course .= "<li class='menu-item menu-item-has-children'><a href='course.php?id=".$row['id']."'>" .$row['name']."</a>";
 			$course .= "<li class='menu-item menu-item-has-children'><a href='#'>" .$row['name']."</a>";
 		}
 		else{
 			// $course .= "<li class='menu-item'> <a href='course.php?id=".$row['id']."'>" .$row['name']."</a>";
 			$course .= "<li class='menu-item'> <a href='course/".$row['page_url'].".php'>" .$row['name']."</a>";
 		}
 		$course .= "<ul class='sub-menu'>".generate_menu_multilevel_course($con,$row['id']).'</ul>';
		
 		$course .= '</li>';
 		
 	}
 	return $course;
 }

 
?>