…dled (to work around sphinx bug #551)
|Failed to load latest commit information.|
|classes||added some more query functions, changed how the IN() clauses are han…|
|docs||added some more query functions, changed how the IN() clauses are han…|
|README||added some more query functions, changed how the IN() clauses are han…|
SphinxQL for Kohana =================== Overview -------- 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 here: http://sphinxsearch.com/blog/2010/04/25/sphinxapi-vs-sphinxql-benchmark/ Requirements ------------ Sphinx >= 0.9.9-rc2 PHP MySQL client library (php5-mysql in debian) Installation ------------ 1. `git submodule add git://github.com/MasterCJ/kohana-sphinxql.git modules/sphinxql` 2. Enable sphinxql in your bootstrap file 3. Use the SphinxQL class in your models Usage ----- $sphinxql = new SphinxQL(); $query = $sphinxql->new_query(); $query->add_index('my_index') ->add_field('field_name', 'alias') ->add_field('another_field') ->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' ->offset(10)->limit(50) // defaults are 0 and 20, same as the sphinx defaults ->option('max_query_time', '100') // option name, option value ->group_by('field') ->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 firstname.lastname@example.org or file a bug report.