How to list all databases of the mysql server mysql_db_name

How to list all databases of the mysql server mysql_db_name

Definition and usage
The mysql_db_name () function considers that calling the mysql_list_dbs () function from the database name.

This function returns the database name success or FALSE failure.

Syntax

Mysql_db_name (list, row, field)

  

   

    

     
List
     

      

       Required. Mysql_list_dbs () function specified by the result Pointer
      
    
    

     
Row
     

      

       Required. Specify the row indexes returned by the result pointer. It starts with zero.
      
    
    

     
Field
     
Yes. Database name
    
   
  

Let's take a look at the instance of mysql_db_name.

<?

$ 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 ++ ;}
?>
 
The output result is all the databases on your current server.