phpcms搜索功能
原创
©著作权归作者所有:来自51CTO博客作者51CTO璞的原创作品,请联系作者获取转载授权,否则将追究法律责任
form 表单提交:
<p>搜索专业人员</p>
<form action="{$CATEGORYS[13][url]}" method="post">
<input type="text" name="q" id="q" placeholder="按姓名搜索" class="text">
<select>
<option>按专业领域搜索</option>
</select>
<input type="submit" name="" value="搜索" class="submit">
</form>
搜索结果:
{pc:get sql="select * from ns_ren where title like '%$_POST[q]%'" ORDER BY 'inputtime' DESC" num="6" page="$page" return="data"}
{if $data}
{loop $data $r}
<li>
<a href="{$r[url]}">
<img src="{$r[thumb]}">
<p>{$r[title]}</p>
<i>{$r[zw]}</i>
<span>
<img src="{IMG_PATH}pc/ls11.png">
</span>
</a>
</li>
{/loop}
{else}
<h1> 未搜索到您要查找的内容......</h1>
{/if}
{/pc}
ajax 搜索
<form class="fix" >
<input type="text" name="q" id="q" placeholder="请输入关键词" class="text">
<input type="button" name="" value="查询" class="submit" onclick="show_form()" >
</form>
-----------------------------------------------------------------------
<script>
function show_form() {
var q = $("#q").val();
$.ajax({
type: "post",
url: "index.php?m=content&c=index&a=jxscx",
data: {q:q},
dataType: "json",
success: function(data){
if(data.length){
var aa="";
$.each(data,function(i,v){
aa+="<li><a class='tbox'><div class='left'><i><img src='/statics/images/Distributor.jpg'></i></div><div class='right'><p>经销商名称 :<span>"+v.title+"</span></p><p>电话 : <span>"+v.keywords+"</span></p><p>营销等级 :<span>"+v.description+"</span></p></div></a></li>";
});
$('#result_div1').html(aa);
}else{
$('#result_div').html("暂无信息");
}
}
});
}
</script>
-----------------------------------------------------------------------
public function jxscx(){
$q=$_POST['q'];
$this->db->table_name ='v9_jxscx';
$where="title like '%$q%' or keywords like '%$_POST[q]%' or description like '%$_POST[q]%' ORDER BY 'inputtime' DESC ";
$data=$this->db->select($where, '*', '', '', '','');
echo json_encode($data);
//var_dump($data);
}