$num=explode(' ',$_POST['name']);//根据多个关键字构建动态SQL语句
$sql="select * from (";
for($i=0;$i<count($num);$i++){
if($i==0)
$sql.="select * from p_newsbase left join p_newscontent on p_newsbase.id=p_newscontent.nid where title like '%$num[0]%' or author like '%$num[0]%' or p_newsbase.keyword like '%$num[0]%' or content like '%$num[0]%'";
else
$sql.=" union select * from p_newsbase left join p_newscontent on p_newsbase.id=p_newscontent.nid where title like '%$num[$i]%' or author like '%$num[$i]%' or p_newsbase.keyword like '%$num[$i]%' or content like '%$num[$i]%'";
}
$sql.=")order by date_time DESC";
$sql="select * from (";
for($i=0;$i<count($num);$i++){
if($i==0)
$sql.="select * from p_newsbase left join p_newscontent on p_newsbase.id=p_newscontent.nid where title like '%$num[0]%' or author like '%$num[0]%' or p_newsbase.keyword like '%$num[0]%' or content like '%$num[0]%'";
else
$sql.=" union select * from p_newsbase left join p_newscontent on p_newsbase.id=p_newscontent.nid where title like '%$num[$i]%' or author like '%$num[$i]%' or p_newsbase.keyword like '%$num[$i]%' or content like '%$num[$i]%'";
}
$sql.=")order by date_time DESC";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货