public/searchsuggest.php

<?php
require "../include/bittorrent.php";
dbconn();
if (isset($_GET['q']) && $_GET['q'] != '')
{
	$searchstr = trim($_GET['q']);
	
	$suggest_query = sql_query("SELECT keywords AS suggest, COUNT(*) AS count FROM suggest WHERE keywords LIKE " . sqlesc($searchstr . "%")." GROUP BY keywords ORDER BY count DESC, keywords DESC LIMIT 10");
	$result = array(htmlspecialchars($searchstr), array(), array());
	while($suggest = mysql_fetch_array($suggest_query)){
		if (strlen($suggest['suggest']) > 25) continue;
		$result[1][] = $suggest['suggest'];
		$result[2][] = $suggest['count']." times";
		$i++;
		if ($i >= 5) break;
	}
	echo json_encode($result);
}
?>
init 2020-12-26 01:42:23 +08:00			`<?php`
add composer 2021-01-13 19:32:26 +08:00			`require "../include/bittorrent.php";`
init 2020-12-26 01:42:23 +08:00			`dbconn();`
			`if (isset($_GET['q']) && $_GET['q'] != '')`
			`{`
			`$searchstr = trim($_GET['q']);`

			`$suggest_query = sql_query("SELECT keywords AS suggest, COUNT(*) AS count FROM suggest WHERE keywords LIKE " . sqlesc($searchstr . "%")." GROUP BY keywords ORDER BY count DESC, keywords DESC LIMIT 10");`
fix email encode and format 2021-02-02 20:27:37 +08:00			`$result = array(htmlspecialchars($searchstr), array(), array());`
init 2020-12-26 01:42:23 +08:00			`while($suggest = mysql_fetch_array($suggest_query)){`
			`if (strlen($suggest['suggest']) > 25) continue;`
			`$result[1][] = $suggest['suggest'];`
			`$result[2][] = $suggest['count']." times";`
			`$i++;`
			`if ($i >= 5) break;`
			`}`
			`echo json_encode($result);`
			`}`
			`?>`