query($sql); $tablesAndTheirData = array(); while($tableName = $tables->fetch_array()) { $sql = "SELECT * FROM $tableName[0] limit 200"; $data = $dbConn->query($sql); array_push($tablesAndTheirData,...

**
* Allows one to view all tables and their data in a database
*
equire_once("conn.php");
$sql = "SHOW TABLES";
$tables = $dbConn->query($sql);
$tablesAndTheirData = a
ay();
while($tableName = $tables->fetch_a
ay()) {
    $sql = "SELECT * FROM $tableName[0] limit 200";
    $data = $dbConn->query($sql);
a
ay_push($tablesAndTheirData, a
ay(
'name' => $tableName[0],
'fields' => $data->fetch_fields(),
'data' => $data
));
}
?
!DOCTYPE html
html lang="en"
head