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