PHP MySQL Test Page

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN”
<html xmlns=”; xml:lang=”en” lang=”en”>
<title>MySQL Connection Test</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />
<style type=”text/css”>
#wrapper {
    width: 600px;
    margin: 20px auto 0;
    font: 1.2em Verdana, Arial, sans-serif;
input {
    font-size: 1em;
#submit {
    padding: 4px 8px;
<div id=”wrapper”>
    $action = htmlspecialchars($_GET[‘action’], ENT_QUOTES);
<?php if (!$action) { ?>
    <h1>MySQL connection test</h1>
<form action=”<?php echo $_SERVER[‘PHP_SELF’]; ?>?action=test” id=”mail” method=”post”>
<!– <form action=”some_absolute_url” id=”mail” method=”post”> –>
    <table cellpadding=”2″>
            <td><input type=”text” name=”hostname” id=”hostname” value=”” size=”30″ tabindex=”1″ /></td>
            <td>(usually “localhost”)</td>
            <td><input type=”text” name=”username” id=”username” value=”” size=”30″ tabindex=”2″ /></td>
            <td><input type=”text” name=”password” id=”password” value=”” size=”30″ tabindex=”3″ /></td>
            <td><input type=”text” name=”database” id=”database” value=”” size=”30″ tabindex=”4″ /></td>
            <td><input type=”submit” id=”submit” value=”Test Connection” tabindex=”5″ /></td>
<?php } ?>
<?php if ($action == “test”) {
// The variables have not been adequately sanitized to protect against SQL Injection attacks:
    $hostname = trim($_POST[‘hostname’]);
    $username = trim($_POST[‘username’]);
    $password = trim($_POST[‘password’]);
    $database = trim($_POST[‘database’]);
    $link = mysql_connect(“$hostname”, “$username”, “$password”);
        if (!$link) {
            echo “<p>Could not connect to the server ‘” . $hostname . “‘</p>n”;
            echo mysql_error();
            echo “<p>Successfully connected to the server ‘” . $hostname . “‘</p>n”;
//          printf(“MySQL client info: %sn”, mysql_get_client_info());
//          printf(“MySQL host info: %sn”, mysql_get_host_info());
//          printf(“MySQL server version: %sn”, mysql_get_server_info());
//          printf(“MySQL protocol version: %sn”, mysql_get_proto_info());
    if ($link && !$database) {
        echo “<p>No database name was given. Available databases:</p>n”;
        $db_list = mysql_list_dbs($link);
        echo “<pre>n”;
        while ($row = mysql_fetch_array($db_list)) {
            echo $row[‘Database’] . “n”;
        echo “</pre>n”;
    if ($database) {
    $dbcheck = mysql_select_db(“$database”);
        if (!$dbcheck) {
            echo mysql_error();
            echo “<p>Successfully connected to the database ‘” . $database . “‘</p>n”;
            // Check tables
            $sql = “SHOW TABLES FROM `$database`”;
            $result = mysql_query($sql);
            if (mysql_num_rows($result) > 0) {
                echo “<p>Available tables:</p>n”;
                echo “<pre>n”;
                while ($row = mysql_fetch_row($result)) {
                    echo “{$row[0]}n”;
                echo “</pre>n”;
            } else {
                echo “<p>The database ‘” . $database . “‘ contains no tables.</p>n”;
                echo mysql_error();
</div><!– end #wrapper –>


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s