SHOW DATABASE with PDO and mysql_list_dbs mysql_db_name php function for name of database dbs in mysql

WE can use PHP PDO to list databases existing in MySQL. Here is the query

SHOW DATABASES

Using the above query we will develop a PHP PDO script to display all the databases present . Here is the code.

<?Php
////////////////
require "config.php"; // Database Connection
////////////////
$result = $dbo->query("SHOW DATABASES");
while ($row = $result->fetch(PDO::FETCH_NUM)) {
echo $row[0]."<br>";
}
?>

Using MySQLI

if($stmt = $connection->query("SHOW DATABASES")){
  echo "No of records : ".$stmt->num_rows."<br>";
  while ($row = $stmt->fetch_assoc()) {
	echo $row['Database']."<br>";
  }
}else{
echo $connection->error;
}

This old MySQL extension was deprecated in PHP 5.4.0 and was removed in PHP 7

Use SHOW DATABASE query in place of mysql_db_list().

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.

<?Php
$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++;}
?>

PHP MySQL functions SHOW Tables

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

	13-10-2023
Please help me. php syntax to SHOW DATABASES in php. I'm using Linux

PHP MySQL Functions to list databases

Subhendu Mohapatra