mysql_list_dbs

(PHP 4, PHP 5)

mysql_list_dbsList databases available on a MySQL server

Увага

This function was deprecated in PHP 5.4.0, and it and the entire original MySQL extension was removed in PHP 7.0.0. Instead, use either the actively developed MySQLi or PDO_MySQL extensions. See also the MySQL: choosing an API guide and its related FAQ entry for additional information. Alternatives to this function include:

  • SQL Query: SHOW DATABASES

Опис

resource mysql_list_dbs ([ resource $link_identifier = NULL ] )

Returns a result pointer containing the databases available from the current mysql daemon.

Параметри

link_identifier

The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect() is assumed. If no such link is found, it will try to create one as if mysql_connect() was called with no arguments. If no connection is found or established, an E_WARNING level error is generated.

Значення, що повертаються

Returns a result pointer resource on success, or FALSE on failure. Use the mysql_tablename() function to traverse this result pointer, or any function for result tables, such as mysql_fetch_array().

Приклади

Приклад #1 mysql_list_dbs() example

<?php
// Usage without mysql_list_dbs()
$link mysql_connect('localhost''mysql_user''mysql_password');
$res mysql_query("SHOW DATABASES");

while (
$row mysql_fetch_assoc($res)) {
    echo 
$row['Database'] . "\n";
}

// Deprecated as of PHP 5.4.0
$link mysql_connect('localhost''mysql_user''mysql_password');
$db_list mysql_list_dbs($link);

while (
$row mysql_fetch_object($db_list)) {
     echo 
$row->Database "\n";
}
?>

Наведений вище приклад виведе щось подібне до:

database1
database2
database3

Примітки

Зауваження:

Для зворотньої сумісності, можна використовувати наступний застарівший псевдонім: mysql_listdbs()

Прогляньте Також

add a note add a note

User Contributed Notes 4 notes

up
2
jeff at forerunnertv dot com
2 years ago
There is no direct equivalent of mysql_list_dbs() as a mysqli_list_dbs() command, but you can query "show databases" instead.

So this:

$db_list = mysql_list_dbs($connect);  //mysql

Is equivalent to this:

$db_list = mysqli_query($connect, "SHOW DATABASES"); //mysqli
up
-1
busilezas at gmail dot com
7 years ago
The example is wrong in Spanish version.

ERROR:  mysql_fetch_assoc() expects parameter 1 to be resource, null given in XXX on line 5
while ($fila = mysql_fetch_assoc($res)) {

OK.
while ($fila = mysql_fetch_assoc($resultado)) {
up
-1
matjung at hotmail dot com
12 years ago
The result pointer contains only the databases for which the mysql_user has the select priviledge granted.
up
-4
theriault
10 years ago
Another alternative to this function is:

SQL Query: SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA
To Top