$insert .= $col[$i] . ', '; $vals[] = $item->{$col}[$i]; } $insert = substr($insert, 0, -2) . ") VALUES ('"; // var_dump($vals); for ($i = 0; $i < sizeof($vals); ++$i) { // var_dump($col); // echo "$col[$i] - waarde = ".$item->$col[$i].'<br />'; $insert .= $vals[$i] . "','"; // $vals[] = $item->$col[$i]; } $insert = substr($insert, 0, -2) . ");\r\n"; // echo '<hr />'; // $body->line($insert.'<br />'); $resultset .= $insert; $insert = ''; unset($vals); // echo '<hr />'; } $restext = new Textarea(); $restext->setName('queries'); $restext->setRows(20); $restext->setCols(85); $restext->setValue($resultset); // $restext->setSelected('true'); $restext->build(); } $body->line('</div>'); include_once './inc/footer.php'; unset($body); unset($html);
$html->build(); $head = new Head(); $head->setTitle('PSA - query'); $head->setCss('./css/psa.css'); $head->setJs('./js/PSA.js'); $head->build(); $body = new Body(); $body->build(); include_once './inc/menubar.php'; $body->line('Insert raw sql query : '); $form = new Form(); $form->setAction('controller.php'); $form->build(); $inp_text = new Textarea(); $inp_text->setRows(15); $inp_text->setCols(70); $inp_text->setName('qs'); $inp_text->setId('to_text'); $inp_text->build(); $body->line(); $cmd->build(); $submit->build(); unset($form); $body->line('<hr />'); $psa = new PDO("sqlite:./data/base.sqlite"); $q = "SELECT * FROM queries ORDER BY datum DESC LIMIT 10"; $tps = $psa->prepare($q); $tps->execute(); $res = $tps->fetchAll(); if (!$res) { $body->line('no queries found.');