我如何一次在几个字段中搜索几个单词 - How can I search several word in several fields at once?

How can I search several word in several fields at once?

我正在编写一个搜索模块。我不知道我是不是很好，但除了一分之外，我现在听起来很好。

使用以下代码，我只能搜索一个单词。

<?php
class SearchesController extends AppController{
    function index(){
        if($this->request->is('put') || $this->request->is('post') ){
            // Save the send data
            $search = $this->request->data['Search']['key']; 
            //$nbWords = str_word_count($search);
            /*
            THIS DOES NOT WORKS
            if($nbWords > 1){
                $searchTerms = explode(' ', $search);
                $searchTermBits = array();
                foreach ($searchTerms as $term) {
                    $term = trim($term);
                    if (!empty($term)) {
                        $searchTermBits[] = "Page.name LIKE '%$term%' AND Page.content LIKE '%$term%'";
                    }
                }

            }else{
                $term = $search;
                $searchTermBits[] = "Page.name LIKE '%$term%' AND Page.content LIKE '%$term%'";
            }
            */
            // SEARCH IN Pages TABLE
            $this->loadModel('Page');
            // SAVE THE RESULT IN
            $d['pages'] = $this->Page->find('all', array(
                'conditions' => array(
                    'online'=>'1',
                    'type'=>'page',
                    'created <= NOW()',
                    'id > 1',
                    'OR' => array(
                        //implode(' AND ', $searchTermBits)
                        'Page.name LIKE'=>'%'.$search.'%',
                        'Page.content LIKE'=>'%'.$search.'%'
                        )
                    ),
                'fields' => array('name','content','created','id','type')
            ));
            //SEARCH IN Posts TABLE
            $this->loadModel('Post');
            $d['posts'] = $this->Post->find('all', array(
                'conditions' => array(
                    'online'=>'1',
                    'type'=>'post',
                    'created <= NOW()',
                    'OR' => array(
                        'Post.name LIKE'=>'%'.$search.'%',
                        'Post.content LIKE'=>'%'.$search.'%'
                        )
                    ),
                'fields'=> array('name','content','created','id','type','slug')
            ));
            // SEND THE VALUES TO THE VIEW
            $this->set($d);
        }else{
            echo 'e';
        }
    }
}

问题是，我想能够用不同的词搜索，例如"红色汽车"，"房子monrain"，"网页html5开发"

在我的代码中，如果我输入一个单词，它会返回结果，但如果我在第一个单词上加上第二个单词（带空格），它不会返回结果。

我如何更改此

'OR' => array(
        'Post.name LIKE'=>'%'.$search.'%',
        'Post.content LIKE'=>'%'.$search.'%'
)

让它能够在"名称"answers"内容"几个词中搜索？

谢谢你的帮助干杯

你可以试试这个：

'OR' => array(
       'Post.name' IN ('name1', 'name2'),
       'Post.content' IN ('content1', 'content2')
)

很明显，你可以把你的价值放在这样的数组中：

$name_arr = array();
$name_arr[] = 'name1';
$name_arr[] = 'name2';

以及之后：

'OR' => array(
           'Post.name' IN ($name_arr),
           'Post.content' IN ('content1', 'content2')
    )

更改$search变量

 $search = $this->request->data['Search']['key']; 
 // if keywords "red car" then it will pass to your query %red%car%;
 $search = str_replace(" ","%",$search);

现在它将搜索同时包含这两个单词的记录。

如果您想用空格分隔多个单词进行搜索，可以这样做。

$searches = explode(" ", $search);
foreach ($searches as $search) {
   //put your search condition in here
}

您可以查看全文搜索。如果您正确设置了索引，您可以运行以下查询：

SELECT id，MATCH（标题，正文）反对（"教程"）FROM文章；