我想在codeigniter中显示我的数据库中的表

Question

$this->db->query("show tables");    
$tables = $this->db->get();    
return $tables->result_array();

Error Number: 1096
No tables used
SELECT *

Answer 1

Use $this->db->list_tables() to get all the tables name from database.

$tables = $this->db->list_tables();

foreach ($tables as $table)
{
        echo $table;
}

For more see docs Codeigniter Metadata