Menu
Community /Pin to ProfileBookmark
@NogDogOct 06.2005 — #
obtain MySQL info.
After connecting to a MySQL server, can PHP return information about the MySQL server?
I’m looking for a way for PHP to echo back the names of each database contained on the MySQL server along with all the names of each table contained in each database.
Assuming that this is the code used to connect to the MySQL server:
[code]
<?
$link = mysql_connect(“xxxxx.xxxxxx.xxxxx:xxxxxxxxx”,”xxxxxxxxxx”,”xxxxxxxxxx”);
if(!$link){die(‘Connection:n<br>nFAILURE!’ . mysql_error());}
echo ‘Connection:n<br>nSUCCESSFUL!n’;
mysql_close($link);
?>
How can I echo back a report similar to:
[code]
Connection:
SUCCESSFUL!
businesses
+table1
+table2
orginations
+table1
airports
+table1
+table2
+table3
+table4
Extra credit if you come-up with a way for PHP to also echo the table format of each table.
Thanks in advance!
Sign in
to post a comment11 Comments(s) ↴
0
@NogDogOct 06.2005 — #[code=php]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html lang='en'>
<head>
<META HTTP-EQUIV='Content-Type' CONTENT='text/html; charset=ISO-8859-1'>
<title>Database Info</title>
<style type="text/css">
<!--
body {
margin: 0;
padding: 1em;
font: medium arial, helvetica, sans-serif;
}
table {
border-collapse: collapse;
border: solid 2px black;
font-weight: normal;
font-size: small;
margin: 0.25em 0 0.5em 0;
}
td,th {
border: solid 1px black;
padding: 0.1em 0.25em;
}
li {
font-weight: bold;
font-size: large;
margin-top: 0.5em;
}
th { background-color: #ccc; }
h2 {
margin: 1em 0 0.5em 0;
border-top: solid 2px black;
padding-top: 1em;
}
-->
</style>
</head>
<body>
<h1>Database Info</h1>
<?php
$connx = mysql_connect('localhost', '******', '******') or
die("Unable to connect to MySQL");
$dbQuery = mysql_query("SHOW DATABASES") or die (mysql_error());
while($db = mysql_fetch_assoc($dbQuery))
{
$thisdb = mysql_select_db($db['Database']) or die (mysql_error());
echo "<h2>{$db['Database']}</h3>n";
echo "<ul>n";
$tabQuery = mysql_query("SHOW TABLES FROM {$db['Database']}") or
die(mysql_error());
while($table = mysql_fetch_assoc($tabQuery))
{
$tabKey = "Tables_in_{$db['Database']}";
$row = 0;
echo "<li>{$table[$tabKey]}";
$query = "DESC {$table[$tabKey]}";
$fldQuery = mysql_query($query) or die(mysql_error() . " -- $query");
echo "<table>n";
while($field = mysql_fetch_assoc($fldQuery))
{
if($row++ == 0)
{
echo "<tr>";
foreach($field as $key => $val)
{
echo "<th>$key</th>";
}
echo "</tr>n";
}
echo "<tr>";
foreach($field as $val)
{
echo "<td>$val</td>";
}
echo "</tr>";
}
echo "</li>";
}
echo "</ul>";
}
?>
</body>
</html>
[/code]