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