How to retrieve data between two dates in PHP codeingiter?

Question

i am retrieving data between two date range and i am getting records also but when i select start date same as end date it is giving me blank even though i have record of that date in database table, only those records have different time.If anyone know solution please let me know.Below is my query to fetch records between date range. Thanks in advance.

$this->db->select('*');
    $this->db->from('transaction_tbl');
    $this->db->where('user_id',$user_id);
    $this->db->where('date >=',$startDate);
    $this->db->where('date <=',$endDate); 
    $query = $this->db->get();

Kundan Prasad · Accepted Answer · 2017-07-21 06:58:01Z

1

you need to specify time also between two dates

$startDate=date("Y m d",strtotime($startDate)).' 00:00'; //00:00 start day time
$endDate=date("Y m d",strtotime($endDate)).' 23:59'; //23:59 end day time
$this->db->select('*');
$this->db->from('transaction_tbl');
$this->db->where('user_id',$user_id);
$this->db->where('date >=',$startDate);
$this->db->where('date <=',$endDate); 
$query = $this->db->get();

answered Jul 21, 2017 at 6:58

Kundan Prasad

5665 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mickmackusa Apr 1 at 12:26

Why not add the time suffixes to the first parameter of date()? select('*') never needs to be written in CodeIgniter -- it is the default. This whole script can be written with get_where() alone.

Akshit Ahuja · Accepted Answer · 2017-07-21 06:38:49Z

0

try this

$this->db->query("SELECT * FROM transaction_tbl WHERE user_id = '$user_id' && date BETWEEN '$startDate' AND '$endDate'");

answered Jul 21, 2017 at 6:38

Akshit Ahuja

3372 silver badges16 bronze badges

3 Comments

user7596840 Over a year ago

thanks for suggesting answer but even though it is not fetching records

Akshit Ahuja Over a year ago

$endDate1 = date("Y-m-d", strtotime("+1 days", strtotime($endDate)));

Akshit Ahuja Over a year ago

then $this->db->query("SELECT * FROM transaction_tbl WHERE user_id = '$user_id' && date BETWEEN '$startDate' AND '$endDate1'");

Jaydeep Dobariya · Accepted Answer · 2017-07-21 06:48:23Z

0

$this->db->select('*');
    $this->db->from('transaction_tbl');
    $this->db->where('user_id',$user_id);
    $this->db->where('date <=',$startDate);
    $this->db->where('date >=',$endDate); 
    $query = $this->db->get();

answered Jul 21, 2017 at 6:48

Jaydeep Dobariya

781 silver badge5 bronze badges

Comments

dipti · Accepted Answer · 2017-07-21 10:48:54Z

0

Try this in your model.

function your_model($user_id,$startDate,$endDate){
$query=$this->db->query("SELECT * FROM transaction_tbl WHERE user_id = 
$user_id && date BETWEEN $startDate AND $endDate");
return $query->result_array();
}

answered Jul 21, 2017 at 10:48

dipti

717 bronze badges

Collectives™ on Stack Overflow

How to retrieve data between two dates in PHP codeingiter?

4 Answers 4

1 Comment

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related