MatchAgainstBundle下载 - MatchAgainstBundle源代码下载

MatchAgainstBundle

其他源码

Very first release

下载

MATTAGAINSTBUNDLE

基于https://gist.github.com/zebigduck/1234419

安装

composer require ciricihq/match-against-bundle

用法

您必须加载提供的bundle config.yml才能拥有MATCH_AGAINST mysql句子

 imports :
    - { resource: ../../src/Cirici/MatchAgainstBundle/Resources/config/config.yml }

进行查询：

  $ qbuilder
      -> select ( ' sti.foreignId ' )
      -> from ( ' CiriciMatchAgainstBundleEntitySearchTextIndex ' , ' sti ' )
      -> where ( ' sti.model = :entityClass ' )
      -> andWhere ( ' sti.field = :fieldName ' )
      // ->andWhere("MATCH_AGAINST(sti.content, :text 'IN NATURAL LANGUAGE MODE') > :score")
      -> andWhere ( " MATCH_AGAINST(sti.content, :text 'IN BOOLEAN MODE') > :score " )
      -> setParameter ( ' entityClass ' , $ entity_class )
      -> setParameter ( ' fieldName ' , $ field_name )
      -> setParameter ( ' text ' , $ text )
      -> setParameter ( ' score ' , $ score )
  ;