phpdatecodeigniterquery-builderbetween

In codeigniter how can i find data between two dates

how to fetch data between two dates in php

$this->db->select('*');
$this->db->from('table_name');
this-> db ->where('t_deadline' between $start_deadline and $end_deadline);

but this query not execute.

Solution 
  • $this->db->where('order_date >=', $first_date);
$this->db->where('order_date <=', $second_date);
return $this->db->get('orders');