CodeIgniter 查询返回具有多个 where 条件的行数

Question

SELECT COUNT(*) AS  numrows 
FROM (books)
WHERE (
    id_status =1
    OR id_status =2
)
AND  company =2

如何将其转换为 CI Active Record？

Answer 1

$this->db->select('count(*) as numrows')->from('books ')->where("(id_status='1' OR id_status='2') and company ='2'")

Answer 2

只需三个方法调用即可优雅地实现 SQL。返回的值将是 int 类型值（而不是具有 num_rows 属性的对象）。

return $this->db
    ->where('company', 2)
    ->where_in('id_status', [1, 2])
    ->count_all_results('books');