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;
