doudi5291 2015-05-12 06:52
浏览 124
已采纳

如何用php pdo进行全文搜索?

So I'm having trouble with my current search for a website. So my current search will achieve this; user inputs "crik" and it will return "cricket" for a search. However if a user inputs "crickets" it wont return "cricket" for a search. How do I get this to work? my current php code is;

      $searchQ = $_GET['search'];  
      $ssss = $pdo->prepare('SELECT * FROM listing WHERE name LIKE :search');                                    
      $ssss->bindValue(':search', "%" . $searchQ . "%");        
      $ssss->execute();

I've also tried this but it didnt return anything;

$ssss = $pdo->prepare('SELECT  * FROM listing WHERE MATCH(name) AGAINST (:search IN BOOLEAN MODE) ');
  • 写回答

2条回答 默认 最新

  • dtx9931 2015-05-12 07:24
    关注

    You can change the search string

    $searchQ = $_GET['search'];
    $searchArr = str_split($searchQ );
    $searchQ_new = "";
    foreach($searchArr as $alpha)
    {
            $searchQ_new .= $alpha . "%";
    }
    

    Now you can use your code to search with $searchQ_new

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?