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


Using SQL IN Operator with PHP Array

Using SQL IN operator with PHP array

Suppose we have a array named ‘id_array’ which contains id’s. Now, in order to get all the records from our MySQL table using this array of id, we can use the below given code :

SELECT * FROM TABLE WHERE id IN (".implode(',',$id_array).")