This is simple PHP script which shows all the tables of a database. You just need to provide database details. It can be helpful if we just have database details and do not know about the database tables.

showtables.php

<?php

$db = 'database'; //Database name 
$host = 'host'; //Hostname or Server ip
$user = 'database_user'; //Database user
$pass = 'password'; //Database user password

$con = mysql_connect($host,$user,$pass);
if($con){

	$link = mysql_select_db($db) or die("no database").mysql_error();
	$count = 0;
	if($link){
		$sql = "SHOW TABLES FROM `$db`";
		$result = mysql_query( $sql, $con);

		if(mysql_query($sql,$con)){
				echo $sql."<br> <br>";
			while ($row = mysql_fetch_row($result)) {
    			echo "Table ".++$count.": {$row[0]}<br>";
    			$table_name = $row[0];
			}
			echo "<br>Total No. of Tables: " . $count;
		}
		else{
			echo "Error in query.";
		}
	}
	else{
		echo "Database not found.";
	}
}
else{
	echo "Connection Failed.";
}

?>