Is there no longer a need for num

Is there no longer a need for num_rows()?

dave friend
Posting Freak
Posts: 1,015
Threads: 15
Joined: Jun 2015
Reputation: 50

08-13-2019, 05:10 AM

(08-13-2019, 04:20 AM)InsiteFX Wrote: The countAll method returns

PHP Code:
return (int) $query->numRows;

But countAll performs another query on the DB which the OP wants to avoid. That, and countAll() returns the count for the entire table without considering any "where" or "like" clauses.

Messages In This Thread

Is there no longer a need for num_rows()? - by tgix - 08-11-2019, 10:04 PM

RE: Is there no longer a need for num_rows()? - by dave friend - 08-12-2019, 02:17 AM

RE: Is there no longer a need for num_rows()? - by tgix - 08-12-2019, 02:54 AM

RE: Is there no longer a need for num_rows()? - by dave friend - 08-12-2019, 09:38 AM

RE: Is there no longer a need for num_rows()? - by InsiteFX - 08-13-2019, 04:20 AM

RE: Is there no longer a need for num_rows()? - by dave friend - 08-13-2019, 05:10 AM

RE: Is there no longer a need for num_rows()? - by Stormbringer - 10-18-2019, 04:53 AM

RE: Is there no longer a need for num_rows()? - by sneakyimp - 12-28-2020, 03:39 PM