Why professional website required for your business?
Website is like your asserts and nowadays everything is online world moved faster day by day with various of advance technology. Website is a basic need for your business, having a prof
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');
Related Posts
how to optimize OpenCart website ?
Ways to Speed up OpenCart website There are several ways to Optimize OpenCart website that help improve your site's speed and performance. The procedures below show you how to do this so
Read MoreP
PHP Code Check time difference is between two time slots
We are going to explain how to get the time difference between timeslots. below are the simple example given to get the time difference between the two given slots. As you can see we have used the inb
Read More