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

Question

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) ');

Answer 1

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