Статистика. Количество посетителей в месяце пришедших с Google
Код выводит таблицу вида:
Месяц | Хитов
2007-07 | 302<?php
$header = array ('Месяц', 'Хитов');
$rows = array();
$q = "SELECT DATE_FORMAT(FROM_UNIXTIME(timestamp), '%Y-%m') AS month, COUNT(*) AS hits FROM {accesslog} WHERE url LIKE 'http://www.google%' 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