hi and thanks for replies.
i use : laravel-scout-mysql-driver to index and search mysql database. according to this set: 'strict'=>false
the code:
public function searchpages(Request $request){
$query= $request->get('query');
$adpgs=[];
$pages= \App\Page::search("*".$query."*")->paginate(1);
return view('content.pages_show')->with(['pages'=>$pages,'adpgs'=>$adpgs]);
}
provides pagination links correctly, but when click on links, the error:
SQLSTATE[42000]: Syntax error or access violation: 1064 syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*' (SQL: select count(*) as aggregate from `pages` where MATCH(en_id,fa_id,title,subtitle,address,phones,mobiles,brf_work_hours,moreinfo) AGAINST(**qqq** IN BOOLEAN MODE))
is shown. Why and what i most do???