public function action_test($page = 1) { $page = $page <= 0 ? 1 : $page; $search = Sphinx::factory(Sprig::factory('actor')); $search->limit = 10; $search->offset = $search->limit * ($page - 1); $search->order_by('sort_fname'); $result = $search->results; ?> <h2>Sorted by first name</h2> <h3><?php echo $search->offset + 1, ' - ', $search->offset + 10; ?> results. Of <?php echo $search->total; ?> </h3> <a href="<?php echo URL::site('sphinxexample/test/' . ($page - 1)); ?> ">Prev</a> | <a href="<?php echo URL::site('sphinxexample/test/' . ($page + 1)); ?> ">Next</a> <br/> <table width="500"> <tr> <th>docid</th> <th>Films</th> <th>First Name</th> <th>Last Name</th> </tr> <?php foreach ($search as $i => $actor) { ?> <tr> <td><?php echo $actor->actor_id; ?> </td> <td> <?php echo $search->attr($actor->actor_id, 'films'); ?> </td> <td> <?php echo $actor->first_name; ?> </td> <td> <?php echo $actor->last_name; ?> </td> </tr> <?php } ?> </table> <?php if (!$result) { echo Kohana::debug($search->last_error); } else { echo Kohana::debug($result); } }