+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: Database Num_rows()? (/showthread.php?tid=75662)
Pages:
1
2
RE: Database Num_rows()? - ojmichael - 12-29-2020
The php mysqli_num_rows function is just a wrapper for the native mysql_num_rows function - https://mariadb.com/kb/en/mysql_num_rows/
RE: Database Num_rows()? - lukmim - 07-20-2021
(03-03-2020, 02:55 AM)nonebeliever Wrote: MySQL has SQL_CALC_FOUND_ROWS which will calculate the total number of results within the same query used to fetch the result set.
SQL_CALC_FOUND_ROWS is deprecated since MySQL 8.0.17 (2019-07-22)