Listing the Databases Available in a Connection : MySQL Connection « MySQL Database « PHP






  1. PHP
  2. MySQL Database
  3. MySQL Connection

Listing the Databases Available in a Connection




<html>
<head>
<title>Listing the databases available in a connection</title>
</head>
<body>
<?php
$user = "java2s";
$pass = "password";
$link =  mysql_connect( "mysql153.secureserver.net", $user, $pass );
if ( ! $link )
    die( "Couldn't connect to MySQL" );

$db_res = mysql_list_dbs( $link );
$num = mysql_num_rows( $db_res );

for( $x = 0; $x < $num; $x++ )
    print mysql_tablename( $db_res, $x )."<br>";

mysql_close( $link );
 ?>
</body>
</html>








Related examples in the same category

1.Connect To MySQL Database
2.Connect to MySQL
3.Opening a Connection and Selecting a Database