foreach ($waarden as $key => $value) {
if (sizeof(explode("|", $velden[$key])) > 1) {
$e = explode("|", $velden[$key]);
$q .= "(" . $e[0] . " LIKE '%" . $value . "%' OR " . $e[1] . " LIKE '%" . $value . "%') AND ";
} else {
$q .= $velden[$key] . " LIKE '%" . $value . "%' AND ";
}
}
$q = substr($q, 0, -6);
}
$q .= " ORDER BY datum DESC";
$_SESSION["query"] = $q;
//eerste een query voor het aantal resultaten
$statement = DB::getDB()->prepare($q);
$statement->execute();
$statement->store_result();
$paginering['aantal_rijen'] = $statement->num_rows;
$q .= " LIMIT {$vanaf}, {$AANTAL_PER_PAGINA}";
$lijst = array();
$statement = DB::getDB()->prepare($q);
$statement->execute();
$statement->store_result();
$statement->bind_result($id);
while ($statement->fetch()) {
$h = new Herstelformulier($id);
$lijst[] = $h->toArray();
}
$statement->close();
$paginering["aantal_paginas"] = ceil($paginering['aantal_rijen'] / $AANTAL_PER_PAGINA);
$uitvoer = array($paginering, $lijst);
echo json_encode($uitvoer);
