DATABASE AKTIF"; $db = mysqli_query($conn, "SELECT DATABASE() AS db"); $dbrow = mysqli_fetch_assoc($db); echo "Database: " . $dbrow['db']; echo "
"; echo "

DAFTAR TABEL

"; $tables = []; $qTables = mysqli_query($conn, "SHOW TABLES"); while ($t = mysqli_fetch_array($qTables)) { $table = $t[0]; $tables[] = $table; echo $table . "
"; } echo "
"; foreach ($tables as $table) { echo "

STRUKTUR $table

"; $qDesc = mysqli_query($conn, "DESCRIBE `$table`"); echo " "; while ($row = mysqli_fetch_assoc($qDesc)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
Field Type Null Key Default Extra
{$row['Field']}{$row['Type']}{$row['Null']}{$row['Key']}{$row['Default']}{$row['Extra']}
"; echo "
"; echo "

ISI $table (maks 10 baris)

"; $qData = mysqli_query($conn, "SELECT * FROM `$table` LIMIT 10"); if ($qData && mysqli_num_rows($qData) > 0) { echo ""; $first = mysqli_fetch_assoc($qData); echo ""; foreach (array_keys($first) as $col) { echo ""; } echo ""; echo ""; foreach ($first as $val) { echo ""; } echo ""; while ($row = mysqli_fetch_assoc($qData)) { echo ""; foreach ($row as $val) { echo ""; } echo ""; } echo "
$col
" . htmlspecialchars((string)$val) . "
" . htmlspecialchars((string)$val) . "
"; } else { echo "Tidak ada data."; } echo "
"; } ?>