PHP mysql_db_name() Function
Complete PHP MySQL Reference
Definition and Usage
The mysql_db_name() function finds the database name from a call to the
mysql_list_dbs() function.
This function returns the database name on success, or FALSE on failure.
Syntax
mysql_db_name(list,row,field)
|
Parameter |
Description |
list |
Required. Specifies result pointer from the mysql_list_dbs()
function |
row |
Required. Specifies what row-index in the result pointer
to return. Starts at zero. |
field |
Optional. Specifies the field name |
Example
<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_list = mysql_list_dbs($con);
$i = 0;
$db_count = mysql_num_rows($db_list);
while ($i < $db_count)
{
echo mysql_db_name($db_list, $i) . "<br />";
$i++;
}
mysql_close($con);
?>
|
The output of the code above could be:
Complete PHP MySQL Reference
|