php - 搜索只读到一个关键字 : SQLSTATE[HY093]: Invalid parameter number

Question

我的网站搜索功能出现问题。它不处理包含多个词的搜索词。在 http://mobile.mixtapemonkey.com/ 尝试搜索栏问题的实例

搜索“这样更好”一旦你输入 B，我就会得到一个错误。除了它有效之外，您认为问题是什么？

    if (empty($errors)) {
  $name_explode = explode(' ', $name); // explode keywords to get each individual keyword, and put into array
  $name_count = count($name_explode); // count keywords from array
  foreach($name_explode as $name_single) {
    $x++; // increment x each loop

    $keyword = "%".$name_single."%";

    $where .= '`keywords` LIKE :keyword'; // append to where clause
    if ($name_count!=$x) {
      $where .= ' AND '; // as long as keyword isn't the last, append AND.
    }
  } 

  $sql = "SELECT `name`, `thumb`, `id`, `title` FROM `mixtapes` WHERE ".$where." ORDER BY `id` DESC LIMIT 40";

  $search = $db->prepare($sql); // perform query

  $search->bindParam(':keyword', $keyword, PDO::PARAM_STR);

  $search->execute();

  $search_num_rows = $search->rowCount(); // get number of rows (results) returned

Answer 1

请检查我添加的代码。出现该错误的原因是您的 foreach 循环。在该循环中，您每次都添加 :keyword 。但该计数与 bindParam 值计数不匹配。所以我更改了您的代码并在下面发布

if (empty($errors)) {
$name_explode = explode(' ', $name); // explode keywords to get each individual keyword, and put into array
$name_count = count($name_explode); // count keywords from array
$x = 0;
foreach($name_explode as $name_single) {
$x++; // increment x each loop

$keyword[':keyword'.$x] = "%".$name_single."%";

$where .= '`keywords` LIKE :keyword'.$x; // append to where clause
if ($name_count!=$x) {
  $where .= ' OR '; // as long as keyword isn't the last, append AND.
}
} 

$sql = "SELECT `name`, `thumb`, `id`, `title` FROM `mixtapes` WHERE ".$where." ORDER BY `id` DESC LIMIT 40";

$search = $db->prepare($sql); // perform query


$search->execute($keyword);

$search_num_rows = $search->rowCount(); //