rpsl/sphinxql

Simple library for work with SphinxQL Api ( uses mysqli php extension )

v1.0.3 2014-07-15 13:16 UTC

Requires

• php: >=5.3.0

Apache-2.0

• Rpsl

• database
• sql
• search
• mysql
• sphinx
• sphinxql

README

Simple library for work with SphinxQL Api ( uses mysqli php extension )

See SphinxQL specification

Example:

$sphinxql = new SphinxQL();
$query = $sphinxql->newQuery();
$query
    ->addIndex('my_index')
    ->addField('field_name', 'alias')
    ->addField('another_field')

    ->addFields(
        array(
            array('field' => 'title', 'alias' => 'title_alias'),
            array('field' => 'user_id')
        )
    )

    ->search('some words to search for')

    // string (is given directly to sphinx, so can contain @field directives)
    ->where('time', time()-3600, '>', FALSE)


    // field, value, operator='=', quote=TRUE
    ->whereIn('tags_i_need', array(1, 2, 3), 'all')
    ->whereIn('tags_i_do_not_want', array(4, 5, 6), 'none')
    
    // field, array values, type='any'
    ->whereIn('tags_i_would_like_one_of', array(7, 8, 9), 'any')


    // field, sort='desc'
    ->order('@weight', 'desc')

    // defaults are 0 and 20, same as the sphinx defaults
    ->offset(10)->limit(50)

    // option name, option value
    ->option('max_query_time', '100')

    ->groupBy('field')
    
    // sphinx-specific, check their docs
    ->in_group_order_by('another_field', 'desc');

$result = $query->execute();


// get stats
$stats = $sphinx->stats();

Example with RT Index:

$sphinxql = new SphinxQL();

$result = $sphinxql->query('
    INSERT INTO realtime_index
        (id, title, content)
    VALUES
        ( 1, "title news", "content news" )
    '
);

Install with composer:

{
    "require": {
        "rpsl/sphinxql": ">=1"
    }
}