php codeigniter count rows

Question

I am new in codeigniter  I want to count all rows from database table but the query dose not retrieve the exact total of rows  Here is Model  public function countRow     query    this- gt db- gt query  SELECT   count id  AS num of time FROM home           print r  query- gt result         return  query- gt result        and this is the controller  public function countTotalrow          data  query      this- gt home model- gt countRow         this is the view  foreach   num of time as  row        lt span gt  lt  php print r  row- gt id    gt  lt  span gt

User · Answer

If you really want to count all rows  You can use this in model function    this- gt db- gt select  count        query    this- gt db- gt get  home     cnt    query- gt row array    return  cnt  count         It returns single value  that is row count

User · Answer

Try This     I created my on model of count all results  in library model  function count all results  column name   array    where array     table name   array               this- gt db- gt select  column name              If Where is not NULL         if  empty  where   amp  amp  count  where   gt  0                          this- gt db- gt where  where                        Return Count Column         return  this- gt db- gt count all results  table name 0     table name array sub 0     Your Controller will look like this  public function my method        data   array        countall    this- gt model- gt your method model            this- gt load- gt view  page   data       Then Simple Call The Library Model  In Your Model  function your method model             return  this- gt library model- gt count all results                   id                     where                    table name

User · Answer

You could use the helper function  query- gt num rows    It returns the number of rows returned by the query  You can use like this    query    this- gt db- gt query  SELECT   FROM my table    echo  query- gt num rows

User · Answer

To count all rows in a table    Controller     function id cont         news data   new news model        ids  news data- gt data model       print r  ids       Model     function data model          this- gt db- gt select            this- gt db- gt from  news data         id    this- gt db- gt get  - gt num rows        return  id

User · Answer

This is what is did that solved the same problem  I solved it by creating a function that returns the query result thus   function getUsers     query    this- gt db- gt get  users    return  query- gt result          The above code can go in the user model or whatever your model is   This allows me to use one function for the result and number of returned rows   Use this code below in your contoller where you need the count as well as the result array       This gives you the user count using the count function which returns and integer of the exact rows returned from the query   this- gt data  user count     count  this- gt user model- gt getUsers        This gives you the returned result array   this- gt data  users      this- gt user model- gt getUsers      I hope this helps

User · Answer

You may try this one          this- gt db- gt where  field1   filed1        this- gt db- gt where  filed2   filed2        result    this- gt db- gt get  table name  - gt num rows

User · Answer

Use this code    this- gt db- gt where   id   gt 2  - gt from  table name  - gt count all results     or   this- gt db- gt from  table name  - gt count all results

User · Answer

public function record count        return  this- gt db- gt count all  tablename

User · Answer

replace the query inside your model function with this   query    this- gt db- gt query  SELECT id FROM home      in view   echo  query- gt num rows

User · Answer

public function number row           query    this- gt db- gt select  count user details id  as number                          - gt get  user details                        if  query- gt  num rows   gt 0                    return  query- gt row                   else                   return false

[php] php codeigniter count rows

Examples related to php

Examples related to codeigniter