if ($colname == 'id') { ++$i; continue; } // $length = strlen($item); $size = 50; /* if($length < 10) { $size = 10; } */ $inp = new Input(); $inp->setName($colname); $inp->setValue($item); $inp->setSize(50); $inp->setMaxlength(128); /**/ $tr = new Tr(); $tr->add($colname); $tr->add($inp->dump()); $tr->build(); ++$i; /**/ } $tr = new Tr(); $tr->add(' '); $tr->add($submit->dump()); $tr->build(); unset($table); unset($form); $body->line('<hr />');
$colprime->setId('colprime'); $colprime->setJs(' onclick="PSA.checkprimary();" '); $colsize = new Input(); $colsize->setName('colsize'); $colsize->setSize(7); $colsize->setMaxlength(7); $colsize->setId('colsize'); $colsize->setJs(' onblur="PSA.checknumeric();" '); $colnull = new Input(); $colnull->setName('colnull'); $colnull->setType('checkbox'); $colnull->setId('colnull'); $coldefault = new Input(); $coldefault->setName('coldefault'); $coldefault->setSize(25); $coldefault->setMaxlength(128); $coldefault->setId('coldefault'); $fieldadd = new Input(); $fieldadd->setType('button'); $fieldadd->setName('fieldadd'); $fieldadd->setValue('add'); $fieldadd->setJs(' onclick="PSA.addField();" '); $tr = new Tr(); $tr->add($colname->dump()); $tr->add($coltype->dump()); $tr->setClas('center'); $tr->add($colprime->dump()); $tr->setClas('center'); $tr->add($colsize->dump()); $tr->setClas('center'); $tr->add($colnull->dump());
$head->setCss('./css/psa.css'); $head->setJs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $body->line("Index creation on table : <b>" . $req->get('table') . "</b><br>"); $form = new Form(); $form->setAction('controller.php'); $form->setJs(' onsubmit="return PSA.indexcol();" '); $form->build(); // TODO: check if table name already exists $name = new Input(); $name->setName('idxname'); $name->setSize(50); $name->setMaxlength(128); $name->setId('idxname'); $body->line('Name : ' . $name->dump() . ' ' . $cmd->dump() . '<br>'); for ($i = 0; $i < sizeof($fields); ++$i) { $select = new Select(); $select->setName('col' . $i); $select->setSize(1); $select->add('', '-'); for ($j = 0; $j < sizeof($fields); ++$j) { $select->add($fields[$j], $fields[$j]); } $body->line('index on : ' . $select->dump() . '<br>'); } $submit->build(); $tblname = new Input(); $tblname->setName('tblname');
$html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - connection'); $head->setCss('./css/psa.css'); $head->setJs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $inp_db = new Input(); $inp_db->setName('newdb'); $inp_db->setSize(25); $inp_db->setMaxlength(128); $submit->setValue('Create'); $submit->setClas('button'); $cmd->setValue('create_db'); $form = new Form(); $form->setAction('controller.php'); $form->build(); $table = new Table(); $table->build(); $tr = new Tr(); $tr->add('New database : '); $tr->add($inp_db->dump()); $tr->add($submit->dump()); $tr->add($cmd->dump()); $tr->build(); unset($table);