列出服务器上Mysql的所有的数据库
PHP 代码:
<?
$connection = @mysql_connect("localhost", "root", "")
or die(mysql_error());
$dbs = @mysql_list_dbs($connection)or die(mysql_error());
$db_list ="<ul>";
$i =0;
while ($i < mysql_num_rows($dbs)){
$db_names[$i] = mysql_tablename($dbs,$i);
$db_list .= "<li>$db_names[$i]";
$i++;
}
$db_list .="</ul>";
?>
<HTML>
<HEAD>
<TITLE>MySQL Databases</TITLE>
</HEAD>
<BODY>
<P><strong>Databases on localhost</strong>:</P>
<? echo "$db_list"; ?>
</BODY>
</HTML>
三关键的函数
引用:
mysql_list_dbs()— Used to list the databases on a MySQL server.
mysql_num_rows()— Returns the number of rows in a result set.
mysql_tablename()— Despite its name, can extract the name of a table or a database from a result.
|