SphinxAPI SetFilter false

发布于 2024-11-02 04:46:19 字数 908 浏览 0 评论 0原文

我为我的搜索引擎安装了 sphinx，它工作得很好，但现在我尝试使用 setFilter() 向搜索添加一些额外的功能，这应该允许我执行 WHERE/AND 子句，但每当我尝试搜索时，它应该返回结果但没有返回结果。

这是我的 MySQL 代码：http://pastebin.com/gFrvKumW

这是我的 sphinx.conf：http://pastebin.com/XdppZ0MG

而我的 PHP 代码：

<?php
    require("sphinxapi.php");
    $cl = new SphinxClient();
    $host = "localhost";
    $port = 9312;
    $index = "library";
    $q = "livres";
    $limit = 20;
    $ranker = SPH_RANK_PROXIMITY_BM25;
    $mode = SPH_MATCH_ALL;
    $cl->SetServer($host, $port);
    $cl->SetConnectTimeout(0);
    $cl->SetMatchMode($mode);
    $cl->SetRankingMode($ranker);
    //$cl->SetFilter('author_id', array(1));
    $res = $cl->Query($q, $index);
    die(var_dump($res));
?>

如果添加注释行就不再工作了。我不明白为什么

原文

I have sphinx installed for my search engine, and it works great, but now I'm trying to add a few extra features to the search using setFilter() which should allow me to do WHERE/AND clauses, but whenever I try a search, it returns no results when there should.

This is my MySQL Code : http://pastebin.com/gFrvKumW

This is my sphinx.conf : http://pastebin.com/XdppZ0MG

And my PHP code :

<?php
    require("sphinxapi.php");
    $cl = new SphinxClient();
    $host = "localhost";
    $port = 9312;
    $index = "library";
    $q = "livres";
    $limit = 20;
    $ranker = SPH_RANK_PROXIMITY_BM25;
    $mode = SPH_MATCH_ALL;
    $cl->SetServer($host, $port);
    $cl->SetConnectTimeout(0);
    $cl->SetMatchMode($mode);
    $cl->SetRankingMode($ranker);
    //$cl->SetFilter('author_id', array(1));
    $res = $cl->Query($q, $index);
    die(var_dump($res));
?>

if you add the commented line is not working anymore.
I do not understand why

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

烟花肆意 2024-11-09 04:46:19

如果您希望能够使用字段作为过滤器，则需要将其添加到 sphinx 配置文件所以如果你想按作者id过滤，你需要添加（假设作者的id是整数）：

sql_query = SELECT `autors`.id, `books`.id, `books`.author_id, `books`.title, `books`.type, `authors`.name FROM `books`, `authors` WHERE `books`.author_id = `authors`.id
sql_attr_uint = autor_id

我希望这有帮助，祝你好运

if you want to be able to use a field as a filter, you'll need to add it in the sql_attr on your sphinx config file so if you want to filter by autor id, you'll need to add (assuming that the author's id is an integer):

sql_query = SELECT `autors`.id, `books`.id, `books`.author_id, `books`.title, `books`.type, `authors`.name FROM `books`, `authors` WHERE `books`.author_id = `authors`.id
sql_attr_uint = autor_id

i hope this helps, Good Luck

回复收藏 0 原文

~没有更多了~