Mysql databases store data in tables.
For storage of data in the database is necessary that it contains at least one created MySql table.
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>");
}
?>