PHP CodeIgniter Count Rows in Table

Breadcrumb Breadcrumb

PHP CodeIgniter Count Rows in Table

The most effective method to tally question results and number of columns in table in codeigniter. On occasion you might be keen on knowing the quantity of lines in a table as opposed to bringing the actual records. Or then again to know whether your sql question really restores any records whatsoever. While you can check it utilizing select question, there are better approaches to take care of business in codeingniter.

There are two ways to count query results in codeigniter.

  •  Function: num_rows()
  •  Function: count_all_results()


1. Function: num_rows()

This function counts the number of rows returned by a sql query

$this->db->where('ID >=', 5);
$query = $this->db->get('yourtablename');
echo $query->num_rows();


2. Function: count_all_results()

The count_all_results() method is another way to determine the number of rows returned by a particular Active Record query. 

$this->db->select('*');
$this->db->from('yourtablename');
$this->db->like('filedname1', 'filedname2');
echo $this->db->count_all_results();

CodeIgniter - Count Number of Rows in Table:

If you want to count just the number of rows in a database table you can use the function $this->db->count_all().

echo $this->db->count_all('yourtablename');

Confused about your business model?

Request a FREE Business Plan.

India +91 ▼

Tags

  • How to display count in Codeigniter

  • Codeigniter count rows in view

  • Codeigniter count rows in controller

  • Row count Codeigniter
  • this->db->get count Codeigniter

  • Codeigniter get count table

  • Codeigniter count query results

  • Codeigniter get all data from table

Related Posts

Top IT Staff Contract Augmentation Services in Bangalore
Hire Us | Software Development |

Top IT Staff Contract Augmentation Services in Bangalore

Bangalore, often referred to as the Silicon Valley of India, is home to a thriving IT ecosystem. Companies in this tech hub constantly seek skilled professionals to enhance their teams and drive busin

Read More
Hire Shopify Experts & Developers In India
Hire Us | eCommerce |

Hire Shopify Experts & Developers In India

Blazingcoders: Your Trusted Shopify Development Partner In the cutthroat world of e-commerce, having a strong, feature-rich, and aesthetically pleasing store is essential. Shopify is one of the bes

Read More
Software Utility Development
Software Development | Web Development |

Software Utility Development

Utility can be the major factors for the growth and development of any business. the requirment for utility may vary from industry to industry or from econimic or management point of view. utility and

Read More