public function testVerificaSeGetFieldPassaAlert()
{
$textarea = new Textarea();
$textarea->setName("descricao");
$textarea->setValue("descricao");
$this->assertEquals('<textarea id="" name="descricao" class="" rows="" >descricao</textarea><p class="text-danger"></p>', $textarea->getField('alert'));
}
$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);
$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.');
} else {
