douhui9192 2016-06-08 21:46
浏览 19

用PHP处理日期和时间

So im working with morris charts, im showing all the data we have for today.

I have an array like below:

[0] => Array (
    [id] => 1
    [uid] => 6161
    [botted] => 0
    [crondate] => 2016-06-08 00:20:32
    )
[1] Array ( 
    [id] => 2
    [uid] => 4141
    [botted] => 140
    [crondate] => 2016-06-08 00:40:00
    )
[2] Array ( 
    [id] => 3
    [uid] => 53
    [botted] => 40
    [crondate] => 2016-06-08 01:12:20
    )
[3] Array ( 
    [id] => 4
    [uid] => 5
    [botted] => 140
    [crondate] => 2016-06-08 01:18:00
    )
[4] Array ( 
    [id] => 5
    [uid] => 353
    [botted] => 88
    [crondate] => 2016-06-08 01:50:00
    )

(I hand writ the array, its a result of a SELETE * FROM items QUERY)

I need all of the rows formatted by date then added to seperate arrays depending on the date.

I need them formated by the hour, example:

All of the rows with the date inside of 1pm today, added to an array FOR THAT HOUR.

All of the rows with the date inside of 2pm today, added to an array FOR THAT HOUR.

etc, etc...

I need this done for every hour of the day(up to the current hour) so that i can add up all of the ['botted'] columns for that hour, add that to an array and display it in a MORRIS CHART

Thank you.

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 我的数据无法存进链表里
    • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大
    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 seatunnel 怎么配置Elasticsearch
    • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
    • ¥15 (标签-MATLAB|关键词-多址)
    • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
    • ¥500 52810做蓝牙接受端