Skip to content
This repository has been archived by the owner on Jan 9, 2024. It is now read-only.

v5.1.0: Fix for fulltext w/where() not working

Latest
Compare
Choose a tag to compare
@msonowal msonowal released this 08 Dec 05:54
When using fulltext search + where() clause(s) in place even when I knew the combination should bring entries none was retrieved.

I found that the $params array get populated in the wrong order.

Eg;

select *, MATCH(name,email,data) AGAINST(? IN NATURAL LANGUAGE MODE) AS relevance from `users` where guid = ? AND MATCH(name,email,data) AGAINST(? IN BOOLEAN MODE)

array:2 [▼
  "guid" => "9260a604-22b6-4075-891e-a82d52ba69fe"
  0 => "text2search4"
]

after ksort($params,SORT_NATURAL); the $params lists gets;

array:2 [▼
  0 => "text2search4"
  "guid" => "9260a604-22b6-4075-891e-a82d52ba69fe"
]