Call Now

WhatsApp

Go back
to top

Arrow Icon
Site Logo

PHP CodeIgniter Count Rows in Table

Shape Image Layout Star Icon Star Icon

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

PHP CodeIgniter Count Rows in Table

PSD to WordPress Conversion & Theme Integration

Turn your PSD file into WordPress theme In this is tutorial we are going to explain How to integr

Read More

Google webmaster temporarily unreachable

From what I’ve read and seen, CloudFront does not consistently identify itself in requests. Bu

Read More
PHP CodeIgniter Count Rows in Table

How to fix JavaScript is parsed during initial page load

What is site page rendering?  Delivering is where everything the assets needed to show a pag

Read More