Retrieving data between two dates in codeIngiter


To get the data between two dates in CodeIgniter, you can use the BETWEEN Operator. The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates. More


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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s