php - 在 php 文件和 MySQL 上使用 Like 函数

Question

我有一个连接到 MySQL 数据库的 php 文件。假设从 URL 获取两个参数，并对字符串参数使用类似的函数。这是我的 php 文件:

<?php

mysql_connect("mysql.1freehosting.com","u948577195_uname","p7CraCuRAw");

mysql_select_db("u948577195_dbnam");

$param = $_GET['param'];
$UserID = $_GET['UserID'];

$sql=mysql_query("SELECT        UserID, UserName, DisplayName
FROM          User
WHERE       (UserID <> '$UserID') and (UserID NOT IN
                             (SELECT        UserID1 AS UserID
                               FROM            Friend
                               WHERE        (UserID2 = '$UserID')
                               UNION ALL
                               SELECT        UserID2 AS UserID
                               FROM            Friend AS Friend_1
                               WHERE        (UserID1 = '$UserID'))) AND( (UserName LIKE %'$param'%) OR
                            (DisplayName LIKE %'$param'%))");

while($row=mysql_fetch_assoc($sql))

$output[]=$row;

print(json_encode($output));

mysql_close();

?>

这是 php 文件的 URL:http://pickupfriend.fulba.com/android_project/query7.php?param=s&UserID=1 。看来这个功能是因为LIKE部分而下降的。我该如何解决这个问题？

Answer 1

您的查询格式应如下所示。将 % 包含在 ''

中

$sql=mysql_query("SELECT UserID, 
UserName, 
DisplayName
FROM User
WHERE UserID <> '$UserID'
and UserID NOT IN (
SELECT UserID1 AS UserID
FROM Friend
WHERE UserID2 = '$UserID'
UNION ALL
SELECT  UserID2 
FROM Friend 
WHERE UserID1 = '$UserID'
) 
AND (UserName LIKE '%$param%'
OR DisplayName LIKE '%$param%')")