Example #1
0
if ($pk) {
    $q = "SELECT * FROM " . $req->get('table') . " ";
} else {
    $q = "SELECT ROWID as id,* FROM " . $req->get('table') . "  ";
}
$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 - query results');
$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>Table : ' . $req->get('table') . '</h3>');
$odd = FALSE;
if (!$res) {
    $body->line('Table does not contain records');
} else {
    $resultset = '';
    foreach ($res as $item) {
        $insert = 'INSERT INTO ' . $req->get('table') . ' (';
        for ($i = 0; $i < sizeof($col); ++$i) {
            // var_dump($col);
            // echo "$col[$i] - waarde = ".$item->$col[$i].'<br />';