搜索引擎错误PHP&;Mysql


Search Engine Bug PHP&Mysql

大家好,我的搜索引擎有问题。这是代码:

$types = mysql_real_escape_string($_GET['type']);
//Convertion de GET
if ($types = "air") {
    $searchq = "LF";
}elseif ($types = "huile") {
    $searchq = "OF";
}elseif ($types = "carburant") {
    $searchq = "KF";
}elseif ($types = "habitacle") {
    $searchq = "CF";
}elseif ($types = "eau") {
    $searchq = "WF";
}else{
    $searchq = "DF";
}

$searchq = preg_replace("#[^0-9a-z]#i", "", $searchq);
$query = mysql_query("SELECT * FROM tProduct WHERE sSearch LIKE '%$searchq%'") 
    or die("La Recherche est impossible");
$count = mysql_num_rows($query);
$result = mysql_query("SELECT * FROM tProduct WHERE sSearch LIKE '%$searchq%'");

但问题是searchq只取LF的值。

请问我的代码中的问题在哪里?

if ($types == "air") {
    $searchq = "LF";
}elseif ($types == "huile") {
    $searchq = "OF";
}elseif ($types == "carburant") {
    $searchq = "KF";
}elseif ($types == "habitacle") {
    $searchq = "CF";
}elseif ($types == "eau") {
    $searchq = "WF";
}else{
    $searchq = "DF";
}

您正在分配而不是比较。使用==比较字符串

请参阅此处的文档:http://php.net/manual/en/language.operators.comparison.php

附带说明一下,您应该切换到PDO或mysqli并使用准备好的语句。mysql函数已被弃用。