CHF站长论坛 - 查看单个帖子

小叶 · 2005-09-08, 17:44

列举处数据库中存在的表..

从刚才上一节列出的数据库里读取表..

PHP 代码:


			
<?

//connection code

$connection = @mysql_connect("localhost", "root", "")

     or die(mysql_error());



//get database list

$dbs = @mysql_list_dbs($connection) or die(mysql_error());



//start first bullet list

$db_list = "<ul>";

$db_num = 0;



//loop through results of function

while ($db_num < mysql_num_rows($dbs)) {

     //get database names and make each a bullet point

$db_names[$db_num] = mysql_tablename($dbs, $db_num);

     $db_list .= "<li>$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 = "<ul>";

     $table_num = 0;



     //loop through results of function

     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 .= "<li>$table_names[$table_num]";

          $table_num++;

     }

     //close inner bullet list and increment number to continue loop

     $table_list .= "</ul>";

     $db_list .= "$table_list";

     $db_num++;

}

//close outer bullet list

$db_list .= "</ul>";

?>

<HTML>

<HEAD>

<TITLE>MySQL Tables</TITLE>

</HEAD>

<BODY>

<P><strong>Databases and tables on localhost</strong>:</P>

<? echo "$db_list"; ?>

</BODY>

</HTML>

2005-09-08, 17:44	#3 (页面定位)
小叶注册日期: 2005-09-04 住址: 火星人帖子: 17779	Listing Tables in a Database 列举处数据库中存在的表.. 从刚才上一节列出的数据库里读取表.. PHP 代码: <? //connection code $connection = @mysql_connect("localhost", "root", "") or die(mysql_error()); //get database list $dbs = @mysql_list_dbs($connection) or die(mysql_error()); //start first bullet list $db_list = "<ul>"; $db_num = 0; //loop through results of function while ($db_num < mysql_num_rows($dbs)) { //get database names and make each a bullet point $db_names[$db_num] = mysql_tablename($dbs, $db_num); $db_list .= "<li>$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 = "<ul>"; $table_num = 0; //loop through results of function 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 .= "<li>$table_names[$table_num]"; $table_num++; } //close inner bullet list and increment number to continue loop $table_list .= "</ul>"; $db_list .= "$table_list"; $db_num++; } //close outer bullet list $db_list .= "</ul>"; ?> <HTML> <HEAD> <TITLE>MySQL Tables</TITLE> </HEAD> <BODY> <P><strong>Databases and tables on localhost</strong>:</P> <? echo "$db_list"; ?> </BODY> </HTML> 匆匆人生中,你做了几件令自己骄傲的事呢?