HEX
Server: Apache
System: Linux msm5694.mjhst.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64
User: camjab_ssh (1000)
PHP: 5.3.29
Disabled: NONE
Upload Files
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);