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


Download 20.73 Kb.
bet1/3
Sana08.11.2023
Hajmi20.73 Kb.
#1756557
  1   2   3
Bog'liq
Аkramjonov Shaxzod Ikromovich 317 илова


Иловалар

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

$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;
?>



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







Т/р

Download 20.73 Kb.

Do'stlaringiz bilan baham:
  1   2   3




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling