PHP method for listing all databases in MySQL

This article mainly introduces PHP methods for listing all databases in MySQL. it involves php database operations and is of great practical value, for more information about how to use PHP to list all databases in MySQL, see the following example. Share it with you for your reference. The details are as follows:

The PHP code is as follows:

<?phpdefine( 'NL', "\n" );define( 'TB', ' ' );// connecting to MySQL.$conn = @mysql_connect( 'localhost', 'username', 'password' )    or die( mysql_errno().': '.mysql_error().NL );// attempt to get a list of MySQL databases// already set up in my account. This is done// using the PHP function: mysql_list_dbs()$result = mysql_list_dbs( $conn );// Output the listecho '
 
 

  
  '.NL; ///* USING: mysql_fetch_object() // --------------------------- while( $row = mysql_fetch_object( $result ) ):  echo TB.'
  
  
'.$row->Database.'
'.NL; endwhile; //*/ /* USING: mysql_fetch_row() // ------------------------ while( $row = mysql_fetch_row( $result ) ):  echo TB.'
  
  
'.$row[0].'
'.NL; endwhile; //*/ /* USING: mysql_fetch_assoc() // -------------------------- while( $row = mysql_fetch_assoc( $result ) ):  echo TB.'
  
  
'.$row['Database'].'
'.NL; endwhile; //*/echo '
 
 
'.NL;// Free resources / close MySQL Connectionmysql_free_result( $result );mysql_close( $conn );  ?>

I hope this article will help you with php programming.