Курсларнинг элементлар билан таъминланганлиги

Иловалар

/*******************************************************
* Курсларнинг элементлар билан таъминланганлиги *
*******************************************************/

$sql ='
select

CONCAT("",
c.fullname, " "),
IFNULL((select COUNT(*) from mdl_resource as resource where resource.course = c.id GROUP BY resource.course ),0) as e_resource ,
IFNULL((select COUNT(*) from mdl_lesson as lesson where lesson.course = c.id GROUP BY lesson.course ),0) as e_lesson ,
IFNULL((select COUNT(*) from mdl_quiz as quiz where quiz.course = c.id GROUP BY quiz.course ),0) as e_quiz ,
IFNULL((select COUNT(*) from mdl_assign as assign where assign.course = c.id GROUP BY assign.course ),0) as e_assign ,
IFNULL((select COUNT(*) from mdl_page as page where page.course = c.id GROUP BY page.course ),0) as e_page,
IFNULL((select COUNT(*) from mdl_choice as choice where choice.course = c.id GROUP BY choice.course ),0) as e_choice ,
IFNULL((select COUNT(*) from mdl_url as url where url.course = c.id GROUP BY url.course ),0) as e_url,
IFNULL((select COUNT(*) from mdl_glossary as glossary where glossary.course = c.id GROUP BY glossary.course ),0) as e_glossary ,
IFNULL((select COUNT(*) from mdl_workshop as workshop where workshop.course = c.id GROUP BY workshop.course ),0) as e_workshop,
c.id as cid
FROM mdl_course as c
where c.category<>0

ORDER BY c.category, c.fullname

';
global $mysqli;

$mysqli->query('SET names "utf8"');

$i=0;
?>



Курсларнинг элементлар билан таъминланганлиги / Курсларнинг элементлар билан таъминланганлиги

Т/р