
<?php
error_reporting(E_ALL);

$username = ''; // mysql username
$password = ''; // mysql wachtwoord
$db = ''; // mysql databasenaam

mysql_connect('localhost',$username,$password)or die('Er kon geen connectie gemaakt worden met de database');
mysql_select_db($db) or die('De database kon niet worden geselecteerd');

$tabellen = mysql_list_tables($db);

while ($tabel = mysql_fetch_array($tabellen)) {
    
    echo '<h4>'.$tabel[0].'</h4>';
    
    $velden = mysql_list_fields($db, $tabel[0]);
    $tel_velden = mysql_num_fields($velden);
    
    for ($i = 0; $i < $tel_velden; $i++) {
        
        $array[] = mysql_field_name($velden, $i);
    }
    
    echo '<table cellpadding="5" border="1" bordercolor="#000000" style="border-collapse: collapse;">';
    echo '<tr>';
            
    foreach ($array as $veld) {
        
        echo '<th>'.$veld.'</th>';
    }
    
    echo '</tr>';
            
    $query_velden = implode(', ', $array);
    
    $alles = mysql_query("SELECT ".$query_velden." FROM ".$tabel[0])or die(mysql_error());
    
    while ($rij = mysql_fetch_assoc($alles)) {
        
        echo '<tr>';
        
        foreach ($array as $veldnaam) {
            
            echo '<td>'.$rij[$veldnaam].'</td>';
        }
        
        echo '</tr>';
    }
            
    echo '</table>';
    $array = array();
}
?> 