如何使用 Codeigniter 的查询生成器方法编写 BETWEEN 条件？

Question

如何在与活动记录类似的之间编写选择查询？

SELECT *
FROM test_tbl
WHERE date BETWEEN '$start' and '$end'
ORDER BY ID

Answer 1

AFAIK，没有内置支持 BETWEEN

您可以这样做

$this->db->where("date BETWEEN '$start' AND '$end'");
$this->db->get("test_tbl");  

或者编写一个如下所示的辅助函数

function where_between($field, $min, $max){
     $CI = get_instance();
     return $CI->db->where("`$field` BETWEEN '$min' AND '$max'");
}  

稍后，您可以通过调用它来使用该函数，例如 where_ Between('test_tbl ', $开始, $结束)