$flag=$_post['flag'];
$sosoval=$_post['keyword'];
$sosoquery="where 1=1 ";
if(!emptyempty($sosoval)&&$flag!=='-1'){
//$sosoquery.="and (title like '%$sosoval%') or (keyword like '%$sosoval%') or (author like '%$sosoval%')";
if($flag=='1'){
$sosoquery.="and (author like '%$sosoval%')";
}elseif ($flag=='2'){
$sosoquery.="and (title like '%$sosoval%')";
}else{
$sosoquery.="and (keyword like '%$sosoval%')";
}
} $sql="select * from article $sosoquery order by id desc";
$rs=$db->query($sql);
$date=array();
while ($row=$db->fetch_array($rs)){
$date[]=$row;
}
$tpl->assign('soso',$date);
$tpl->assign('appname','信息示例');
$tpl->display('index/up.tpl');
chaojie2009的专栏
如对本文有疑问, 点击进行留言回复!!
[ACTF2020 新生赛]Include 1【文件包含】【读取代码】
算法题解 - 牛客编程巅峰赛S1第6场 - 黄金&钻石&王者组
推荐一个程序员必备网站之一:Dev Hints ,非常实用!
网友评论