Search results for:

prepare(" SELECT url, category, title, snippet(data, '', '', '[...]', 5, 24) FROM data WHERE data MATCH :q ORDER BY category "); $sql->bindValue(':q', $q); $results = $sql->execute(); printf("
"); while ($row = $results->fetchArray(SQLITE3_ASSOC)) { printf('
%s
%s
', relurl(baseurl, $row['url']), $row['title'], $row["snippet(data, '', '', '[...]', 5, 24)"]); } printf("
"); ?>