Статистика. Количество хитов по месяцам
Код выводит таблицу вида:
Месяц | Хитов
2007-06 | 1026
2007-07 | 3026<?php
$header = array ('Месяц', 'Хитов');
$rows = array();
$q = "SELECT DATE_FORMAT(FROM_UNIXTIME(timestamp), '%Y-%m') AS month, COUNT(*) AS hits FROM {accesslog} GROUP BY month ORDER BY month DESC";
$result = db_query ($q);
while ( $row = db_fetch_object ( $result ) ) {
$rows[] = array ( 'data' => array ( $row->month, $row->hits )) ;
}
if (!$rows) {
$rows[] = array(array('data' => t('No log data available.'), 'colspan' => 2));
}
print theme('table', $header, $rows);
?>
20.07.2007
Comments
Post new comment