<?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();
}
?>
<?php
$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');
echo '<h4>'.$tabel[0].'</h4>';
for ($i = 0; $i < $tel_velden; $i++) {
}
echo '<table cellpadding="5" border="1" bordercolor="#000000" style="border-collapse: collapse;">';
foreach ($array as $veld) {
echo '<th>'.$veld.'</th>'; }
$query_velden = implode(', ', $array);
foreach ($array as $veldnaam) {
echo '<td>'.$rij[$veldnaam].'</td>'; }
}
}
?>