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

Download 20.73 Kb.

bet	2/3
Sana	08.11.2023
Hajmi	20.73 Kb.
	#1756557

1 2 3

Bog'liq
Аkramjonov Shaxzod Ikromovich 317 илова

Сўровнома URL Глоссарий
.$row[5]. .$row[6]. .$row[7]. .$row[8]. .$row[9]. ;
_"is-selected" >

if ($result = $mysqli->query($sql))
while($row = $result->fetch_array())
{
$i++;
echo '';
}
echo '

Курс	Ресурс (файл)	Лекция	Тест	Топшириқ	Саҳифа	Сўровнома	URL	Глоссарий	Семинар
'.$i.'	'.$row[0].'	' .$row[1].'	'.$row[2].'	' .$row[3].'	'.$row[4].'	' .$row[5].'	'.$row[6].'	' .$row[7].'	'.$row[8].'	' .$row[9].'

';
//$result->close();
unset($row);
unset($sql);
unset($query);
/*******************************************************
* Тизимга охирги мурожаатлар *
*******************************************************/

global $mysqli;

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

$i=0;
?>

"is-size-5">
Статистика / Статистика

ОТМ бўйича MOODLEда шакллантирилган фанлар кесимида

"table is-bordered is-striped is-narrow is-hoverable is-fullwidth">

"is-selected">

$sql24_1 ='SELECT COUNT(courseid) as cnt FROM mdl_user_lastaccess WHERE FROM_UNIXTIME(timeaccess ) >= now() - INTERVAL 1 DAY';
$sql24_2 ='SELECT COUNT( DISTINCT courseid) as cnt FROM mdl_user_lastaccess WHERE FROM_UNIXTIME(timeaccess ) >= now() - INTERVAL 1 DAY';
$sql72_1 ='SELECT COUNT(courseid) as cnt FROM mdl_user_lastaccess WHERE FROM_UNIXTIME(timeaccess ) >= now() - INTERVAL 3 DAY';
$sql72_2 ='SELECT COUNT( DISTINCT courseid) as cnt FROM mdl_user_lastaccess WHERE FROM_UNIXTIME(timeaccess ) >= now() - INTERVAL 3 DAY';

$c = "select count(*) as cnt FROM ";

$c .=SITEPREFIX."course where category <>0";

echo '';
echo '';
echo '

"300px">	"center">Платформага юкланган фанлар	"center">Сўнги 24 соатда фойдаланилиши	"center">Сўнги 72 соатда фойдаланилиши
Умумий мурожаатлар	'.get_count($c).'	'.get_count($sql24_1).'	'.get_count($sql72_1).'
Уникаль мурожаатлар	'.get_count($c).'	'.get_count($sql24_2).'	'.get_count($sql72_2).'

';

/*******************************************************
* Бўш курслар *
*******************************************************/
$h=$_SERVER['HTTP_HOST'];
$sql ="SELECT
concat('$h/course/view.php?id=',mdl_course.id,'\">',mdl_course.fullname,'') as lnk,
DATE_FORMAT(FROM_UNIXTIME(mdl_course.timecreated),'%Y-%m-%d %H:%m:%s') as crdate,
DATE_FORMAT(FROM_UNIXTIME(mdl_course.timemodified),'%Y-%m-%d %H:%m:%s') as mddate

FROM mdl_course

LEFT JOIN mdl_course_categories ON (mdl_course.category = mdl_course_categories.id)
LEFT JOIN mdl_lesson ON (mdl_course.id = mdl_lesson.course)
LEFT JOIN mdl_assignment ON (mdl_course.id = mdl_assignment.course)
LEFT JOIN mdl_resource ON (mdl_course.id = mdl_resource.course)
LEFT JOIN mdl_quiz ON (mdl_course.id = mdl_quiz.course)
LEFT JOIN mdl_chat ON (mdl_course.id = mdl_chat.course)
LEFT JOIN mdl_data ON (mdl_course.id = mdl_data.course)
LEFT JOIN mdl_glossary on (mdl_course.id = mdl_glossary.course)
LEFT JOIN mdl_choice on (mdl_course.id = mdl_choice.course)
LEFT join mdl_wiki on (mdl_course.id = mdl_wiki.course)
LEFT join mdl_forum on (mdl_course.id = mdl_forum.course)
WHERE
mdl_lesson.course IS NULL and
mdl_assignment.course IS NULL and
mdl_resource.course IS NULL and
mdl_quiz.course IS NULL and
mdl_chat.course is null and
mdl_data.course is null and

Download 20.73 Kb.

Do'stlaringiz bilan baham:

1 2 3