How to List Table

nucoder

I am a new coder so please be my guide.

I have the following code that connects to my dataabase. Now I want to list the tables in this dataabase using php. I have read some literature on how to do this but it is confusing to me. Can someone provide the code?

Thanks,
nucoder-

<?
$connection = mysql_connect("xxx.net", "dbxxx", "xxx") or die("Couldn't connect.");
if ($connection) {
$msg = "success!";
}
?>
<body>
<? echo "$msg"; ?>
</body>

johanafm

Provided you follow the call to connect by mysql_select_db

$result = mysql_query('SHOW TABLES');
if ($result) {
	while ($row = mysql_fetch_array($result))
		echo $row[0] . '<br/>';
}

NINTHTJ

Another way, in case you want the name of the key as well as the value is to use the Array Walk function:

<?php

$arr = array("a" => "1", "b" => "2", "c" => "3");

function test($item, $key)
{
    echo $key . " : " . $item . "<br>";
}

array_walk($arr,"test");

?>

Hope it helps you out 😉

nucoder

johanafm the code works great thanks for you fast response and for your help.
NINTHTJ the code you provided works but only returns the keys and not the list of tables. In addition I am not clear on what the keys are and what they do so if you could explain what the keys are and what they do it would be much appreciated. Thanks!

NINTHTJ

Ahh list of tables... My mistake. Thought you wanted list of all the elements in a table.

rajeevbharti

hi friend try this for listing table with data from your database

make a php file
<?php
mysql_connect('hostname', 'username','password') or die(" Can not connect databaw");
mysql_select_db('tablename') or die("cannot open table");

$qur = "SELECT * FROM tablename";
$res = mysql_query($qur);
?>
<table>
<th><td>name</td></th><th><td>Age</td></th>
<?php
while($row = mysql_fetch_assoc($res))
{ ?>
<tr><td><?php echo $row['name']; ?></td><?php echo $row['age'];?> <td></tr>

<?php
} ?>
</table>