<?php /** *¨[type] file * [name] query_results.php * [package] psa * [since] 2010.09.22 -ok */ $res = unserialize($sessie->getS('psa-results')); $sessie->unsetS('psa-results'); $html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - query results'); $head->setCss('./css/psa.css'); $head->setJs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $body->line('Executed query : <br />'); $body->line('<p class="qs">' . $sessie->getS('psa-query-results') . '<hr />'); $sessie->unsetS('psa-query-results'); $titles = FALSE; if (!$res) { $body->line('no further feedback'); } else { $table = new Table(); $table->setClas('result');
$col[] = $item->name; } if ($pk) { $q = "SELECT * FROM " . $req->get('table') . " WHERE id = " . $req->get('id'); } else { $q = "SELECT * FROM " . $req->get('table') . " WHERE ROWID = " . $req->get('id'); } $sql->qo($q); $res = $sql->fo_one(); // var_dump($res); $html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - edit record'); $head->setCss('./css/psa.css'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $form = new Form(); $form->setAction('controller.php'); $form->build(); $table = new Table(); $table->build(); $i = 0; $inp = new Input(); $inp->setName('data_id'); $inp->setValue($req->get('id')); $inp->setType('hidden');
return view('website.packages', ['package' => false]); } } } }); Route::get('/team', function () { Head::setTitle('Team'); return view('website.team'); }); Route::get('/wiki/{path?}', function ($path = 'index') { if ($path == 'index') { Head::setTitle('Wiki'); } else { $path = preg_replace('/\\/$/', '', $path); Head::setTitle('Wiki: ' . ucfirst(preg_replace('/^.*\\//', '', $path))); } // return the requested wiki page or a 404 if it doesn't exist if (file_exists(base_path() . '/resources/views/wiki/' . $path . '.md.blade.php')) { return view('website.wiki', ['path' => $path]); } else { if (file_exists(base_path() . '/resources/views/wiki/' . $path . '/index.md.blade.php')) { return view('website.wiki', ['path' => $path . '/index']); } else { abort(404); } } })->where('path', '.*'); Route::get('/downloads', function () { Head::setTitle('Downloads'); return view('website.downloads'); });
* [type] file * [name] tableinfo.php * [package] psa * [since] 2010.10.20 */ $sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . ''); $q = "PRAGMA table_info('" . $req->get('table') . "')"; $sql->qo($q); $res = $sql->fo(); // var_dump($res); $html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - show table info for ' . $req->get('table')); $head->setCss('./css/psa.css'); $head->setJs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $body->line('<h3>Structure for table : <b>' . $req->get('table') . '</b></h3>'); $table = new Table(); $table->setClas('result'); $table->setId('listing'); $table->build(); $th = new Th(); $th->add('name'); $th->add('type'); $th->add('size');
$col[] = $item->name; } } if ($pk) { $q = "SELECT * FROM " . $req->get('table') . " "; } else { $q = "SELECT ROWID as id,* FROM " . $req->get('table') . " "; } $sql->qo($q); $res = $sql->fo(); $html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - csv'); $head->setCss('./css/psa.css'); $head->setjs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $body->line('<h3>Table : ' . $req->get('table') . '</h3>'); $odd = FALSE; if (!$res) { $body->line('Table does not contain records'); } else { $resultset = ''; $string = ''; foreach ($res as $item) { $linear = (array) $item;
} } $submit->setValue('Let\'s go'); $inp_naam = new Input(); $inp_naam->setName('name'); $inp_naam->setSize(20); $inp_naam->setAutofocus(true); $inp_pass = new Input(); $inp_pass->setName('geheim'); $inp_pass->setType('password'); $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();
header('location: controller.php'); exit; } else { include_once './module/' . $req->get('cmd') . '.php'; } } else { $sessie->unsetS('psa-dir'); $sessie->unsetS('psa-ext'); $sessie->unsetS('psa-db'); $cmd->setValue('base'); $submit->setValue('Go'); $html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setTitle('PSA - homepage'); $head->setCss('./css/psa.css'); $head->setJs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $body->line(' <p>Databases will be selected based on the preset directory and extension. Currently the following are stored : </p>'); include_once './forms/form_base.php'; $body->line('<hr /> <p>PSA stands for PHP - SQLite - Administration. This application lets you do the basic operations with SQLite3 databases. The current version only supports the very basics. Check <a href="controller.php?cmd=bts">[here]</a> for more information.</p>
unset($psa); } $sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . ''); // var_dump($sql); $q = "SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name"; // echo $q; // $sql->qo('PRAGMA table_info('.$req->get('name').')'); $sql->qo($q); $res = $sql->fo(); // unset($sql); $html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - show tables'); $head->setCss('./css/psa.css'); $head->setjs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $body->line(); $link = new Link(); $link->setHref('controller.php?cmd=table_add'); $link->setClas('butter'); $link->setName('Add table'); $link->build(); $body->line('<hr>'); if (!$res) { $body->line('No tables defined.');
$submit->setValue('Create'); $cmd->setValue('index_add_do'); $sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . ''); $fields = array(); $q = "PRAGMA table_info('" . $req->get('table') . "')"; $sql->qo($q); $res = $sql->fo(); foreach ($res as $item) { $fields[] = $item->name; } $html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - create index'); $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);
<?php /** * [type] file * [name] bts.php * [package] psa * [since] 2011.02.10 * [expl] documentation avant la lettre - Behind The Screens */ $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'; $body->line('<div class="xemel">'); $xml = simplexml_load_file('./inc/bts.xml'); // menu foreach ($xml->item->caption as $cap) { $link = new Link(); // $link->setHref('#'.$cap->name); $body->line('<a href="#' . $cap->name . '" >' . $cap->name . '</a><br />'); } $body->line('<hr />'); // content
} // PAGING if (!$sessie->isS('bottom')) { $sessie->setS('bottom', 0); } $sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . ''); $q = "SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name"; $sql->qo($q); $res = $sql->fo(); // echo "BOTTOM WAARDE : <b><h1>".$sessie->getS('bottom')."</h1></b>"; $html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - database schema'); $head->setCss('./css/psa.css', 'screen'); $head->setCss('./css/psaprint.css', 'print'); $head->setjs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; if (!$res) { $body->line('no tables defined yet'); } else { foreach ($res as $item) { $body->line('<div class="schema"><h3>' . $item->name . '</h3>'); $q_fields = "PRAGMA table_info('" . $item->name . "')"; $sql->qo($q_fields); $res_fields = $sql->fo();
* [package] psa * [since] 2011.02.10 */ // $req->dump(); // begin with a fresh state $base_sql = new LitePDO('sqlite:./data/base.sqlite'); $base_q = "DELETE FROM temp_table_fields"; $base_sql->qo($base_q); unset($base_sql); $sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . ''); $html = new Page(); $html->setLanguage('nl_NL'); $html->build(); $head = new Head(); $head->setCharset('UTF-8'); $head->setTitle('PSA - add table'); $head->setCss('./css/psa.css'); $head->setJs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; // TODO: check if table name already exists $name = new Input(); $name->setName('tblname'); $name->setSize(50); $name->setMaxlength(128); $name->setId('tblname'); $body->line('<span class="vet">Table name</span><br /> '); $body->line($name->dump()); $create = new Link();
if (!$sessie->isS('psa-db')) { if ($req->get('db')) { $sessie->setS('psa-db', urldecode($req->get('db'))); } else { $sessie->setS('psa-error', 'No database set.'); header('location: controller.php?cmd=base'); exit; } } $cmd->setValue('qs'); $submit->setValue('Go!'); $html = new Page(); $html->setLanguage('en_EN'); $html->build(); $head = new Head(); $head->setTitle('PSA - query'); $head->setCss('./css/psa.css'); $head->setJs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $body->line('Insert raw sql query : '); $form = new Form(); $form->setAction('controller.php'); $form->build(); $inp_text = new Textarea(); $inp_text->setRows(15); $inp_text->setCols(70); $inp_text->setName('qs'); $inp_text->setId('to_text');