php - LIKE 运算符在 MYSQL 中不起作用

Question

这是我运行时的代码

$name=$_GET['name'];
$strSQL = "SELECT * FROM category WHERE name LIKE =" .$name;

$rs = mysql_query($strSQL);

// Loop the recordset $rs
$response = array();
while($row = mysql_fetch_array($rs)) {


    $product = array();
    $product["id"] = $row["id"];
    $product["name"] = $row["name"];
    array_push($response, $product);
}

echo json_encode($response);
}
error:mysql_fetch_array() expects parameter 1 to be resource, boolean given in while($row = mysql_fetch_array($rs))

该行显示错误，请帮助我解决此问题

Answer 1

您插入了错误的语法....使用这个

 $strSQL = "SELECT * FROM category WHERE name LIKE '%$name'";