數(shù)據(jù)表如圖上部分顯示，想用mysql實(shí)現(xiàn)圖下半部分效果，新手上路，求大神幫忙$result = mysql_query("select * from table order by sj desc"); 然后接下來應(yīng)該怎么寫輸出的呢？
4 回答
Smart貓小萌
TA貢獻(xiàn)1911條經(jīng)驗(yàn) 獲得超7個贊
這個是你要的嗎？
<?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);
// 更新 沒有實(shí)測
$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);
// 再做一次循環(huán)輸出，應(yīng)該是你要的結(jié)果
foreach($res as $k => $v){
echo date('m月d日',strtotime($k));
foreach($item as $key => $value){
echo $value['title'];
}
}
www說
TA貢獻(xiàn)1775條經(jīng)驗(yàn) 獲得超8個贊
$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();
慕標(biāo)5832272
TA貢獻(xiàn)1966條經(jīng)驗(yàn) 獲得超4個贊
@qiaoweizhen foreach($item as $key => $value) 里面的$item應(yīng)該是$v，這樣就可以實(shí)現(xiàn)了，多謝
$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);
// 再做一次循環(huán)輸出，應(yīng)該是你要的結(jié)果
foreach($res as $k => $v){
echo date('m月d日',strtotime($k));
foreach($v as $key => $value){
echo $value['title'];
}}
- 4 回答
- 0 關(guān)注
- 893 瀏覽
添加回答
舉報
0/150
提交
取消