PHP.nl

mysql_list_dbs

mysql_list_dbs

List databases available on a MySQL server

Waarschuwing: > SHOW DATABASES

resource **mysql_list_dbs** resource $link_identifier

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

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

Voorbeeld: 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

Opmerking: > info.deprecated.alias

mysql_listdbs

mysql_db_name``mysql_select_db

Vorige ← mysql_insert_id Volgende mysql_list_fields →

Documentatie