$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);
