如何使用PHP查询MySQL中所有数据库的名称？
- 内容介绍
- 文章标签
- 相关推荐
本文共计124个文字，预计阅读时间需要1分钟。
尝试以下简化后的代码：
php$conn=@mysql_connect(localhost, userName, password) or die(Sorry - could not connect to MySQL);$rs=@mysql_list_dbs($conn) or die(Sorry - could not list databases);while ($row=mysql_num_rows($rs)) { $db=;}
<?php$conn = @mysql_connect( "localhost", "userName", "password" ) or die( "Sorry - could not connect to MySQL" ); $rs= @mysql_list_dbs( $conn ) or die( "Sorry - could not list databases" );for( $row=0; $row < mysql_num_rows($rs); $row++ ){ $db_list .= mysql_tablename( $rs, $row ) . "<br />"; } ?><html> <head> <title>Listing databases</title> </head> <body> <h3> <?php echo( $db_list ); ?> </h3> </body></html>
本文共计124个文字，预计阅读时间需要1分钟。
尝试以下简化后的代码：
php$conn=@mysql_connect(localhost, userName, password) or die(Sorry - could not connect to MySQL);$rs=@mysql_list_dbs($conn) or die(Sorry - could not list databases);while ($row=mysql_num_rows($rs)) { $db=;}
<?php$conn = @mysql_connect( "localhost", "userName", "password" ) or die( "Sorry - could not connect to MySQL" ); $rs= @mysql_list_dbs( $conn ) or die( "Sorry - could not list databases" );for( $row=0; $row < mysql_num_rows($rs); $row++ ){ $db_list .= mysql_tablename( $rs, $row ) . "<br />"; } ?><html> <head> <title>Listing databases</title> </head> <body> <h3> <?php echo( $db_list ); ?> </h3> </body></html>