How to do a num rows on COUNT query in codeigniter

Question

This works            sql    SELECT id                 FROM  users                  WHERE  account status          i                  query    this- gt db- gt query  sql           var dump  query- gt num rows       But this doesn t            sql    SELECT COUNT                    FROM  users                  WHERE  account status          i                  query    this- gt db- gt query  sql           var dump  query- gt num rows       How to do a num rows on a COUNT    query  Also is doing it the 2nd way any better performance wise

User · Answer

list data    this- gt Estimate items model- gt get details array  estimate id    gt   id  - gt result         result   array         counter   0       templateProcessor- gt cloneRow  Title   count  list data        foreach  list data as  row             counter             templateProcessor- gt setValue  Title    counter   row- gt title            templateProcessor- gt setValue  Description    counter   row- gt description            type    row- gt unit type    row- gt unit type                templateProcessor- gt setValue  Quantity    counter  to decimal format  row- gt quantity           type            templateProcessor- gt setValue  Rate    counter  to currency  row- gt rate   row- gt currency symbol             templateProcessor- gt setValue  Total    counter  to currency  row- gt total   row- gt currency symbol

User · Answer

Doing a COUNT    will only give you a singular row containing the number of rows and not the results themselves   To access COUNT    you would need to do   result    query- gt row array     count    result  COUNT         The second option performs much better since it does not need to return a dataset to PHP but instead just a count and therefore is much more optimized

User · Answer

As per CI Docs we can use the following     this- gt db- gt where  account status    i      OTHER CONDITIONS IF ANY  this- gt db- gt from  account status      TABLE NAME echo  this- gt db- gt count all results      If we want to get total rows in the table without any condition  simple use  echo  this- gt db- gt count all results  table name       returns total rows presented in the table

User · Answer

In CI it s really simple actually  all you need is   this- gt db- gt where  account status    i    num rows    this- gt db- gt count all results  users    var dump  num rows      prints the number of rows in table users with account status  i

User · Answer

num rows on your COUNT   query will literally ALWAYS be 1  It is an aggregate function without a GROUP BY clause  so all rows are grouped together into one  If you want the value of the count  you should give it an identifier SELECT COUNT    as myCount      then use your normal method of accessing a result  the first  only result  and get it s  myCount  property

User · Answer

This will only return 1 row  because you re just selecting a COUNT    you will use mysql num rows   on the  query in this case   If you want to get a count of each of the ID s  add GROUP BY id to the end of the string   Performance-wise  don t ever ever ever use   in your queries  If there is 100 unique fields in a table and you want to get them all  you write out all 100  not    This is because   has to recalculate how many fields it has to go  every single time it grabs a field  which takes a lot more time to call

User · Answer

I d suggest instead of doing another query with the same parameters just immediately running a SELECT FOUND ROWS

User · Answer

query- gt num rows     The number of rows returned by the query  Note  In this example   query is the variable that the query result object is assigned to    query    this- gt db- gt query  SELECT   FROM my table     echo  query- gt num rows

[php] How to do a num_rows() on COUNT query in codeigniter?

Examples related to php

Examples related to mysql

Examples related to codeigniter