X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

PHP mysql_db_name() Function


PHP MySQL Reference 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:

mysql
customers
movies


PHP MySQL Reference Complete PHP MySQL Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates FREE Website Templates Free HTML Templates

SHARE THIS PAGE

facebook