FuelPHP Forums

Hi everyone,

I've created a view with pagination, table sort and search
capabilities.
Everything goes well, until I need too return the data
from the search, back to the view.
I have a problem with passing the result to a view.

First, here is the index method.

<code>
public function action_index()
    {
        $search = '';
        if (Input::method() == 'POST')
        {
            $search = Input::post('search');
            Session::set('search', $search);
        }

        $query = Model_Recipient::find();
        $number_of_recipients = $query->count();

        $per_page=Input::post('perpage', Session::get('perpage_recipients',10) );
        Session::set('perpage_recipients', $per_page);

        $config = array(
            'pagination_url' => 'admin/recipients/index/',
           ....etc.......  );

        Pagination::set_config($config);

        $config_table = array(
            'sort_by'        => 'id',
            'direction'        => 'asc',
             ...etc........ )

        \TableSort\TableSort::set_config($config_table);

        $sort_by    = \TableSort\TableSort::$sort_by;
        $sort_dir     = \TableSort\TableSort::$direction;

        $query = Model_Recipient::find()->order_by($sort_by, $sort_dir);

        if($search)
        {
            $data['recipients']    = DB::select()->from('recipients')
                                        ->or_where_open()
                                            ->where('vorname', 'like', "%".$search."%")
                                            ->or_where('nachname', 'like', "%".$search."%")
                                            ->or_where('email', 'like', "%".$search."%")
                                        ->or_where_close()
                                        ->order_by($sort_by, $sort_dir)
                                        ->limit(Pagination::$per_page)
                                        ->offset(Pagination::$offset)
                                        ->as_object('Model_Recipients')
                                        ->execute();

            //echo "<pre>"; print_r($data['recipients']); echo "</pre>";exit;
        }
        else
        {
            $data['recipients'] = $query->limit(Pagination::$per_page)->offset(Pagination::$offset)->get();
        }

        $data['pagination'] = Pagination::create_links();
        $data['table_head'] = \TableSort\TableSort::create_table_head();

        $this->template->title = __("app.Recipients");
        $this->template->per_page = $per_page;
        $this->template->content = View::forge('admin/recipients/index', $data);
    }
</code>

When I search for something, I receive this error :

Fuel\Core\FuelException [ Error ]: Database results are read-only

COREPATH/classes/database/result.php @ line 266

 266        throw new \FuelException('Database results are read-only');

What I am doing wrong ? How can I pass the result to the view ?

When
I'm doing a print_r to the result in the controller, everything is
there, so there is no problem with the way I use the DB class.

Thanks,
Gabriel