You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Alexander Yakovlev 765dc03b58 Kohana code style and check for connection 8 years ago
classes Kohana code style and check for connection 8 years ago
config Commented example server in config 8 years ago
docs New version of kohana sphinxql from working project 9 years ago
LICENSE first commit 11 years ago
README Changed READ ME file 8 years ago


SphinxQL for Kohana v3.3 (update)


I wrote this because the other Kohana Sphinx plugin on github was reliant on
the pure PHP sphinx API and was discontinued. This plugin, as suggested by its
name, uses the SphinxQL interface. This means there's less dependancies as it
uses the built-in MySQL interface from PHP. _NOTE_: to use this, MySQL server
does _NOT_ need to be installed on the server. Only the MySQL client library for
PHP is required. As the MySQL interface in PHP is built as an extension, it's
faster than the regular Sphinx API as well, you can check the benchmarks out


Sphinx >= 0.9.9-rc2
PHP MySQL client library (php5-mysql in debian)


1. `git submodule add git:// modules/sphinxql`
2. Enable sphinxql in your bootstrap file
3. Use the SphinxQL class in your models


$sphinxql = new SphinxQL();
$query = $sphinxql->new_query();
->add_field('field_name', 'alias')
->add_fields(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
->where_in('tags_i_need', array(1, 2, 3), 'all')
->where_in('tags_i_do_not_want', array(4, 5, 6), 'none')
->where_in('tags_i_would_like_one_of', array(7, 8, 9), 'any')
// field, array values, type='any'
->order('@weight', 'desc')
// field, sort='desc'
// defaults are 0 and 20, same as the sphinx defaults
->option('max_query_time', '100')
// option name, option value
->in_group_order_by('another_field', 'desc');
// sphinx-specific, check their docs
$result = $query->execute();

All the methods in SphinxQL_Query are chainable apart from execute(), so
technically this works fine (ugly as it is):

$result = $sphinxql->new_query()->add_index('news')->order('time', 'desc')->execute();

Note that as with any Sphinx application, you'd need to then go and fetch the
actual data from a datastore somewhere using the IDs you just recieved.

u mad?

All the classes are documented, so there shouldn't be too much confusion. If
you do have questions, concerns, pent up rage, panties or all of the above,
drop me a line at or file a bug report.