php - mysqli 查询 [事件记录 Codeigniter]

Question

i have a time-table as below

id 任务待办事项日期 待办事项时间状态
1 X 2015|9|19 21:10:1 0
2 是 2015|9|19 09:05:3 0
3 Z 2015|9|17 08:12:3 0
4 A 2015|9|16 23:10:5 0


where date is in Y|m|d format and Time is in 24 hrs format , status= 0 means not Done

让当前日期 2015|9|19 和时间 10:05:3现在，我希望获取到目前为止尚未完成的所有任务，这样结果可能如下所示，以及未完成任务的总数

id 任务待办事项日期 待办事项时间状态
2 是 2015|9|19 09:05:3 0
3 Z 2015|9|17 08:12:3 0
4 A 2015|9|16 23:10:5 0
未完成任务总数 =3


pls suggest be mysqli and CodeIgniter's Active-records query as-well for this.
Regards.....

Answer 1

您应该对事件记录尝试此操作:

$this->db->select();
$this->db->from('your_table_name');
$this->db->where('to-do-date <= ',date('Y-m-d'));
$this->db->where('to-do-time <= ',date('H:i:s'));
$this->db->where('status',0);
return $this->db->get()->result();

对于 mysqli:

$sql = "SELECT * FROM your_table_name WHERE to-do-date <= '".date('Y-m-d')."' AND to-do-time <= '".date('H:i:s')."' AND status = 0";