首頁猿問 php mysql...

php mysql 如何獲取最近一周7天，每天的訂單數(shù)？

PHP

拉風的咖菲貓 2019-03-08 16:36:19

問題一：1、$array數(shù)組如下： array (size=7) 1 => string '2018-09-21' (length=10) 2 => string '2018-09-22' (length=10) 3 => string '2018-09-23' (length=10) 4 => string '2018-09-24' (length=10) 5 => string '2018-09-25' (length=10) 6 => string '2018-09-26' (length=10) 7 => string '2018-09-27' (length=10) 2、$list數(shù)組如下： array (size=3) 0 => array (size=2) 'riqi' => string '2018-09-21' (length=10) 'count' => int 2 1 => array (size=2) 'riqi' => string '2018-09-26' (length=10) 'count' => int 2 2 => array (size=2) 'riqi' => string '2018-09-27' (length=10) 'count' => int 3 求助：如何php實現(xiàn)以下效果 array (size=3) 0 => array (size=2) 'riqi' => string '2018-09-21' (length=10) 'count' => int 2 1 => array (size=2) 'riqi' => string '2018-09-22' (length=10) 'count' => int 0 2 => array (size=2) 'riqi' => string '2018-09-23' (length=10) 'count' => int 0 3 => array (size=2) 'riqi' => string '2018-09-24' (length=10) 'count' => int 0 4 => array (size=2) 'riqi' => string '2018-09-25' (length=10) 'count' => int 0 5 => array (size=2) 'riqi' => string '2018-09-26' (length=10) 'count' => int 2 6 => array (size=2) 'riqi' => string '2018-09-27' (length=10) 'count' => int 3 問題二：現(xiàn)有sql如下： select FROM_UNIXTIME(addtime,'%Y-%m-%d') as riqi, count(1) as count from order where FROM_UNIXTIME(addtime,'%Y-%m-%d') >= now() - interval 7 day group by FROM_UNIXTIME(addtime,'%Y-%m-%d') 如何能通過一句sql實現(xiàn)以下效果 array (size=3) 0 => array (size=2) 'riqi' => string '2018-09-21' (length=10) 'count' => int 2 1 => array (size=2) 'riqi' => string '2018-09-22' (length=10) 'count' => int 0 2 => array (size=2) 'riqi' => string '2018-09-23' (length=10) 'count' => int 0 3 => array (size=2) 'riqi' => string '2018-09-24' (length=10) 'count' => int 0 4 => array (size=2) 'riqi' => string '2018-09-25' (length=10) 'count' => int 0 5 => array (size=2) 'riqi' => string '2018-09-26' (length=10) 'count' => int 2 6 => array (size=2) 'riqi' => string '2018-09-27' (length=10) 'count' => int 3

查看完整描述

4 回答

白板的微信

TA貢獻1883條經(jīng)驗獲得超3個贊

目的:實現(xiàn)數(shù)據(jù)的組裝; 1.先循環(huán)日期數(shù)組2.每一個循環(huán)代碼內(nèi),調(diào)用函數(shù)或方法3.上面的函數(shù)或方法就是實現(xiàn)根據(jù)日期查詢數(shù)據(jù),返回訂單數(shù)的結(jié)果

反對回復 2019-03-18

鳳凰求蠱

TA貢獻1825條經(jīng)驗獲得超4個贊

SELECT FROM_UNIXTIME(addtime,'%Y-%m-%d') as riqi,count(*) from order GROUP BY riqi ORDER BY riqi LIMIT 7
應該是你要的結(jié)果

反對回復 2019-03-18

12345678_0001

TA貢獻1802條經(jīng)驗獲得超5個贊

用to_days(now()) - to_days(addtime)<= 7來查取近7天的數(shù)據(jù)，然后用date方法將時間只保留到天數(shù)。再對查到的數(shù)據(jù)，根據(jù)時間進行分組，再count(訂單)，得到就是每天對應的訂單數(shù)了。
如果要把訂單數(shù)為0 的天數(shù)也展示出來，就寫個日期的循環(huán)，判斷每天的日期是否在查詢結(jié)果里有對應的記錄，有就直接取，沒有就是0.
效果圖：