i’m working on search engine developement. I’m kinda struggling with an SQL/PHP request. I’m trying to get the highest relevancy score from a search query. It works perfectly on SQL, but not at all on PHP, neither on localhost nor online (while the source code is generated by phpmyadmin itself).
x
$connect = mysqli_connect('a', 'b','c','d');
$sql1 = "SELECT job, MATCH (job) AGAINST ('sales representative' IN BOOLEAN MODE) AS score FROM general_comp ORDER BY score DESC limit 1";
$result = mysqli_query($connect, $sql1);
echo $result;
Obviously SQL connection works, since other requests are working very well. Any idea ?
Source = https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
Advertisement
Answer
You need to fetch the results from the resource $result
:
$connect = mysqli_connect('a', 'b','c','d');
$sql1 = "SELECT job, MATCH (job) AGAINST ('sales representative' IN BOOLEAN MODE) AS score FROM general_comp ORDER BY score DESC limit 1";
$result = mysqli_query($connect, $sql1);
$row = mysqli_fetch_assoc($result);
print_r($row);