Mysql databases store data in tables.
For storage of data in the database is necessary that it contains at least one created MySql table.


Show lists tables on MySql database

SQL SHOW TABLES FROM $dbname
This function retrieves a list of table names from a MySQL database.


<?php
 $dbhost = "localhost"; 
 $dbuser = "yourusername"; 
 $dbpass = "yourpassword"; 
 $dbname = "yourdatabase";
 $connection= mysqli_connect ($dbhost, $dbuser, $dbpass,$dbname);
 if (!$connection)
 {
 die ("Could not connect:" . mysqli_error());
 }

$showtables= mysqli_query($connection, "SHOW TABLES FROM $dbname");
 while($table = mysqli_fetch_array($showtables)) { 
  echo($table[0] . "<br>");  
 }
?>