Question

php 多关键字搜索问题

多关键字进行搜索并加亮显示 请问*************号部分怎么写才能实现 或者还有更好的办法么 谢谢 <?php
include("include/mysql.class.php");
$db=new MySql('localhost','root','','navigation','$conn','GBK');
if($_POST['key']){
$key=$_POST['key'];
$k=explode(" ",$key);//拆分关键字
$j=count($k);//计算关键字的个数

$sql="select * from tiku where body like *********and body like*********";
$serch=$db->query($sql);
while($row=mysql_fetch_array($serch)){
for($l=0;$l<$j;$l++){
$row['body']=preg_replace("/$k[$l]/","<font color=#ff0000><b>$k[$l]</b></font>",$row['body']);
}
echo $row['body']."<br><hr>";}
}
?><form action="" method="post">
关键字：<input type="text" name="key"/>
<input type="submit" value="搜索" />
</form>

Answer 1

$sql="select * from tiku where body like %内容1% and body like %内容2%";注意内容的引号