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

Question

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

Answer 1

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));