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';