W3Schools.com

HOME HTML CSS XML JAVASCRIPT ASP PHP SQL MORE...

REFERENCES | EXAMPLES | FORUM | ABOUT

PHP Basic

PHP HOME
PHP Intro
PHP Install
PHP Syntax
PHP Variables
PHP String
PHP Operators
PHP If...Else
PHP Switch
PHP Arrays
PHP While Loops
PHP For Loops
PHP Functions
PHP Forms
PHP $_GET
PHP $_POST

PHP Advanced

PHP Date
PHP Include
PHP File
PHP File Upload
PHP Cookies
PHP Sessions
PHP E-mail
PHP Secure E-mail
PHP Error
PHP Exception
PHP Filter

PHP Database

MySQL Introduction
MySQL Connect
MySQL Create
MySQL Insert
MySQL Select
MySQL Where
MySQL Order By
MySQL Update
MySQL Delete
PHP ODBC

PHP XML

XML Expat Parser
XML DOM
XML SimpleXML

PHP and AJAX

AJAX Intro
AJAX PHP
AJAX Database
AJAX XML
AJAX Live Search
AJAX RSS Reader
AJAX Poll

PHP Reference

PHP Array
PHP Calendar
PHP Date
PHP Directory
PHP Error
PHP Filesystem
PHP Filter
PHP FTP
PHP HTTP
PHP Libxml
PHP Mail
PHP Math
PHP Misc
PHP MySQL
PHP SimpleXML
PHP String
PHP XML
PHP Zip

PHP Quiz

PHP Quiz
PHP Certificate

PHP mysql_list_dbs() Function

PHP MySQL Reference

Complete PHP MySQL Reference

Definition and Usage

The mysql_list_dbs() function finds the available databases on a MySQL server for a given connection.

This function returns a result pointer containing the available databases on success, or FALSE on failure.

Syntax

mysql_list_dbs(connection)

Parameter	Description
connection	Optional. Specifies the MySQL connection. If not specified, the last connection opened by mysql_connect() or mysql_pconnect() is used.

Example

<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$db_list = mysql_list_dbs($con);

while ($db = mysql_fetch_object($db_list))
  {
  echo $db->Database . "<br />";
  }

mysql_close($con);
?>

The output of the code above could be:

mysql
test
test_db

PHP MySQL Reference

Complete PHP MySQL Reference

WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Best Hosting Coupons
UK Reseller Hosting
Cloud Hosting
Top Web Hosting
$3.98 Unlimited Hosting
Premium Website Design

WEB BUILDING
XML Editor - Free Trial!
FREE Website BUILDER
Best Website Templates Top CSS Templates
CREATE HTML Websites
EASY WEBSITE BUILDER

W3SCHOOLS EXAMS
Get Certified in: HTML, CSS, JavaScript, XML, PHP, and ASP

W3SCHOOLS BOOKS
New Books: HTML, CSS JavaScript, and Ajax

STATISTICS
Browser Statistics Browser OS Browser Display

SHARE THIS PAGE
Share with »