php search (query) function

I encountered a problem today: when using 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.

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 homepage display list method index():

$map=array();//Initialize query conditions

$map=$this->_search();// Call the query method

$total = $this->Model->where ($map)->count(); //This is mainly used to calculate the number of data items displayed on the page

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

Then, just write a _search():

such as:

protected function _search(){

$map = array ();
$post_data = I ( 'post.' );

if ($post_data ['packageid'] != '') {
$map ['packageid'] = array (
'like',
'%' . $post_data ['packageid'] . '%'
);
}

return $map;

}

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

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 put 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 area below, and failed every time!)

$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();
}

I would like to share it with you.