$inp_ext->setName('extension'); $inp_ext->setSize(10); $inp_ext->setValue($result->extension); $inp_lines = new Input(); $inp_lines->setName('nr_rows'); $inp_lines->setSize(7); $inp_lines->setValue($result->nr_rows); $form = new Form(); $form->setAction('controller.php'); $form->build(); $table = new Table(); $table->build(); $tr = new Tr(); $tr->add('Directory : '); $tr->add($inp_dir->dump()); $tr->add($cmd->dump()); $tr->build(); $tr = new Tr(); $tr->add('Extension : '); $tr->add($inp_ext->dump()); $tr->build(); $tr = new Tr(); $tr->add('# records in view : '); $tr->add($inp_lines->dump()); $tr->build(); $tr = new Tr(); $tr->add(' '); $tr->add($submit->dump()); $tr->build(); unset($table); unset($form);
// $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 />'); $backlink = new Link(); $backlink->setHref('controller.php?cmd=table_browse&table=' . $req->get('table')); $backlink->setName('Back to list'); $backlink->build();
$inp_pass->setSize(20); $html = new Page(); $html->setLanguage('nl-nl'); $html->build(); $head = new Head(); $head->setTitle('PSA - login'); $head->setCss('./css/psa.css'); $head->setJs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); $body->line('<h3>PHP SQLite Admin tool - log in</h3>'); $form = new Form(); $form->setAction('login.php'); $form->build(); $table = new Table(); $table->build(); $tr = new Tr(); $tr->add('Login'); $tr->add($inp_naam->dump()); $tr->build(); $tr = new Tr(); $tr->add('Pass'); $tr->add($inp_pass->dump()); $tr->build(); $tr = new Tr(); $tr->add(' '); $tr->add($submit->dump()); $tr->build(); unset($table); unset($form);
$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'); $tblname->setSize(128); $tblname->setValue($req->get('table'));
$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()); $tr->add($coldefault->dump()); $tr->add($fieldadd->dump()); $tr->build(); unset($table); $body->line('<hr />'); $table = new Table(); $table->setId('tfields'); unset($table); $body->line('<div id="ttshow"></div>'); $body->line('</div>'); include_once './inc/footer.php'; unset($body); unset($html);
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); unset($form); $body->line('<hr />'); $files = array(); if ($handle = opendir($sessie->getS('psa-dir'))) { while (false !== ($file = readdir($handle))) { if ($file != "." && $file != "..") { if (stristr($file, '.' . $sessie->getS('psa-ext'))) { $files[] = str_replace('.' . $sessie->getS('psa-ext'), '', $file); } } }