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程序设计有所帮助。