php - 在 php foreach 循环中编写 MySql Where 子句

Question

如何在 php foreach 循环中编写 mysql where 子句。这是我的代码

$outPut = Array ( [0] => 'intel' [1] => 'amd' );
$Query = select * from laptop
foreach($outPut as $Filtervalues)
{
  $Query .= "where processor like '%$Filtervalues%'";
}

echo $Query;

但是我的输出不正确。

我希望输出为

select * from laptop where (processor like '%intel%' or processor like '%amd%')

Answer 1

不需要foreach:

<?
$output = Array ( 'intel', 'amd' );
$Query = echo 'select * from laptop where processor LIKE \'%'.join($output,'%\' OR processor LIKE \'%').'\'%';
?>

希望对你有帮助