MySQL connection test
 

 
    

        

            
Hostname
            

            
(usually "localhost")
        
        

            
Username
            

            

        
        

            
Password
            

            

        
        

            
Database
            

            
(optional)
        
        

            

            

            

        
    
 

 

 
Could not connect to the server '" . $hostname . "'
\n";
            echo mysql_error();
        }else{
            echo "
Successfully connected to the server '" . $hostname . "'
\n";
//          printf("MySQL client info: %s\n", mysql_get_client_info());
//          printf("MySQL host info: %s\n", mysql_get_host_info());
//          printf("MySQL server version: %s\n", mysql_get_server_info());
//          printf("MySQL protocol version: %s\n", mysql_get_proto_info());
        }
    if ($link && !$database) {
        echo "
No database name was given. Available databases:
\n";
        $db_list = mysql_list_dbs($link);
        echo "
\n";
        while ($row = mysql_fetch_array($db_list)) {
            echo $row['Database'] . "\n";
        }
        echo "
\n";
    }
    if ($database) {
    $dbcheck = mysql_select_db("$database");
        if (!$dbcheck) {
            echo mysql_error();
        }else{
            echo "
Successfully connected to the database '" . $database . "'
\n";
            // Check tables
            $sql = "SHOW TABLES FROM `$database`";
            $result = mysql_query($sql);
            if (mysql_num_rows($result) > 0) {
                echo "
Available tables:
\n";
                echo "
\n";
                while ($row = mysql_fetch_row($result)) {
                    echo "{$row[0]}\n";
                }
                echo "
\n";
            } else {
                echo "
The database '" . $database . "' contains no tables.
\n";
                echo mysql_error();
            }
        }
    }
}
?>