}
} else {
setcookie('testcookie', 'gone', time() - 3600);
header('location: login.php');
exit;
}
$sessie = new Session();
$valgeld = $sessie->getS('psa-valid');
if ($valgeld !== 'jaja') {
header('location: login.php');
exit;
}
$psa = new LitePDO('sqlite:./data/base.sqlite');
$q = "SELECT * FROM base";
$psa->qo($q);
$result = $psa->fo_one();
if (!$sessie->isS('psa-ext')) {
$sessie->setS('psa-ext', $result->extension);
}
if (!$sessie->isS('psa-dir')) {
$sessie->setS('psa-dir', $result->directory);
}
define('LIMIT', $result->nr_rows);
unset($psa);
$req = new Request();
$submit = new Input();
$submit->setName('submit');
$submit->setType('submit');
$cmd = new Input();
$cmd->setName('cmd');
$cmd->setType('hidden');
$sql->qo($q);
$res = $sql->fo();
$pk = false;
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();
$error = true;
$errmsg = 'oeps - Table name may not be blank';
}
// colname not blank
if (!$error) {
if ($req->get('colname') === '') {
$error = 'true';
$errmsg = 'oeps - Column name may not be blank';
}
}
// no columns with same name
if (!$error) {
$q = "SELECT colname FROM temp_table_fields WHERE colname = '" . $req->get('colname') . "' ";
// echo $q;
$ajax_sql->qo($q);
$res = $ajax_sql->fo_one();
//var_dump($res);
if (!$res) {
// void - no duplication
} else {
$errmsg = 'oeps - Name already exists';
$error = true;
}
}
// no double primary key
if (!$error) {
// check if colprime already set , if so -> warning
if ($req->get('colprime') === "1") {
$q = "SELECT id FROM temp_table_fields WHERE colprime > 0";
// echo $q;
$ajax_sql->qo($q);
