使用AND、OR和NOT運算子的PHP全文搜尋功能

Question

新手問題： 我正在嘗試使用php和eloquent在搜尋字串上實現全文搜尋。

$searchstring = " (victim suspect) crime -covid";
$searchresult = RssItem::whereRaw("MATCH (description) AGAINST ('$searchstring' IN BOOLEAN MODE)")->get();

我希望我的用戶能夠設定類似這樣的搜尋字串：

$searchstring = "(victim OR suspect) AND crime NOT covid";

有沒有簡單的方法可以將使用者輸入轉換為php中mysql的布林全文搜尋字串？

Answer 1

我已經通過以下方式完成了它：

$searchstring = '(victim OR suspect) AND crime NOT covid';
  $searchstring = str_replace(" OR ", ' ', $searchstring);
  $searchstring = str_replace(" AND ", ' +', $searchstring);
  $searchstring = str_replace(" NOT ", ' -', $searchstring);
  $searchstring = '+'.$searchstring;

  $searchresult = RssItem::whereRaw("MATCH (description) AGAINST ('$searchstring' IN BOOLEAN MODE)")->get();

但也許有更好的方法？ :-)