如何使用 between 将简单的 SQL 查询转换为 CodeIgniter？

Question

请帮助我，我想将一个简单的 SQL 语句转换为 Codeigniter

date($fromDate) BETWEEN vehicle_register.start_dt AND vehicle_register.end_dt

Answer 1

试试这个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){&nbsp; //return $query->result();//according to your need}else{&nbsp; //return array();//according to your need}