|
|
 |
mysql_list_dbs (PHP 3, PHP 4, PHP 5) mysql_list_dbs -- List databases available on a MySQL server Descriptionresource mysql_list_dbs ( [resource link_identifier] )
Returns a result pointer containing the databases available from the
current mysql daemon.
Parameters
-
link_identifier
The MySQL connection. If the
link identifier is not specified, the last link opened by
mysql_connect() is assumed. If no such link is found, it
will try to create one as if mysql_connect() was called
with no arguments. If by chance no connection is found or established, an
E_WARNING level warning is generated.
Examples
Example 1. mysql_list_dbs() example |
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$db_list = mysql_list_dbs($link);
while ($row = mysql_fetch_object($db_list)) {
echo $row->Database . "\n";
}
?>
|
The above example will output
something similar to: database1
database2
database3 |
|
NotesNote:
For downward compatibility, the following
deprecated alias may be used:
mysql_listdbs()
User Contributed Notes
mysql_list_dbs
fred at surleau dot com
16-Mar-2001 03:07
[Editor's Note: mysql_db_name(), mysql_dbname() and mysql_tablename() are all aliases for mysql_result() and should behave in exactly the same fashion. --zak@php.net]
Use mysql_db_name() instead of mysql_tablename() to read databases.
http://php.net/manual/en/function.mysql-db-name.php
| |
mysql_insert_id