How to display all table names in a database?

Question

Im trying to echo out all table names in a specific database, but I can't find a working solution! Here is the code I have to far:

$sql = "SHOW TABLES FROM test";
$result1 = mysqli_query($conn, $sql);
$resultCheck = mysqli_num_rows($result1);
if ($resultCheck > 0){
    while ($row = mysqli_fetch_assoc($result1)){
        echo $row;
    }
}

Any help would be great!

score 2 · Accepted Answer · answered Apr 20 '19 at 09:50

2

The $row is coming as an array, so you have to fetch it as

echo $row['Tables_in_test']

answered Apr 20 '19 at 09:50

Rakesh Jakhar

6,380
2
11
20

Solved my problem!! Thanks so much – Sonder12 Apr 20 '19 at 10:41

score 1 · Answer 2 · answered Apr 20 '19 at 09:54

First of all, be sure not to ask for a database outside of what the user you are using is able to see (Therefore, make sure that the user can see other databases).

One that is figured out, this is the code

$sql = "SHOW TABLES FROM test";
$result1 = $conn->query($sql);
while ($row = mysqli_fetch_assoc($result1)){
  echo $row["Tables_in_test"];
}

How to display all table names in a database?

2 Answers2