mySQL mySQL Table check Code Library

<html>
<head>
<title>PHP MySQL Test</title>
</head>
<body>


<h3>MySQL Test</h3>

<?php
 // Syntax: chktable.php?db=<db>&host=<host>

 $mysql_user_name = "root";
 $mysql_user_pass = "";

 if (isset($_GET['db']))
 $mysql_db = $_GET['db'];
 else
 $mysql_db = "test";
 if (isset($_GET['host']))
 $mysql_server = $_GET['host'];
 else
 $mysql_server = "localhost";

 print "Try to establish connection to mySQL server $mysql_server database $mysql_db... \n";
 $link = mysql_connect($mysql_server, $mysql_user_name, $mysql_user_pass) or die("Could not connect to MySQL database");
 $result = mysql_list_tables($mysql_db);

 for ($i = 0; $i < mysql_num_rows($result); $i++)
 printf ("Table: %s \n", mysql_tablename($result, $i));

 mysql_free_result($result);
 mysql_close($link);
?>

</body>

</html>