Database - list table [closed]

Question

Database - list table [closed]

Navigation

#1 by (2 votes)

0

How can I list all the DB table and put it in a table, list or any corner of the page?

php sql pdo

asked by anonymous 06.06.2016 / 13:46

1 answer

Sending form to two php files How do I activate LogCat?

score 2 · Accepted Answer

The method below will return all the tables in your DB.

 public function listTable(){
    $query = $this->pdo->query('SELECT * FROM INFORMATION_SCHEMA.TABLES');
    return $query->fetchAll(PDO::FETCH_COLUMN);   
}