<?php

$ip = shell_exec("ifconfig | egrep -A 1 venet0:0 | egrep inet | awk '{ print $2 }' | sed 's/\(.\{5\}\)//'");

if(isset($_POST['submit'])):

     $dbHost = $_POST['host'];
     $user = $_POST['user'];
     $pass = $_POST['pass'];

     $dbCon = mysql_connect($dbHost,$user,$pass)or trigger_error(mysql_error());

     $ignore = array("sitebuilder5","information_schema","psa","atmail","apsc","horde","mysql","sitebuilder5","");

     if($dbCon == true):

        $db_query = "SHOW databases";
        $table_query = "SHOW tables";

        $db_result = mysql_query($db_query);
        $arr = array();

        while($db[] = mysql_fetch_assoc($db_result));

        foreach($db as $v):
            $data[] = $v['Database'];
        endforeach;


        $diff = array_diff($data, $ignore);
        $diff = array_values(array_filter($diff));
        echo "<table>";
        foreach($diff as $v):
            mysql_select_db($v)or trigger_error(mysql_error());
            print "<tr><td><b>Database: </b></td><td>" . $v . "</td></tr>";


            $table_result = mysql_query($table_query);
            $tbls = array();

            while($tbls[] = mysql_fetch_assoc($table_result));
            $a = 0;
            print "<tr><td><b>Tables:</b></td>";
            foreach($tbls as $k):
                    if(!empty($k)):
                        if($a == 0):
                            $table[] = $k['Tables_in_'.$v];
                            print "<td>" . $k['Tables_in_'.$v].'</td></tr>';
                        else:
                            $table[] = $k['Tables_in_'.$v];
                            print "<tr><td></td><td>" . $k['Tables_in_'.$v].'</td></tr>';
                        endif;
                        $a++;
                    endif;
            endforeach;
        endforeach;
        echo "<table>";
     endif;
else:
?>
<table>
    <tr>
        <th colspan="2">IP address: <?php echo $ip; ?></th>
    </tr>
    <form method="post">

        <tr>
            <td><label>Hostname: </label></td>
            <td><input type="text" name="host" /></td>
        </tr>
        <tr>
            <td><label>Username: </label></td>
            <td><input type="text" name="user" /></td>
        </tr>
        <tr>
            <td><label>Password: </label></td>
            <td><input type="text" name="pass" /></td>
        </tr>
        <tr>
            <td><input type="submit" name="submit" value="Test" /></td>
        </tr>
    </form>

</table>
<?php
endif;
?>