[CI - Database] Count number of rows in a table using table SCHEMA

Please login or create account to add a snippet.

Follow @TagMyCode

Language: PHP

Posted by: Dylan Lopez

Added: Mar 5, 2018 9:16 AM

Tags: codeigniter database query

$sql = "SELECT * FROM `information_schema`.`TABLES` WHERE `table_name` = '".$table."';";
$query = $this->db->query($sql);
$result = $query->row_array(); //return array
$total_id = $result['TABLE_ROWS'];