MeNeedz Search

[eluser]davidbehler[/eluser]
Sorry for the late reply but this should answer your questions:

hugle
The model from the example looks like this:

Code:

<?php
class Search_model extends Model {
    function Search_model()
    {
        // Call the Model constructor
        parent::Model();
    }

    function get_article_list($id_list = array(), $order_by = array())
    {
        $this->db->from('articles');
        if(count($id_list) > 0)
        {
            $this->db->where_in('id', $id_list);
        }
        if(count($order_by) > 0)
        {
            foreach($order_by as $key => $value)
            {
                $this->db->order_by($key, $value);
            }
        }
        $result = $this->db->get();
        if($result->num_rows() > 0)
        {
            $rows = $result->result_array();
            return $rows;
        }
        else
        {
            return array();
        }
    }
}
?>

The articles table I used was taken from some MySQL example I found some time ago. If you want me to I can look for the CREATE statement and post it here, but it's really nothing special about it.
The pagination is all done in the library, have a look a the "scroll" method.

zvir
This is an example config I set up some time back:

Code:

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
    $config['max_age'] = 20; //in seconds
    $config['db_config'] = array(
        'table' => 'search',
        'id_column' => 'search_id',
        'hash_column' => 'search_hash',
        'name_column' => 'search_name',
        'perform_column' => 'search_date_perform',
        'count_column' => 'search_result_count',
        'where_column' => 'search_where',
        'result_column' => 'search_result',
        'order_column' => 'search_order_by'
    );
    $config['search_config'] = array(
        'test_search' => array(
            'search_id_field' => 'user_id',
            'search_from' => "user",
            'search_join' => array(
                'user_group' => 'user.user_group = user_group.group_id'
            ),
            'search_default_where' => "is_active = 1",
            'search_post_where' => array(
                array(
                        'post_field' => 'username',
                        'db_column' => 'user_name',
                        'operator' => 'MATCH',
                        'mode' => 'IN BOOLEAN MODE'
                    ),
                array(
                        'post_field' => 'min_age',
                        'db_column' => 'age',
                        'operator' => '>'
                    )
            ),
            'search_post_order' => array(
                'db_column_post_field' => 'column_field',
                'order_post_field' => 'order_field'
            )
        ),
        'example_1' => array(
            'search_id_field' => 'id',
            'search_from' => "articles",
            'search_join' => array(),
            'search_default_where' => "",
            'search_post_where' => array(
                array(
                        'post_field' => 'search_term_example_1',
                        'db_column' => 'body',
                        'operator' => 'LIKE'
                    )
            ),
            'search_post_order' => array()
        ),
        'example_2' => array(
            'search_id_field' => 'id',
            'search_from' => "articles",
            'search_join' => array(),
            'search_default_where' => "",
            'search_post_where' => array(
                array(
                        'post_field' => 'min_id',
                        'db_column' => 'id',
                        'operator' => '>'
                    ),
                array(
                        'post_field' => 'max_id',
                        'db_column' => 'id',
                        'operator' => '<'
                    )
            ),
            'search_post_order' => array(
                'db_column_post_field' => 'column_field',
                'order_post_field' => 'order_field'
            )
        )
    );
?&gt;

test_search and example_2 both search in multiple columns. Depending on wether you want to use one post value to search for in multiple columns or multiple post values to search for in one column or whatever else you want to do, you have to adjust the "search_post_where" config value. If you run into any problems with this, feel free to post more info on what you are doing and I'll try to help you setup the config right.

Hope I could help.