Please help me, I want to convert a simple SQL statement to Codeigniter
date($fromDate) BETWEEN vehicle_register.start_dt AND vehicle_register.end_dt
-
3What you have tried so far?Danish Ali– Danish Ali2019-05-10 05:24:43 +00:00Commented May 10, 2019 at 5:24
-
do you want the method chaining query?M.Hemant– M.Hemant2019-05-10 05:26:44 +00:00Commented May 10, 2019 at 5:26
-
stackoverflow.com/questions/12102195/…Elena Roman– Elena Roman2019-05-10 05:32:26 +00:00Commented May 10, 2019 at 5:32
Add a comment
|
1 Answer
Try this with Method chaining,
$this->db->select('*');
$this->db->from('yourTableName');
$this->db->where('date('.$fromDate.') >=', 'vehicle_register.start_dt');
// >= will get conditional date too so please keep it as your reqirement
$this->db->where('date('.$fromDate.') <=', 'vehicle_register.end_dt');
$query= $this->db->get();
if($query->num_rows() > 0){
//return $query->result();//according to your need
}else{
//return array();//according to your need
}
