setcookie('testcookie', time(), time() + 600); } } 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');
<?php /** *¨[type] file * [name] record_add.php * [package] psa * [since] 2012.02.12 * [expl] */ # TODO: submit and cmd $submit->setValue('Update'); $cmd->setValue('edit_do'); /**/ $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(); $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();
/** * [type] file * [name] drop_column.php * [package] psa * [since] 2012.01.21 * [expl] action file !! */ /* $req->dump(); echo '<hr />'; */ $sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . ''); // get list of existing columns // copy to temp leaving out the column to be deleted $q = "PRAGMA table_info('" . $req->get('table') . "')"; $sql->qo($q); $rescols = $sql->fo(); if (sizeof($rescols) === 1) { $q = "DROP TABLE " . $req->get('table') . " "; $sql->qo($q); $sessie->setS('psa-error', 'Table "' . $req->get('table') . '" dropped. No more columns'); header('location: controller.php?cmd=table'); exit; } $string = ''; $begin = true; $colums = ''; foreach ($rescols as $item) { if ($item->name === $req->get('col')) { continue; }
if ($item->colnull == 1) { $createstring .= ' NULL '; } else { $createstring .= ' NOT NULL '; } if ($item->coldefault !== '') { $createstring .= ' DEFAULT "' . $item->coldefault . '" '; } } $createstring .= ', '; /* echo $createstring; echo '<br>'; /**/ } $createstring = substr($createstring, 0, -2) . ')'; /* echo $createstring; echo '<br>'; /**/ unset($sql); $sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . ''); if ($sql->qo($createstring)) { $sessie->setS('psa-message', 'Table created succesfully.'); } else { $sessie->setS('psa-error', 'Table \'' . $tablename . '\' could not be created.'); } /**/ header('location: controller.php?cmd=table'); exit; /**/
if ($req->get('tblname') === '') { $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;
$tps->execute(); } catch (PDOException $e) { echo 'Connection failed: ' . $e->getMessage(); } /**/ unset($psa); // QUERY $sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . ''); $q = stripslashes($req->get('qs')); $q_ar = explode(";", $q); $error = FALSE; for ($i = 0; $i < sizeof($q_ar); ++$i) { if (trim($q_ar[$i]) === '') { continue; } $sql->qo($q_ar[$i]); if ($sessie->isS('sqler')) { /* echo 'sqler is set : '.$sessie->getS('sqler'); echo '<hr>'; $class = $sessie->getS('sqler'); foreach($class->errorInfo as $key => $value) { //print $value; //print '<hr>'; if($key == '2') { echo $value; } } die();
} if ($req->is('db')) { if ($req->get('db') == '') { $sessie->setS('psa-error', 'No database set.'); header('location: controller.php?cmd=base'); exit; } $sessie->setS('psa-db', urldecode($req->get('db'))); } // 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';
<?php /** * [type] file * [name] table_add.php * [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);
<?php /** * [type] file * [name] vacuum_db.php * [package] psa * [since] 2010.10.21 * [expl] action file */ $sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $req->get('db') . '.' . $sessie->getS('psa-ext') . ''); $sql->qo('VACUUM'); $sessie->setS('psa-message', 'Vacuum performed on "' . $req->get('db') . '".'); header('location: controller.php?cmd=base'); exit;