thinkphp模糊查询实例

前端:

样式随便放  

 <style type="text/css">
.searchinput{
  border-right-width: 0px;
  padding-left: 3px;
  width: 168px;
  font-family: arial;
  float: left;
  border-top-width: 0px;
  border-bottom-width: 0px;
  color: #636365;
  margin-left: 4px;
  font-size: 8pt;
  vertical-align: middle;
  border-left-width: 0px;
  margin-right: 3px;
}
.tab_search{
  border-bottom: #cccccc 1px solid;
  border-left: #cccccc 1px solid;
  height: 25px;
  border-top: #cccccc 1px solid;
  border-right: #cccccc 1px solid;


}
.searchaction{
  width: 21px;
  float: left;
  height: 17px;
}
</style>

下面是form表单

<form action="{:U('Admin/Statistics/money_list')}" name="search" method="post">
<table border="0" align="center" cellpadding="0" cellspacing="0" class="tab_search">
  <tr>
    <td>
      <input type="text" title="Search" class="searchinput" id="searchinput" onkeydown="if (event.keyCode==13) {}" onblur="if(this.value=='')value='- 按订单号或用户名查询 -';" onfocus="if(this.value=='- 按订单号或用户名查询 -')value='';" value="- 按订单号或用户名查询 -" size="10" name="search"/>
    </td>
    <td>
      <input type="image" width="21" height="17" class="searchaction" onclick="if(document.forms['search'].searchinput.value=='- 按订单号或用户名查询 -')document.forms['search'].searchinput.value='';" alt="Search" src="__PUBLIC__/assets/Admin/images/magglass.gif" border="0" hspace="2"/>
    </td>
  </tr>
</table>
</form>

后台:

  //得到所有的竞价列表
    public function money_list(){
     $demo=M("chuanbo");
     $money_list=$demo->table('bo_account_log a,bo_user b')->where("a.user_id=b.id")->order('a.id desc' )->select();
        $search = I("post.search"); 
      if(IS_POST){
       $where['order_no']  = array('like','%'.$search.'%');
       $money_list =$demo->table('bo_account_log a,bo_user b')->where("a.user_id=b.id and (a.order_no like '%$search%' or user_name like '%$search%') ")->select();
}else{
   $money_list=$demo->table('bo_account_log a,bo_user b')->where("a.user_id=b.id")->order('a.id desc' )->select();
}    
        $user=M("user");   
        $this->assign('money_list',$money_list);
        $this->display();
        
      }


    }