Name
mysql_db_name( )
Synopsis
mysql_db_name(databases,number)
This returns
the name of the database from the results of the
mysql_list_dbs( ) function, which returns a
pointer to a results set containing the names of databases for a
MySQL server. The reference to the list of databases is given as the
first argument. A number identifying the row to retrieve from the
list is the second argument.
...
$databases = mysql_list_dbs( );
$dbs = mysql_num_rows($databases);
for($index = 0; $index < $dbs; $index++) {
print mysql_db_name($databases, $index) . "\n";
}
...In this script excerpt, a
results set containing a list of databases is retrieved and stored in
the $databases variable using the
mysql_list_dbs( ) function. That results set is
analyzed by mysql_num_rows( ) to determined the
number of records (i.e., the number of database names) that it
contains. Using a for statement and the number of
databases ($dbs), the script loops through the
results set contained in $databases. With each
pass, mysql_db_name( ) extracts the name of each
database by changing the second argument of the function as the value
of $index increments from 0 to the value of
$dbs.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
