SQL PHP HTML ASP JavaScript articles and free scripts to download

If you are facing any problem in viewing this page, please tell us

PHP MySQL Functions to list databases

By using mysql_db_list() function we can get the result set and by using a pointer to this result set we can get the list of all the database. With this and using the code below we can list all the databases hosted on the mysql server. Here is the code, ensure that connection is available to the server.

<?
$list_of_dbs = mysql_list_dbs();
$i = 0;
$total = mysql_num_rows($list_of_dbs);
while ($i < $total) {
echo mysql_db_name($list_of_dbs, $i) . "<br>";
$i++;}
?>

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email	( not to be displayed)Privacy Policy
1+2=	This is to prevent automatic submission by spammers. Please enter the result of the sum as asked

Sections

SQL Tutorial List

mysql_affected_rows mysql_auto_increment mysql_close mysql_connect mysql_create_db mysql_db_name mysql_errno mysql_error mysql_fetch_field mysql_fetch_lengths mysql_fetch_row mysql_field_flags mysql_field_len mysql_field_name mysql_field_type mysql_insert_id mysql_list_dbs mysql_list_tables mysql_num_fields mysql_num_rows mysql_pconnect mysql_query mysql_select_db mysql_tablename

mysql_change_user mysql_data_seek mysql_db_query mysql_drop_db mysql_fetch_array mysql_fetch_assoc mysql_field_seek mysql_field_table mysql_free_result mysql_list_fields mysql_result

SQL site Map

Knowledge Management

Subscribe

Submit your email address and receive article and product notifications. Your email is safe with us.

PHP MySQL Functions to list databases

<? $list_of_dbs = mysql_list_dbs(); $i = 0; $total = mysql_num_rows($list_of_dbs); while ($i < $total) { echo mysql_db_name($list_of_dbs, $i) . "<br>"; $i++;} ?>

<?
$list_of_dbs = mysql_list_dbs();
$i = 0;
$total = mysql_num_rows($list_of_dbs);
while ($i < $total) {
echo mysql_db_name($list_of_dbs, $i) . "<br>";
$i++;}
?>