php多功能搜索

	 

	$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的专栏

补充：Web开发 , php ,

上一个：用php抓取google关键词排名
下一个：PHP面向切面编程组件