PHP/MySQL Database/Table Database
Get all tables in a database
<source lang="html4strict">
<?php
mysql_connect("mysql153.secureserver.net","wbex","password"); $tables = mysql_list_tables("wbex"); $count = 0; while ($count < mysql_numrows($tables)) { echo mysql_tablename($tables,$count)."
"; $count++; }
?>
</source>
Listing Tables in a Database
<source lang="html4strict">
<? $connection = @mysql_connect("mysql153.secureserver.net", "wbex", "password") or die(mysql_error()); //get database list $dbs = @mysql_list_dbs($connection) or die(mysql_error()); //start first bullet list
$db_list = "- ";
$db_num = 0;
while ($db_num < mysql_num_rows($dbs)) {
$db_names[$db_num] = mysql_tablename($dbs, $db_num);
$db_list .= "
- $db_names[$db_num]";
//get table names and start another bullet list
$tables = @mysql_list_tables($db_names[$db_num]) or die(mysql_error());
$table_list = "
- ";
$table_num = 0;
while ($table_num < mysql_num_rows($tables)) {
//get table names and make each a bullet point
$table_names[$table_num] = mysql_tablename($tables, $table_num);
$table_list .= "
- $table_names[$table_num]"; $table_num++; } $table_list .= "
$db_list .= "$table_list"; $db_num++;
}
$db_list .= "
?> <HTML> <HEAD> <TITLE>MySQL Tables</TITLE> </HEAD> <BODY>
Databases and tables in a MySQL database:
<? echo "$db_list"; ?> </BODY> </HTML>
</source>