我正在研究搜索引擎的发展。我有点在努力处理SQL / PHP请求。我正在尝试从搜索查询中获得最高的相关性得分。它可以完美地在SQL上运行,但不能在PHP上完全运行,无论是在localhost上还是在线运行(源代码均由phpmyadmin本身生成)。
$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;
显然,SQL连接有效,因为其他请求运行良好。任何想法 ?
来源= https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
您需要从资源获取结果$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);
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句