PHP search query function implementation

This article mainly introduces the implementation code of PHP search query function. It is very good and has reference value. Friends in need can refer to it

I encountered a problem today: when doing the "search" function , the query cannot be performed after entering the query conditions.

What I am doing is to display the content in the data table package on the homepage, but there is a condition. The content displayed on the homepage must also be: field status=0, and data with printing=0 can be displayed in the homepage list. come out.

There is a "search" function on the page. After entering the conditions, the query will be carried out based on the conditions.

For general search, just give one in the home page display list method index():

$map=array();//初始化查询条件
$map=$this->_search();//调用查询方法
$total = $this->Model->where ($map)->count(); //这个主要是用来计算页面显示数据条数的
if ($total == 0) {
$_list = '';
} else {
$_list = $this->Model->where ($map)->limit( $post_data ['first'] . ',' . $post_data ['rows'] )->select();
}

Then, just write a _search ():

For example:

protected function _search(){
$map = array ();
$post_data = I ( 'post.' );
if ($post_data ['packageid'] != '') {
$map ['packageid'] = array (
'like',
'%' . $post_data ['packageid'] . '%' 
);
}
return $map;
}

Finally, call this search method in the "Search" menu of the settings.

However, when I do this, while searching, I also need to make sure to search in the data with field status=0 and printing=0.

I have been thinking about where to add this restriction. After various attempts and inquiries, I found out. Just add the restriction conditions directly to the SQL statement (as shown in red below). (When I tried it myself, I kept adding conditions in the blue areas below, and failed again and again!)

$map=array();
$map=$this->_search();
$total = $this->Model->where ($map)->where(array('status' =>0,'print_status'=>0))->count();
if ($total == 0) {
$_list = '';
} else {
$_list = $this->Model->where ($map)->where(array('status' =>0,'print_status'=>0))->limit( $post_data ['first'] . ',' . $post_data ['rows'] )->select();
}

The above is the entire content of this article, I hope it will be helpful to me. Everyone’s learning helps.

Related recommendations:

How to append and wrap lines in file_put_contents in PHP

php PDO implements the method to determine whether the connection is available

PHP method to sort a two-dimensional associative array according to one of the fields

The above is the detailed content of PHP search query function implementation. For more information, please follow other related articles on the PHP Chinese website!