PHP CodeIgniter Count Rows in Table
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
$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->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().
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
Blog Category
Related Posts
Custom T-Shirt ECommerce Website Development Company
Blazingcoders is an eCommerce Website Development Company. We specially design and develop a Custom
Read More
WHY DOES ALUMNI MANAGEMENT SOFTWARE BOOST CULTURE AND PRODUCTIVITY?
HR departments throughout the world may benefit from making a deliberate long-term investment in alu
Read More
Upload CSV files and import to Database using Laravel PHP
In this article, we are how to upload CSV file from a system and import in the database using Larave
Read More