$menu->selectMenu($mode); $menu->renderHTML(); $html = $menu->getHTML(); unset($menu); $html .= "<h1> Database " . $DB->Name($Server) . " - User " . $DB->User($Server) . "</h1>"; // different views switch ($mode) { case "main": switch ($submode) { case "execute": $statement = trim(getData("statement")); $html .= "<form action=\"database_detail.php\" method=\"post\" enctype=\"application/x-www-form-urlencoded\">" . "<input type=\"hidden\" name=\"Server\" value=\"{$Server}\">" . "<input type=\"hidden\" name=\"mode\" value=\"main\">" . "<input type=\"hidden\" name=\"submode\" value=\"execute\">" . "<textarea name=\"statement\" cols=\"80\" rows=\"5\" wrap=\"VIRTUAL\" style=\"width: 400px\">" . $statement . "</textarea><br>" . "<input type=\"Submit\" name=\"BUTTON\" value=\"Execute\">"; $html .= "</form></td></tr></table>"; $tbl = new DataTable($Server); $tbl->setSql($statement); $tbl->setSorting(1); $tbl->setSort($Sortfield, $Sortorder); $tbl->loadData(); $tbl->setColorToggle(1); $tbl->renderHTML($defaultget . "mode={$mode}&submode={$submode}&statement=" . rawurlencode($statement) . "&" . SID); $html .= $tbl->getHTML(); unset($tbl); break; default: $html .= "<P>Execute SQL Statement:<br>" . "<form action=\"database_detail.php\" method=\"post\" enctype=\"application/x-www-form-urlencoded\">" . "<input type=\"hidden\" name=\"Server\" value=\"{$Server}\">" . "<input type=\"hidden\" name=\"mode\" value=\"main\">" . "<input type=\"hidden\" name=\"submode\" value=\"execute\">" . "<textarea name=\"statement\" cols=\"80\" rows=\"5\" wrap=\"VIRTUAL\" style=\"width: 400px\"></textarea><br>" . "<input type=\"Submit\" name=\"BUTTON\" value=\"Execute\">"; $html .= "</form></td></tr></table></p>"; } break; default: } $page = new Page("Database " . $DB->Name($Server) . " - User " . $DB->User($Server));
***************************************************************************/ /*************************************************************************** * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * * the Free Software Foundation; either version 2 of the License, or * * (at your option) any later version. * * * ***************************************************************************/ include "prepend.inc.php"; $Server = getData("Server", "integer"); $User = getData("User"); $Userurl = rawurlencode($User); $tbl = new Table($Server); $tbl->getDatas($User); $html = "<H1> Database " . $DB->Name($Server) . " - Table overview of User {$User}</H1>\n"; $dtbl = new DataTable($Server); $dtbl->setSorting(0); $dtbl->setData($tbl->datas[$User]); unset($tbl); $dtbl->setColorToggle(1); $dtbl->setDataLink("TABLE_NAME", "tbl_detail.php?Server={$Server}&Tablename=\$value&User={$Userurl}&" . SID); $dtbl->renderHTML(); $html .= $dtbl->getHTML(); unset($dtbl); $page = new Page("Table Overview"); $page->setHead(); $page->setBody(); $page->setSQL(); $page->setBody($html); $page->Display();