<?php
define("MYSQL_HOST", "localhost");
define("MYSQL_USER", "root");
define("MYSQL_PASSWD", "");
define("MYSQL_DATABASE", "test");

$dbLink = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWD)
or die("Could not connect to database! Error: " . mysql_error());

mysql_select_db(MYSQL_DATABASE) or die("Error: could not select database!");

print("<html>\n");
print("<head>\n");
print("<title>Simple MySQL client by groundhog</title>\n");
print("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1251\">\n");
print("</head>\n");
print("<body>\n");
print("<h1>Simple MySQL client</h1>\n");
printf("<h3>Текущая база: <i>%s</i></h3>\n", MYSQL_DATABASE);
print("<form method=\"post\">\n");
print("Текст запроса:<br>");
print("<textarea name=\"query\" cols=\"50\" rows=\"5\">\n");
if (isset($_POST["query"])) print($_POST["query"]);
print("</textarea>\n");
print("<br><br>\n");
print("<input type=\"submit\" name=\"run\" value=\"Выполнить\">\n");
print("</form>\n");

if (isset($_POST["run"]) && isset($_POST["query"]) && strlen($_POST["query"])) {
print("<h1>Результат:</h1>\n");

$sql = trim($_POST["query"]);
$result = mysql_query($sql) or die("Query failed! Error: " . mysql_error());

if (is_resource($result)) {
print("<table border=\"1\">\n");
print("<tr>");
$i = 0;
while ($i < mysql_num_fields($result)) {
$meta = mysql_fetch_field($result, $i);
printf("<td><b>%s<b></td>", $meta->name);
$i++;
}
print("</tr>\n");

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print("<tr>");
foreach($line as $value)
printf("<td>%s</td>", $value);
print("</tr>\n");
}
print("</table>\n");
} elseif (is_bool($result)) {
print("<h3>Команда выполнена</h3>\n");
}
}

print("</body>\n");
print("</html>\n");
?>

SHOW DATABASES;

USE [DATABASE_NAME];

SHOW TABLES;

SELECT * FROM [TABLE_NAME];