<?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');
