How to use results from models directly inside a controller in Codeigniter?

Question

I have created this following model (see below). I have managed to fetch data from my database and send generated result to the view by creating a variable called $data['get_company']. However, I can't figure out how I can use these results from the model in my Controller without using a foreach loop.

Model

class Company_model extends CI_Model
{
    public function fetch_company($id = NULL) {

        $this->db->select('*');
        $this->db->where('customer_company_profiles_id', $id);
        $this->db->from('customer_company_profiles');
        $this->db->order_by('customer_company_profiles_id', 'desc');
        $this->db->limit(1);
        $query = $this->db->get();
        if($query->num_rows() == NULL)
        {
            return false;
        }
        else
        {
            return $query->result();
        }

    }

}

Controller

public function index($id = NULL)
{
    $id = $this->input->get('id'); 
    $data['get_company'] = $this->Company_model->fetch_company($id);
    $this->load->view('includes/header');
    $this->load->view('company/company_index', $data);
    $this->load->view('includes/footer');
}

Is there a function like $something_something->get_company->get_this_row('ID') so that I can avoid using foreach loops inside a controller and how do I proceed?

Take the time to do the "news" tutorial in the official documentation. This is pretty comprehensive and clearly explains this exact scenario. — Sparky
– Sparky, Commented Feb 11, 2016 at 22:53

GluePear · Accepted Answer · 2016-02-11 22:50:32Z

2

Instead of return $query->result(), use return $query->row() in your model. This will return a single row which you can access normally, instead of having to first reference an array.

E.g. in your view you could then do:

echo $get_company->title;

Relevant section in CI manual.

answered Feb 11, 2016 at 22:50

GluePear

7,77321 gold badges73 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

kanarifugl Over a year ago

Thank you, just what I'm looking for.

kanarifugl Over a year ago

Do I need to create a second model if i also want to pass this data to my view, since I can't use $data['get_company'] when returning $query->row()?

GluePear Over a year ago

Not sure I understand your question. You can use $data['get_company'] when returning $query->row().

Collectives™ on Stack Overflow

How to use results from models directly inside a controller in Codeigniter?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related