include_once 'navigation2.inc'; include_once "utils.inc"; include_once "ste.php"; $navTitle = "Peerweb testscript " . $PHP_SELF . " on DB " . $db_name; $page = new PageContainer(); $page->setTitle('Menu'); //$dbConn->setSqlAutoLog(true); $ste = new SimpleTableEditor($dbConn, $page); $ste->setFormAction($PHP_SELF); $ste->setRelation('menu'); $ste->setMenuName('menu'); $ste->setKeyColumns(array('menu_name', 'relation_name')); $ste->setNameExpression("rtrim(menu_name,' ')||', '||rtrim(relation_name,' ')"); $ste->setOrderList(array('menu_name', 'relation_name')); $ste->setFormTemplate('templates/menu.html'); $ste->setListRowTemplate(array('menu_name', 'relation_name')); $page_opening = "Menu"; $nav = new Navigation($tutor_navtable, basename($PHP_SELF), $page_opening); $page->addBodyComponent($nav); if (isset($_POST['Insert'])) { /* try to insert menu,column_names into menu_items */ $menu_name = $_POST['menu_name']; $relation_name = $_POST['relation_name']; $sql = "insert into menu_item (menu_name,column_name,edit_type,capability,item_length) select '{$menu_name}' as menu_name, column_name," . " 'T' as edit_type, 32767 as capability, character_maximum_length" . " from information_schema.columns where table_name='{$relation_name}'"; $dbMessage = ''; $result = doUpdate($dbConn, $sql, $dbMessage); $page->addBodyComponent(new Component("<fieldset><legend>Create menu_items</legend>\n" . $dbMessage . "\n</fieldset>\n")); } $ste->render(); $page->addBodyComponent(new Component('<!-- db_name=$db_name $Id: menu.php 1723 2014-01-03 08:34:59Z hom $ -->')); $page->addBodyComponent(new Component('<a href="tets.php">tets</a>' . $PHP_SELF));