require_once __DIR__ . '/app/bootstrap.php';
if (!isset($_GET['action'])) {
die("No action set.");
}
if (!isset($_GET['db'])) {
die("No db set.");
}
$action = $_GET['action'];
$active_db = $_GET['db'];
$active_table = false;
if ($action == 'show_menu') {
$db = new Database($active_db);
$tables = $db->getTables();
if ($active_table == false) {
if (isset($tables[0])) {
$active_table = $tables[0];
}
}
$curr_table = $db->getTable($active_table);
// Build default menu for active_db.
$lm = new ListMenu();
$lm->setItems($tables);
$lm->setColumnMax(3);
TemplateVars::set('tables', $lm->toString($active_table));
if (count($tables) == 0) {
die("<em>This database is empty.</em>");
}
require_once './app/templates/partials/menu_display.phtml';
exit;
}
require_once __DIR__ . '/app/bootstrap.php';
$active_db = DEFAULT_DATABASE;
$active_table = false;
if (isset($_GET['db'])) {
$active_db = strip_junk($_GET['db']);
}
if (isset($_GET['table'])) {
$active_table = strip_junk($_GET['table']);
}
$db = new Database($active_db);
$tables = $db->getTables();
if ($active_table == false) {
$active_table = $tables[0];
}
$curr_table = $db->getTable($active_table);
// Build default menu for active_db.
$lm = new ListMenu();
$lm->setItems($tables);
$lm->setColumnMax(3);
TemplateVars::set('tables', $lm->toString($active_table));
// Grab database listing
TemplateVars::set('dbs', Database::getAllDatabases());
TemplateVars::set('active_db', $active_db);
require_once './app/templates/header.phtml';
$data = $curr_table->getRows(0, 10, $return_res = true);
TemplateVars::set('table', $active_table);
TemplateVars::set('schema', $curr_table->getFields($return_res = true));
TemplateVars::set('schema_sql', $curr_table->getSQL());
TemplateVars::set('table_data', $data);
require_once './app/templates/show_table.phtml';
require_once './app/templates/footer.phtml';
