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