Welcome Guest, Not a member yet? Register   Sign In
Database Num_rows()?
#3

If you are inĀ  a CI4 model you can use the
PHP Code:
$this->countAll() 
function.

Or if you used an instance of the base builder inside a model and you only want to count the rows that matches your criteria you can use
PHP Code:
$this->builder()->countAllResults(false
- the parameter false prevents the query from being reset.

you can find detailed information here https://codeigniter4.github.io/userguide...ng-results
Dirk B.
Abatrans Software
No SEO spam - see forum guidelines
Reply


Messages In This Thread
Database Num_rows()? - by stlake2011 - 03-02-2020, 11:15 AM
RE: Database Num_rows()? - by tweenietomatoes - 03-02-2020, 12:48 PM
RE: Database Num_rows()? - by abatrans - 03-02-2020, 01:04 PM
RE: Database Num_rows()? - by InsiteFX - 03-02-2020, 02:18 PM
RE: Database Num_rows()? - by stlake2011 - 03-02-2020, 03:21 PM
RE: Database Num_rows()? - by tweenietomatoes - 03-02-2020, 03:38 PM
RE: Database Num_rows()? - by stlake2011 - 03-02-2020, 04:09 PM
RE: Database Num_rows()? - by kilishan - 03-02-2020, 09:23 PM
RE: Database Num_rows()? - by sneakyimp - 12-28-2020, 04:32 PM
RE: Database Num_rows()? - by nonebeliever - 03-03-2020, 02:55 AM
RE: Database Num_rows()? - by lukmim - 07-20-2021, 12:49 AM
RE: Database Num_rows()? - by ojmichael - 12-29-2020, 04:45 PM



Theme © iAndrew 2016 - Forum software by © MyBB