Logo

Office Address

123/A, Miranda City Likaoli
Prikano, Dope

Phone Number

+0989 7876 9865 9

+(090) 8765 86543 85

Email Address

info@example.com

example.mail@hum.com

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');

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

Online Shopping Website Development Company

Online Shopping Website Development Company

Blazingcoders is a Shopping e-commerce website development company. We develop a shopping website with a variety of open source technologies open cart, Woocommerce, Shopify, Magento, PrestaShop, Openc

Read More
H

Hire Web Developer & Web Designers Mumbai

We are Experts from Mumbai, India providing highly professional Web developer in Mumbai location. We provide Software developer and Web programmer to work on your projects and provide 24 * 7 deve

Read More
Create Wikipedia Page For Your Company

Create Wikipedia Page For Your Company

Blazingcoders is a digital marketing company. well experienced in Wikipedia page creation for corporates. Wikipedia gets some great results on Google. It usually appears near to the top of Google sear

Read More