php按日期分组统计,如何在php / mysql中对时间间隔进行分组并根据这些时间组获取统计信息？...

在09:00至12:00之间吸引访客

SELECT

SUM(`visitors`)

FROM

`my_table`

WHERE

HOUR(`timeAndDate`) BETWEEN 9 AND 12

按月获得访客

SELECT

MONTH(`timeAndDate`),

SUM(`visitors`)

FROM

`my_table`

GROUP BY

MONTH(`timeAndDate`)

每年吸引游客

SELECT

YEAR(`timeAndDate`),

SUM(`visitors`)

FROM

`my_table`

GROUP BY

YEAR(`timeAndDate`)

简单的PHP示例,用于输出表中的月份

// Connect to database

$db = mysqli_connect('localhost', 'root', 'root', 'test') or die('Could not connect to database');

// Prepare sql question

$sql = "SELECT

MONTHNAME(`timeAndDate`) AS `month`,

SUM(`visitors`) AS `visitors`

FROM

`test`

GROUP BY

MONTH(`timeAndDate`)";

// Query the database

$result = mysqli_query($db, $sql);

// Begin table

print '

// Loop result

while($row = mysqli_fetch_assoc($result)) {

print "

{$row['month']}{$row['visitors']}";

}

// End table

print '

';

?>