MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
mysql_db_name
Retrieves database name from the call to
mysql_list_dbs
This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
Query: SELECT DATABASE()
|
string mysql_db_name(resource result,
int row,
mixed field= =NULL);
Retrieve the database name from a call to
mysql_list_dbs
.
result
The result pointer from a call to
mysql_list_dbs
.
row
The index into the result set.
field
The field name.
Returns the database name on success, and
false
on failure. If
false
is returned, use
mysql_error
to determine the nature of the error.
Version | Description |
---|---|
5.5.0 | The
mysql_list_dbs
function is deprecated, and emits an
E_DEPRECATED level error. |
Example 6.11 mysql_db_name
example
<?php error_reporting(E_ALL); $link = mysql_connect('dbhost', 'username', 'password'); $db_list = mysql_list_dbs($link); $i = 0; $cnt = mysql_num_rows($db_list); while ($i < $cnt) { echo mysql_db_name($db_list, $i) . "\n"; $i++; } ?>
For backward compatibility, the following deprecated alias may
be used: mysql_dbname
mysql_list_dbs
|
mysql_tablename
|