How can we write PHP script to get the list of MySQL database?

We can write the following PHP script to get the list of available MySQL databases −

Example

<?php
   $con = mysql_connect("localhost", "userid", "password");

   if (!$con) {
      die('Could not connect: ' . mysql_error());
   }
   $db_list = mysql_list_dbs($con);

   while ($db = mysql_fetch_object($db_list)) {
      echo $db->Database . "<br />";
   }
   mysql_close($con);
?>

Priya Pallavi

Published on 22-Feb-2018 16:07:03