我正在尝试对数据库实施全文搜索查询。这是我的客户发给我的规范:
"The free text search limits the result of the data table to records with a matching first
name, last name, country, city, state, or zip code. If several words are input,
each word must match one of the columns for a record to be visible."
我做了一些very我的控制器中的丑陋的意大利面条代码尝试它是否有效:
public function search($searchTerms){
$searchTerms = explode(' ', $searchTerms);
$results = array();
foreach ($searchTerms as $searchTerm) {
if (!People::where('firstname', 'LIKE', '%'.$searchTerm.'%')->get()->isEmpty()) {
array_push($results, People::where('firstname', 'LIKE', '%'.$searchTerm.'%')->get());
}
else if (!People::where('lastname', 'LIKE', '%'.$searchTerm.'%')->get()->isEmpty()) {
array_push($results, People::where('lastname', 'LIKE', '%'.$searchTerm.'%')->get());
}
}
return $results;
}
这是我对此函数的调用:
$data->people = $this->search(Input::get('search'));
问题是,如果没有搜索输入,我用它来获取所有数据:
$data->people = People::orderBy($order)->paginate(10);
通过将搜索结果作为数组获取,我在视图中收到以下错误:
Undefined property: Illuminate\Database\Eloquent\Collection::$firstname (View: /home/projects/pplproject/app/views/index.blade.php)
这在国内应该如何实施Laravel 方式?