/**
*¨[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();
// var_dump($res);
<?php
/**
* [type] file
* [name] tableinfo.php
* [package] psa
* [since] 2010.10.20
*/
$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();
// var_dump($res);
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - show table info for ' . $req->get('table'));
$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>Structure for table : <b>' . $req->get('table') . '</b></h3>');
$table = new Table();
$table->setClas('result');
$table->setId('listing');
$table->build();
$th = new Th();
$colnull = $req->get('colnull');
$colsize = $req->get('colsize');
$coldefault = $req->get('coldefault');
$q = "INSERT INTO temp_table_fields (\n\t\ttblname\n\t\t,colname\n\t\t,coltype\n\t\t,colprime\n\t\t,colnull\n\t\t,colsize\n\t\t,coldefault)\n\t\tVALUES (\n\t\t:tblname\n\t\t,:colname\n\t\t,:coltype\n\t\t,:colprime\n\t\t,:colnull\n\t\t,:colsize\n\t\t,:coldefault)";
$ajax_sql->binder('tblname', $tblname);
$ajax_sql->binder('colname', $colname);
$ajax_sql->binder('colprime', $colprime);
$ajax_sql->binder('coltype', $coltype);
$ajax_sql->binder('colnull', $colnull);
$ajax_sql->binder('colsize', $colsize);
$ajax_sql->binder('coldefault', $coldefault);
$ajax_sql->qo($q);
// DEBUG: var_dump($ajax_sql);
$q = "SELECT * FROM temp_table_fields";
$ajax_sql->qo($q);
$res = $ajax_sql->fo();
$tab = '<table>';
$tab .= '<thead>
<th>name</th>
<th>type</th>
<th>size</th>
<th>prime</th>
<th>null</th>
<th>default</th>
</thead><tbody>';
foreach ($res as $item) {
$tab .= '
<tr><td>' . $item->colname . '</td><td>' . $item->coltype . '</td><td>' . $item->colsize . '</td><td>' . $item->colprime . '</td><td>' . $item->colnull . '</td><td>' . $item->coldefault . '</td><td><a href="#" onclick="PSA.tablerow_delete(' . $item->id . ');"><button>delete</button></a>' . '</td></tr>';
}
$tab .= '</tbody></table>';
echo $tab;
* [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;
}
/* DEBUG: echo '<hr>';
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';
if (!$res) {
