dongxie9448 2015-07-09 09:17
浏览 131
已采纳

使用时间戳对数组进行排序

Im trying to create sort button for list but ive got this list, and i dont know what to do with this timestamp is it possible to sort with it, here is my array type, i hope you will help me guys here it it:

Array
(
    [0] => 17
    [ticket] => 17
    [1] => Name Second Name
    [author] => Name Second Name 
    [2] => modules
    [subject] => modules
    [3] => 1412335833
    [timestamp] => 1412335833
    [4] => 1414048041
    [activity] => 1414048041
    [5] => Closed
    [type] => Closed
    [6] => 3
    [priority] => 3
    [7] => 13
    [assignment] => 13
    [8] => 17
)

Array
(
    [0] => 18
    [ticket] => 18
    [1] => Name Second Name 
    [author] => Name Second Name
    [2] => modules
    [subject] => modules
    [3] => 1412335935
    [timestamp] => 1412335935
    [4] => 1414048095
    [activity] => 1414048095
    [5] => Closed
    [type] => Closed
    [6] => 3
    [priority] => 3
    [7] => 0
    [assignment] => 0
    [8] => 18
)

As you can see timestamp is the date. I need to sort it, here is what ive tried:

function date_compare($a, $b)
    {
        $t1 = strtotime($a['timestamp']);
        $t2 = strtotime($b['timestamp']);
        return $t1 - $t2;
    }    
    usort($row, 'date_compare');

But i get error because of timestamp... Here is error Warning: Illegal string offset 'timestamp' in /home/...../domains/foxiad.com/public_html/...../modules/ticketsmith/index.php on line 365

  • 写回答

1条回答 默认 最新

  • douzhang7184 2015-07-09 09:34
    关注

    The output of array you are showing here looks generated by this kind of thing, which are all seperate arrays.

    while($row = mysql_fetch_row($variable))
    {
        print_r($row);
    }
    

    You need to build one seprate array, then perform a sort on it.

    while($row = mysql_fetch_row($variable))
    {
        $results[] = $row;
    }
    

    Then, you will be able to sort that, feeding $results to usort()

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥65 永磁型步进电机PID算法
  • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?
  • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
  • ¥15 如何处理复杂数据表格的除法运算
  • ¥15 如何用stc8h1k08的片子做485数据透传的功能?(关键词-串口)
  • ¥15 有兄弟姐妹会用word插图功能制作类似citespace的图片吗?
  • ¥15 latex怎么处理论文引理引用参考文献
  • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
  • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?
  • ¥15 乘性高斯噪声在深度学习网络中的应用