show databases in php

[digitalecartoon]

I want to use the mysql SHOW DATABASES command in php, but keep getting blank pages. I know the error must be in the while loop, but can't figure out what it should be? I want to get a pages similar to this:

+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.11 sec)

<?php 

// Basisinformatie 
$dbhost='localhost'; 
$dbusername='***'; 
$dbpassword='***'; 
$dbname='test'; 

$dbcnx = mysql_connect ($dbhost, $dbusername, $dbpassword); 

$result = @mysql_query('SHOW DATABASES'); 
if (!$result) { 
exit('<p>Fout tonen databases: ' . mysql_error() . 
'</p>'); 
} 

while ($row = mysql_fetch_array($result)) { 
echo '<p>' . $row['database'] . '</p>'; 
} 

?>

[digitalecartoon]

Got it solved by doing a print of $row. It gave as output:
Array ( [0] => information_schema [Database] => information_schema )

So I should have used Database with a kapital D, but now this gives the output:
$dbname
mysql

So it has used the variable name as the database directory (which I can see when browsing to the mysql db folder), where it should have used its value according to below script ('testing'). What should I do to have it make a 'testing' directory?

<?php 

// Basisinformatie 
$dbhost='localhost'; 
$dbusername='***'; 
$dbpassword='***'; 
$dbname='testing'; 

// Maak verbinding met mysql database server. 
$dbcnx = mysql_connect ($dbhost, $dbusername, $dbpassword); 
echo "Verbinding met database!"; 

// Database aanmaken. 
$sql = 'CREATE DATABASE $dbname'; 
if (@mysql_query($sql)) { 
echo '<p>Database '.$dbname.' is aangemaakt!</p>'; 
} else { 
exit('<p>Fout bij aanmaken database: ' . 
mysql_error() . '</p>'); 
} 

?>

[digitalecartoon]

Solved by using variable outside quotes:
$sql = 'CREATE DATABASE '.$dbname;

[laserlight]

Good to see that you solved the problems by yourself 🙂

Incidentally, the reason why 'CREATE DATABASE $dbname' did not work is that PHP variables are not parsed within single quoted strings. You solution is correct, though another correct solution is to use double quoted strings (but they have no advantage in this case).

[baheer]

Dear Friends!
There were some points that I couldn't to understand it:
1. $dbname='test';
Why you selected the Database?
We want to show Databases in Browser Window?
2. echo '<p>' . $row['database'] . '</p>';
What do you mean with 'database'?

Please send me the solution, will be your kind.

thanks

[leatherback]

baheer wrote:

1. $dbname='test';
Why you selected the Database?We want to show Databases in Browser Window?

What do you mean to ask here?

baheer wrote:

2. echo '<p>' . $row['database'] . '</p>';
What do you mean with 'database'?

database is the fieldname in the mysql master table, used to store the name of individual databases on the server

[guruparthi]

Try this,

<?php
$link=mysql_connect('localhost','root','') or die(mysql_error());
$result = mysql_query("SHOW DATABASES") or die(mysql_error());

while ($row = mysql_fetch_array($result)) {

echo $row[0]."<br>";

}
?>

Reference:http://www.phponwebsites.com/2014/04/mysql-database-list-using-php.html

[laserlight]

guruparthi: please do not revive old threads without good reason. There was nothing here that needed to be corrected. As such, linking to your own website is merely an attempt at advertisement. Furthermore, your own website is way out of date: these days the MySQLi extension or the PDO extension should be preferred to the legacy MySQL extension.