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
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
|
|
Printer friendly page
