id); $sql = "SELECT at.tag FROM {artefact_tag} at JOIN {artefact} a ON a.id = at.artefact WHERE a.owner = ? AND a.artefacttype = 'blogpost'"; if ($request !== '') { $sql .= " AND at.tag LIKE '%' || ? || '%'"; $values[] = $request; } $sql .= " GROUP BY at.tag ORDER BY at.tag ASC"; $more = true; $tmptags = array(); $alltags = get_records_sql_array($sql, $values); while ($alltags !== false && $more && count($tmptags) < $tagsperpage) { $tags = array_slice($alltags, $tagsperpage * ($page - 1), $tagsperpage); $more = sizeof($alltags) > $tagsperpage * $page; foreach ($tags as $tag) { if (count($tmptags) >= $tagsperpage) { $more = true; continue; } if (stripos($tag->tag, $request) !== false || $request === '') { $tmptags[] = (object) array('id' => $tagexcluded . $tag->tag, 'text' => $tag->tag); } } $page++; } echo json_encode(array( 'more' => $more, 'results' => $tmptags, ));