2D Animation Development Company
Animation is becoming a crucial tool for branding, marketing, education, and other fields in today's digital age. Blazingcoders is a top 2D animation development company in India that specializes
Read More
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();
$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();
$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.
+91 ▼ Related Posts
Why Custom NewJaisa Software Development is the Future of Business Growth
In today’s fast-paced digital world, businesses require customized software solutions to stay competitive. Off-the-shelf software often lacks the flexibility and scalability that modern business
Read More
10 Good ways to Promote a Business Website for Getting More Sales
1. Search Engine Optimization: Search Engine Optimization is the way toward expanding your site's visibility in search engine natural traffic through upgrading your pages with the keyword phras
Read More