PHP列出MySQL中所有数据库的方法
本文实例讲述了PHP列出MySQL中所有数据库的方法。分享给大家供大家参考。具体如下：
PHP代码如下：
<?php
define('NL',"\n");
define('TB','');
//connectingtoMySQL.
$conn=@mysql_connect('localhost','username','password')
ordie(mysql_errno().':'.mysql_error().NL);
//attempttogetalistofMySQLdatabases
//alreadysetupinmyaccount.Thisisdone
//usingthePHPfunction:mysql_list_dbs()
$result=mysql_list_dbs($conn);
//Outputthelist
echo'<ulclass="projects">'.NL;
///*USING:mysql_fetch_object()
//---------------------------
while($row=mysql_fetch_object($result)):
echoTB.'<li>'.$row->Database.'</li>'.NL;
endwhile;
//*/
/*USING:mysql_fetch_row()
//------------------------
while($row=mysql_fetch_row($result)):
echoTB.'<li>'.$row[0].'</li>'.NL;
endwhile;
//*/
/*USING:mysql_fetch_assoc()
//--------------------------
while($row=mysql_fetch_assoc($result)):
echoTB.'<li>'.$row['Database'].'</li>'.NL;
endwhile;
//*/
echo'</ul>'.NL;
//Freeresources/closeMySQLConnection
mysql_free_result($result);
mysql_close($conn);
?>
希望本文所述对大家的php程序设计有所帮助。