search.php

<?php
require('lib/common.php');

$query = (isset($_GET['query']) ? trim($_GET['query']) : '');
$page = (isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0 ? $_GET['page'] : 1);

if ($query) {
	$limit = sprintf("LIMIT %s,%s", (($page - 1) * $lpp), $lpp);
	$levels = query("SELECT $userfields l.id,l.title FROM levels l JOIN users u ON l.author = u.id WHERE l.title LIKE CONCAT('%', ?, '%') AND l.locked = 0 ORDER BY l.id DESC $limit",
		[$query]);
	$count = result("SELECT COUNT(*) FROM levels l WHERE title LIKE CONCAT('%', ?, '%')",
		[$query]);
}

echo twigloader()->render('search.twig', [
	'query' => $query,
	'page' => $page,
	'levels' => $levels ?? null,
	'level_count' => $count ?? null
]);