public function add()
{
if (Page::already($_POST['baseUrl'], $_POST['uri'], $_POST['language'])) {
throw new Exception('PAGE ALREADY EXISTS', 409);
}
$page = new Page();
$page->setBaseUrl($_POST['baseUrl']);
$page->setUri($_POST['uri']);
$page->setLanguage($_POST['language']);
if (array_key_exists('content', $_POST) && !empty($_POST['content'])) {
$page->setContent($_POST['content']);
}
$page->setModele($_POST['modele']);
$page->setTitle($_POST['title']);
if (array_key_exists('languageParentId', $_POST)) {
$page->setLanguageParentId($_POST['languageParentId']);
}
if (array_key_exists('ajax', $_POST)) {
$page->setAjax($_POST['ajax']);
}
if (array_key_exists('published', $_POST)) {
$page->setPublished($_POST['published']);
}
if (array_key_exists('metas', $_POST)) {
$page->setMetas($_POST['metas']);
}
if (array_key_exists('css', $_POST)) {
$page->setCss($_POST['css']);
}
if (array_key_exists('js', $_POST)) {
$page->setJs($_POST['js']);
}
if (array_key_exists('action', $_POST)) {
$page->setAction($_POST['action']);
}
if (array_key_exists('method', $_POST)) {
$page->setMethod($_POST['method']);
}
if (array_key_exists('priority', $_POST)) {
$page->setPriority($_POST['priority']);
}
if (array_key_exists('datas', $_POST)) {
$page->setDatas($_POST['datas']);
}
if (!array_key_exists('blockIds', $_POST)) {
$blkIds = array();
foreach ($_POST['blockIds'] as $blk) {
if (array_key_exists('id', $blk) && MongoId::isValid($blk['id'])) {
$blkIds[] = $blk['id'];
}
}
$this->page->setBlockIds($blkIds);
}
$page->save();
return array('pageId' => $page->getId());
}
foreach ($res as $item) {
if ($item->name == 'id') {
$pk = true;
}
$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;
<?php
/**
* [type] file
* [name] controller.php
* [package] psa
* [since] 2010.09.22
* [update] 2013.12.19 : login added
*/
include_once 'autologin.php';
$cmd->setValue('base');
$submit->setValue('Go');
$html = new Page();
$html->setLanguage('en-en');
$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('
<h3>PHP SQLite Admin tool - PSA in short...</h3>
<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 out the manual for
more information.</p>
<p>Click <a href="login.php">here</a> to log in.</p>
<p> The following issues are already implemented :</p>
header('location: controller.php');
exit;
/**/
}
}
$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();
* [package] psa
* [since] 2010.09.22 - ok
*/
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);
