difference between query num rows and this- db- count all results in CodeIgniter which one is recommended

Question

In a scenario I need to know the count of recordset a query will return  which in codeigniter can be done by  query- gt num rows   or  this- gt db- gt count all results    Which one is better and what is the difference between these two

User · Answer

Simply as bellow    this- gt db- gt get  table name  - gt num rows      This will get number of rows records  however you can use search parameters as well    this- gt db- gt select  col1   col2  - gt where  col   gt  crieterion  - gt get  table name  - gt num rows      However  it should be noted that you will see bad bad errors if applying as below    this- gt db- gt get  table name  - gt result  - gt num rows

User · Answer

this- gt db- gt count all results is part of an Active Record query  preparing the query  to only return the number  not the actual results     query- gt num rows   is performed on a resultset object  after returning results from the DB

User · Answer

Total number of results   this- gt db- gt count all results  table name

User · Answer

There are two ways to count total number of records that the query will return  First this     query    this- gt db- gt query  select blah blah      return  query- gt num rows      This will return number of rows the query brought   Second  return  this- gt db- gt count all results  select blah blah      Simply count all results will require to run the query again

User · Answer

Which one is better and what is the difference between these two Its almost imposibble to me  someone just want to get the number of records without re-touching or perform another query which involved same resource  Furthermore  the memory used by these two function is in same way after all  since with count all result you still performing get  in CI AR terms   so i recomend you using the other one  or use count   instead  which gave you reusability benefits

User · Answer

We can also use   return  this- gt db- gt count all  table name        or   this- gt db- gt from  table name    return  this- gt db- gt count all result      or  return  this- gt db- gt count all result  table name      or   query    this- gt db- gt query  select   from tab      return  query- gt num rows

User · Answer

sql    select count    as row from login WHERE firstname         username      AND password         password             query    this- gt db- gt query  sql       print r  query  exit      if   query- gt num rows      1        return true        else       return false

User · Answer

With num rows   you first perform the query  and then you can check how many rows you got  count all results   on the other hand only gives you the number of rows your query would produce  but doesn t give you the actual resultset      num rows example  this- gt db- gt select        this- gt db- gt where  whatever     query    this- gt db- gt get  table     num    query- gt num rows       here you can do something with  query     count all example  this- gt db- gt where  whatever     num    this- gt db- gt count all results  table       here you only have  num  no  query

[php] difference between $query>num_rows() and $this->db->count_all_results() in CodeIgniter & which one is recommended

Examples related to php

Examples related to codeigniter