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