How to get a list of databases?

by

It doesn’t appear as though there’s a function available to do this, but you can execute a show databases; query and the rows returned will be the databases available.

EXAMPLE:

Replace this: 

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

With this: 

$db_list = mysqli_query($link, "SHOW DATABASES"); //mysqli

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. Can I mix MySQL APIs in PHP?
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. How to change mysql to mysqli?
  5. Best way to INSERT many values in mysqli?
  6. How to use mysqli prepared statements?
  7. MySQLi prepared statements error reporting [duplicate]
  8. Why is mysqli giving a “Commands out of sync” error?
  9. mysqli last insert id
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. How to call a MySQL stored procedure from within PHP code?
  12. MySQLi count(*) always returns 1
  13. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  14. Do I have to guard against SQL injection if I used a dropdown?
  15. Using Mysqli bind_param with date and time columns?
  16. Using MySQLi from another class in PHP
  17. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  18. PHP PDO and MySQLi [duplicate]
  19. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  20. Unknown database error in PHP but it exists in PHPMyAdmin
  21. Can I blindly replace all mysql_ functions with mysqli_?
  22. php password_verify() hash and pass won’t match
  23. Get number of rows matched by UPDATE query with PHP mysqli
  24. How to use mysqli_query() in PHP?
  25. PHP to MySQL SSL Connections
  26. Strange problem with the length of the field gotten from database [duplicate]
  27. PHP: mysql v mysqli v pdo [closed]
  28. How do I ensure I caught all errors from MySQLi::multi_query?
  29. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  30. Why cannot the PHP hide the error message thrown by the MySQL connection?

Leave a Comment