MYSQL_DB_NAME(3) 1 MYSQL_DB_NAME(3)
mysql_db_name - Retrieves database name from the call tomysql_list_dbs(3)
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. 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:
oQuery:
SELECT DATABASE()
string mysql_db_name (resource $result, int $row, [mixed $field = NULL])
DESCRIPTION
Retrieve the database name from a call to mysql_list_dbs(3).
o $result
- The result pointer from a call to mysql_list_dbs(3).
o $row
- The index into the result set.
o $field
- The field name.
Returns the database name on success, and FALSE on failure. If FALSE is returned, use mysql_error(3) to determine the nature of the error.
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.5.0 | |
| | |
| | The mysql_list_dbs(3) function is deprecated, |
| | and emits an E_DEPRECATED level error. |
| | |
+--------+---------------------------------------------------+
Example #1
mysql_db_name(3) 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) . "
";
$i++;
}
?>
Note
For backward compatibility, the following deprecated alias may be used: mysql_dbname(3)
mysql_list_dbs(3), mysql_tablename(3).
PHP Documentation Group MYSQL_DB_NAME(3)
