$odd = TRUE; foreach ($res as $item) { if (!$titles) { $tr = new Th(); $names = array_keys(get_object_vars($item)); foreach ($names as $title) { $tr->add($title); } $tr->build(); $titles = TRUE; } $tr = new Tr(); if ($odd) { $tr->setGlobalClass('even'); $odd = FALSE; } else { $tr->setGlobalClass('odd'); $odd = TRUE; } foreach ($item as $data) { // display odd characters $tr->add(htmlentities($data)); } $tr->build(); } unset($table); } $body->line('</div>'); include_once './inc/footer.php'; unset($body); unset($html);
$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);
$table->build(); foreach ($res as $item) { if ($item->name == 'sqlite_sequence') { continue; } $struct = new Link(); $struct->setHref('controller.php?cmd=tableinfo&table=' . $item->name . '&view=true'); $struct->setName('Structure'); $browse = new Link(); $browse->setHref('controller.php?cmd=table_browse&table=' . $item->name . '&view=true'); $browse->setName('Browse'); $dump = new Link(); $dump->setHref('controller.php?cmd=table_dump&table=' . $item->name . '&view=true'); $dump->setName('Dump'); $drop = new Link(); $drop->setHref('controller.php?cmd=drop_view&table=' . $item->name . '&view==true'); $drop->setName('Drop'); $drop->setJs(' onclick="return PSA.really_drop(\'view\');" '); $tr = new Tr(); $tr->add($item->name); $tr->add($struct->dump()); $tr->add($browse->dump()); $tr->add($dump->dump()); $tr->add($drop->dump()); $tr->build(); } unset($table); } include_once './inc/footer.php'; unset($body); unset($html);
} else { $uniq = 'N'; } $drop = new Link(); $drop->setHref('controller.php?cmd=drop_idx&idxname=' . $item->name . '&table=' . $req->get('table')); $drop->setName('[ drop ]'); $drop->setJs(' onclick="return PSA.really_drop(\' index [' . $item->name . ']\');" '); $tr = new Tr(); if ($odd) { $tr->setGlobalClass('even'); $odd = FALSE; } else { $tr->setGlobalClass('odd'); $odd = TRUE; } $tr->add($item->name); $tr->setClas('center'); $tr->add($uniq); $q = "PRAGMA index_info(" . $item->name . ")"; $sql->qo($q); $rescol = $sql->fo(); $list = ''; foreach ($rescol as $itcol) { $list = $list . $itcol->name . ' ,'; } $tr->add(substr($list, 0, -2)); $tr->add($drop->dump()); $tr->build(); } unset($table); }
} if ($item_fields->pk == 0) { $name = $item_fields->name; } else { $name = $item_fields->name . ' <span class="red">(PK)</span>'; $nn = '-'; } $tr = new Tr(); if ($odd) { $tr->setGlobalClass('even'); $odd = FALSE; } else { $tr->setGlobalClass('odd'); $odd = TRUE; } $tr->add($name); $tr->add($type); $tr->setClas('rechts'); $tr->add($size); $tr->setClas('center'); $tr->add($nn); $tr->add($dflt); $tr->build(); } unset($table); $body->line('</div>'); } } $body->line('</div>'); include_once './inc/footer.php'; unset($body);
$tr = new Tr(); if ($odd) { $tr->setGlobalClass('even'); $odd = FALSE; } else { $tr->setGlobalClass('odd'); $odd = TRUE; } if (!$is_view) { $edit = new Link(); $edit->setHref('controller.php?cmd=edit_record&table=' . $req->get('table') . '&id=' . $item->id); $edit->setName('[edit]'); // $edit->setTarget('edit_del'); $del = new Link(); $del->setHref('controller.php?cmd=drop_record&table=' . $req->get('table') . '&id=' . $item->id); $del->setName('[del]'); $del->setJs(' onclick="return PSA.really_drop(\'record\');" '); $tr->add($edit->dump()); $tr->add($del->dump()); } foreach ($item as $data) { $tr->add(htmlentities($data)); } $tr->build(); } unset($table); } $body->line('</div>'); include_once './inc/footer.php'; unset($body); unset($html);
$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()); $tr->add($coldefault->dump()); $tr->add($fieldadd->dump()); $tr->build(); unset($table); $body->line('<hr />'); $table = new Table(); $table->setId('tfields'); unset($table);
if (!$res) { $body->line('no queries found.'); } else { $table = new Table(); $table->setClas('result'); $table->build(); $th = new Th(); $th->add('database'); $th->add('date - time'); $th->add('query (click to copy in execution field)'); $th->build(); foreach ($res as $item) { $tr = new Tr(); if ($item['fine'] == 0) { $tr->setGlobalClass('query_error'); $tr->add($item['db']); $tr->add($item['datum']); $tr->add(str_repeat(" ", 2) . $item['qs']); } else { $tr->add($item['db']); $tr->add($item['datum']); $tr->add('<div class="qs"> <a href="#" onClick="PSA.to_text(\'' . str_replace('"', "&&", str_replace("'", "##", trim(str_replace("\r\n", " ", $item['qs'])))) . '\');">' . nl2br($item['qs']) . '</a></div>'); } $tr->build(); } unset($table); } unset($psa); /**/
$link->setName('[' . $files[$i] . ']'); $vacuum = new Link(); $vacuum->setHref('controller.php?cmd=vacuum_db&db=' . urlencode($files[$i])); $vacuum->setName('[vacuum]'); $drop = new Link(); $drop->setHref('controller.php?cmd=drop_db&db=' . urlencode($files[$i])); $drop->setName('[drop]'); $drop->setJs(' onclick="return PSA.really_drop(\'database\');" '); $schema = new Link(); $schema->setHref('controller.php?cmd=schema_db&db=' . urlencode($files[$i])); $schema->setName('[schema]'); $tr = new Tr(); if ($odd) { $tr->setGlobalClass('even'); $odd = FALSE; } else { $tr->setGlobalClass('odd'); $odd = TRUE; } $tr->add($link->dump()); $tr->add($vacuum->dump()); $tr->add($drop->dump()); $tr->add($schema->dump()); $tr->build(); } unset($table); } $body->line('</div>'); include_once './inc/footer.php'; unset($body); unset($html);