[RESOLVED] How do I display databases or tables?

[chris_p]

Heyyyy!

I'm having trouble displaying databases or tables from a php script.

Here's my lame script which does not work. I could not find anything in the PHP book I'm working from that tells me how to do this, so maybe one of you kind folk can help me out??

<?php
session_start();
require_once('../secret_folder/mysql_connect.php');
$query="SHOW DATABASES";
$result=@($query);
if($result){
echo'Result';
while ($row=mysql_fetch_array($result, MYSQL_ASSOC)) {
echo $row;
}
}
?>

[djjjozsi]

hello,

use the $row array as associated.
and post php codes between [php ] [/php ] tags please.

<?php
	session_start();
	require_once('../secret_folder/mysql_connect.php');
	$query="SHOW DATABASES";
	$result=@mysql_query($query) or die(mysql_error());
	if($result)
	{
		echo'Result';
		while ($row=mysql_fetch_assoc($result))   // in this line you missed one  ) sign!
		{
			echo $row["Database"]."<br />";
		}
	}
?>

[chris_p]

Thanks, Djjjozsi. That works. I tried a similar script for SHOW TABLES using $row['table'] but I get blank space instead of table names.

<?php
session_start();
$db=$_SESSION['db'];
require_once('../secure_folder/mysql_connect_ns.php');
$query="use $db";
$result=@mysql_query($query);
if($result){
echo'Currently using <b>'.$db.'</b><br/><br/>';}

$query="SHOW TABLES";
$result=@mysql_query($query) or die(mysql_error());
if($result){
echo'TABLES in '.$db.'- <br/> <br/>';
while ($row=mysql_fetch_assoc($result)) {
echo '-'.$row['table']."<br/>";
}
}
?>

It's counting the correct number of tables but won't name them.

[coldwerturkey]

you can use print_r($row); to see the array (& you'll find it's something like $row['Tables_in_databasename'])

[chris_p]

Thanks heaps!