php 按日期分组显示数据

Question

数据表如图上部分显示，想用mysql实现图下半部分效果，新手上路，求大神帮忙
$result = mysql_query("select * from table order by sj desc");
然后接下来应该怎么写输出的呢？

Answer 1

这个是你要的吗？ <?php $data = [ [ 'id' => 1, 'sj' => '2018-03-24 14:30:00', 'title' => '第一条记录', ], [ 'id' => 2, 'sj' => '2018-03-24 16:30:00', 'title' => '第二条记录', ], [ 'id' => 3, 'sj' => '2018-03-25 10:30:00', 'title' => '第三条记录', ], ]; $res = []; foreach ($data as $item) { $date = substr($item['sj'], 0, 10); $res[$date][] = $item; } var_dump($res); // 更新 没有实测 $res = []; $result = mysql_query("select * from table order by sj desc"); while ($item = mysql_fetch_assoc($result)) { $date = substr($item['sj'], 0, 10); $res[$date][] = $item; } var_dump($res); // 再做一次循环输出，应该是你要的结果 foreach($res as $k => $v){ echo date('m月d日',strtotime($k)); foreach($item as $key => $value){ echo $value['title']; } }

Answer 2

$oMysqli = new Mysqli($sHost,$sUser,$sPwd,$sDbname,$sPort); $sSql = "select * from t_test1 order by sj desc"; $rResult = $oMysqli->query($sSql); $aDate = []; while($aResult = $rResult->fetch_assoc()) { $sCurrentDate = date("m月d日",strtotime($aResult['sj'])); if(!in_array($sCurrentDate,$aDate)) { var_dump($sCurrentDate); $aDate[] = $sCurrentDate; } var_dump($aResult['title']); } $oMysqli->close();

Answer 3

@qiaoweizhen foreach($item as $key => $value) 里面的$item应该是$v，这样就可以实现了，多谢 $res = [];$result = mysql_query("select * from table order by sj desc");while ($item = mysql_fetch_assoc($result)) { $date = substr($item['sj'], 0, 10); $res[$date][] = $item; }var_dump($res); // 再做一次循环输出，应该是你要的结果 foreach($res as $k => $v){ echo date('m月d日',strtotime($k)); foreach($v as $key => $value){ echo $value['title']; } }