}
if (!$error) {
// finally , everything is ok and ready for processing
$q = "DELETE FROM temp_table_fields WHERE tblname <> '" . $req->get('tblname') . "' ";
// $q = "INSERT INTO temp_table_fields (tblname) VALUES ('xxx')";
$ajax_sql->qo($q);
// var_dump($ajax_sql);
$tblname = $req->get('tblname');
$colname = $req->get('colname');
$coltype = $req->get('coltype');
$colprime = $req->get('colprime');
$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>
}
$q = "INSERT INTO " . $req->get('data_table') . " (";
for ($i = 0; $i < sizeof($datafields); ++$i) {
$q .= $datafields[$i]['field'] . ",";
// = '".$datafields[$i]['value']."' ,";
}
$q = substr($q, 0, -1);
/*
if($pk) {
$q .= " WHERE id = ".$req->get('data_id')." ";
} else {
$q .= " WHERE ROWID = ".$req->get('data_id')." ";
}
*/
$q .= ') VALUES (';
for ($i = 0; $i < sizeof($datafields); ++$i) {
$q .= ':' . $datafields[$i]['field'] . ",";
// = '".$datafields[$i]['value']."' ,";
}
$q = substr($q, 0, -1);
$q .= ")";
// echo $q;
for ($i = 0; $i < sizeof($datafields); ++$i) {
$sql->binder($datafields[$i]['field'], $datafields[$i]['value']);
}
$sql->qo($q);
$sessie->setS('psa-message', 'Record updated.');
/**/
header('location: controller.php?cmd=table_browse&table=' . $req->get('data_table'));
exit;
/**/
exit;
}
// check if directory is writable
if (!is_writable($req->get('directory'))) {
$sessie->setS('psa-error', "Directory not writable.");
header("location: controller.php?cmd=base");
exit;
}
}
}
if ($req->is('extension')) {
$sessie->setS('psa-dir', $req->get('directory'));
$sessie->setS('psa-ext', $req->get('extension'));
$psa = new LitePDO('sqlite:./data/base.sqlite');
$q = "UPDATE\n\t\tbase\n\tSET\n\t\tdirectory = :directory\n\t\t, extension = :extension\n\t\t, nr_rows = :nr_rows\n\t";
$psa->binder('directory', $req->get('directory'));
$psa->binder('extension', $req->get('extension'));
$psa->binder('nr_rows', $req->get('nr_rows'));
$psa->qo($q);
unset($psa);
}
if ($sessie->isS('psa-db')) {
$sessie->unsetS('psa-db');
}
if (!is_writable($sessie->getS('psa-dir'))) {
$sessie->setS('psa-error', "Directory not writable.");
header("location: controller.php");
exit;
}
$html = new Page();
$html->setLanguage('nl_NL');
