Question

I have the following fields: firstname and lastname keyword is $keyword if someone searches for: John Doe I want it to be able to return results. now it returns results if its john, or if its doe. here is the code:

$q1 = strtolower($_GET["q"]);
$q=str_replace(" ","%",$q1);
$sql = "select DISTINCT users.*, user_id FROM users WHERE $email_filter 
firstname LIKE  %$q%  OR lastname LIKE  %$q%  ORDER BY lastname";
$rsd = mysql_query($sql);
while($rs = mysql_fetch_array($rsd)) { echo $results }

非常感谢你们。

Answer 1

你们想要的是,第一名字和最后名字与你的参数相对应,而不是第一个名字或最后一个名字,因此,它应当是第一名LKE%,最后名LKE %

铭记既然你正在使用LKE,如果名字是John Doe,Johnnie Doe,John Do, John Do, Johnnie 是否将连同第1名John和最后名字是Doe的其他记录一并归还。

Answer 2

如果用户提供像“John Doe”这样的答复,那么这种答复就应当将任何额外的白色空间分开,根据你规定的代码将所提供的姓名细分为价值观和询问:

$q1 = trim(strtolower($_GET["q"]));
$name = explode(" ",$q1);
$fname = $name[0];
$lname = $name[1];
$sql = "select DISTINCT users.*, user_id FROM users WHERE $email_filter 
firstname LIKE  %$fname%  OR lastname LIKE  %$lname%  ORDER BY lastname";
$rsd = mysql_query($sql);
while($rs = mysql_fetch_array($rsd)) { echo $results; }

希望它有助于

友情链接