CodeIgniter query to return the row count with multiple where conditions

Question

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

How can this be converted to CI Active Record?

Muhammad Usman · Accepted Answer · 2011-10-05 07:15:13Z

1

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

answered Oct 5, 2011 at 7:15

Muhammad Usman

12.5k6 gold badges39 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

uzsolt Over a year ago

If the result is enough can use count_all_results instead of select and can split where into two parts.

mickmackusa · Accepted Answer · 2024-08-27 10:51:23Z

0

Your SQL is elegantly achieved with just three method calls. The returned value will be an int type value (not an object with a num_rows property).

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

answered Aug 27, 2024 at 10:51

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

Collectives™ on Stack Overflow

CodeIgniter query to return the row count with multiple where conditions

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related