dryl34156 2018-11-08 09:29
浏览 83
已采纳

如何根据codeigniter中的时间戳获取数据?

I have a table call viewed books like below in database

book_id     user_uniq_id   date
3           111111         2018-11-06 00:29:15

like that so many rows I need to get book_id and user_uniq_id according to date

as a example this date these users viewed these books like that

How can I write a sql query for this in codeigniter

  • 写回答

2条回答 默认 最新

  • douju5933 2018-11-08 09:56
    关注

    I'm not sure if your question is clear enough, but from what i got you want a query based on the timestamp then you should try this.

    $timestamp = '2018-11-06 00:29:15';
    
    $this->db->select('book_id, user_uniq_id');
    
    $query = $this->db->get_where('table', array('date' => '>' . $timestamp));
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?