Postgresql查询如何解析用户搜索字符串 - How to parse user search string for Postgresql query?

How to parse user search string for Postgresql query?

我在我的网站上使用postgresql的全文搜索创建了一个搜索引擎。我在我的PHP页面中添加了一个搜索框，用户可以在其中编写这样的字符串:

word1 +word2
word1+word2
word1    -word2
 word1-word2
word1 word2
word1  word2

如何将它们转换为以下字符串?

word1&word2
word1&word2
word1&!word2
word1&!word2
word1|word2
word1|word2

我尝试了几种解决方案，但没有一种适用于所有情况。我最后尝试的是如下:

    $user_query_string = trim($_GET['search']);
    $final_query_string = str_replace(array('+', ' ', '-'), array('&','|', '&!'), $user_query_string);

试试这个:

$a=array('word1 +word2','word1+word2','word1    -word2',' word1-word2','word1 word2','word1  word2');
foreach ($a as &$v) {
  $v=preg_replace('/ +/','|',        // last: change blanks to |
     preg_replace('/ *(?=[!&])/','', // delete blanks before ! or &
     strtr(trim($v),array('-'=>'&!','+'=>'&'))  // turn + and - into & and !&
     ));
}
print_r($a);

这将得到:

Array
(
    [0] => word1&word2
    [1] => word1&word2
    [2] => word1&!word2
    [3] => word1&!word2
    [4] => word1|word2
    [5] => word1|word2
)