Codeigniter : Retriving data between two dates from database

Asked Apr 04 '15 at 12:07

Active Apr 04 '15 at 12:25

Viewed 1,829 times

How can I retrieve data from the database by querying records between two dates using codeigniter?

Here is my code :

   function date_employee_details($id,$fdate,$sdate)
   {
    $this->db->select('*');
    $this->db->where('user_id',$id);
    $this->db->where('dates >=',$fdate);
    $this->db->where('dates <=',$sdate);
    return $this->db->get('attendance');
    }

but i got an error :

A PHP Error was encountered
Severity: Notice
Message: Undefined variable: fdate
Filename: models/admin.php
Line Number: 726

thanks

edited Apr 04 '15 at 12:25

asked Apr 04 '15 at 12:07

Uraj

echo $fdate at the top of query and check what it return. – Saty Apr 04 '15 at 12:18
2

`$fdata` -> `$fdate` – TiiJ7 Apr 04 '15 at 12:19
ya i saw that.it`s return date. which date choose by user – Uraj Apr 04 '15 at 12:21
possible dupe: http://stackoverflow.com/q/4261133/3933332 – Rizier123 Apr 04 '15 at 12:21

Codeigniter : Retriving data between two dates from database

0 Answers0