File: /home/httpd/html/nyloncams.com/public_html/admin/search_content.php
<?php
include('config.php');
error_reporting(0);
$dblink = mysqli_connect($dbserver, $dbuser, $dbpass);
$db = mysqli_select_db($dblink, $dbname);
mysqli_query($dblink, "SET NAMES 'utf8'");
mysqli_query($dblink, "SET CHARSET 'utf8'");
$term = mysqli_real_escape_string($dblink, $_GET['term']);
switch ($_GET['type']) {
case 1:
$query = "SELECT `name` AS `term` FROM pornstars WHERE `name` LIKE '$term%' OR `aka` LIKE '$term%'";
break;
case 2:
$query = "SELECT `username` AS `term` FROM users WHERE `username` LIKE '$term%'";
break;
case 0:
default:
$query = "SELECT `title` AS `term` FROM `content` WHERE `title` LIKE '%$term%' AND `enabled` = 1";
break;
}
$output = array();
$result = mysqli_query($dblink, $query);
if (mysqli_num_rows($result) > 0) {
while ($i = mysqli_fetch_assoc($result)) {
$output[] = trim($i['term']);
}
}
echo json_encode($output);