DataMapper ORM v1.8.1 - Printable Version

Code:

function user_manager($page = 1, $sort_by = 'username', $sort_order = 'asc')

    {

        //get all users in paged format

        $users = new User();

        $users->where('user_status !=', 'deleted');

        $users->order_by($sort_by, $sort_order);

        

        //get user types

        $user_type = new User_type();

        $user_type->get();

        

        $users->user_type->get();

       

        

        //if there is no pagesize variable in the session set to 5

        if(!$this->session->userdata('pagesize'))

        {

            $page_size = 5;

            $this->session->set_userdata('pagesize', $page_size);

        }

        //if the post value is sent from the number of rows selectbox 

        //make the paze size equal to that value

        if($this->input->post('sel'))

        {

            $page_size = $this->input->post('sel');

            $this->session->set_userdata('pagesize', $page_size);

        }

        

        //Sets the page we are on and number of rows in each page

        $users->get_paged($page, $this->session->userdata('pagesize'));

               

        $data['users'] = $users;

        $data['user_type'] = $user_type;

        $data['page'] = 'user_manager';

        $data['sort_by'] = $sort_by;

        $data['sort_order'] = $sort_order;

        $data['page_sub'] = 'view_all_users';

        $data['main_content'] = 'admin/view_all_users';

        $this->load->view('admin/template', $data);  

    }

Code:

array (

    'service' => 

        array (

            'id' => 1,

            'title' => 'Parent Service',

            'url' => 'parent_service',

        ),

            'related_services' => 

                array (

                    0 => 

                        array (

                        'service_id' => 2,

                        'service_title' => Test2,

                        'service_url' => test2,

                        ),

                    1 => 

                        array (

                        'service_id' => 3,

                        'service_title' => Test3,

                        'service_url' => test3,

                        ),

)

Code:

Services

id   url                      title

1    parent_service    Parent service

2    test2                  Test2

3    test3                  Test3

Code:

Related_services_services

id service_id related_service_id

2  2              1

3  3              1

Code:

$users->user_type->get();

Code:

// create the service object

$service = new Service();



// enable auto population for has_one and has_many relations

$service->auto_populate_has_one = true;

$service->auto_populate_has_many = true;



// get all services and all related objects

$service->get();



// now you can iterate

foreach ( $service as $s )

{

    echo $s->title;



    foreach ($s->related_service as $r)

    {

        echo "related: ", $r->title;

    }

}