PHP / mysql：如何显示按时间排序和按日期分组的记录？ [英] PHP/mysql: how do I display records sorted by time and grouped by date?

问题描述

我需要显示按日期分组并按时间排序的记录。在mysql表中，我有一个名为 entry_time 的字段，其中存储了php time（）值。有什么想法是最紧凑，最简单的方法吗？

I need to display records grouped by date, and sorted by time. In the mysql table I have a field called entry_time which has php time() values stored in it. Any ideas what would be the most compact and simplest way to do this?

例如：我需要一个像这样的显示器：

Ex: I need a display like:

21st April
3:00 pm
3:50 pm

22 April
5:00 am
4:00 pm

推荐答案

粗糙的半伪代码：

$records = /* SELECT * FROM `records` ORDER BY `entry_time` */;

$date = null;
foreach ($records as $record) {
    $currentDate = date('Ymd', $record['entry_time']);
    if ($currentDate != $date) {
        printf('<h1>%s</h1>', date('Y-m-d', $record['entry_time']));
    }
    $date = $currentDate;

    echo date('H:i', $record['entry_time']);
}

这篇关于PHP / mysql：如何显示按时间排序和按日期分组的记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！