Retrieve data from database in codeigniter

Question

I am new to Codeigniter so I'm having some difficulties I want to retrieve data from the database and load it in the view but I couldn't figure out how. Here is my model:

public function viewClientWaterwell(){
    $userid = get_client()->userid;
    $waterwells = $this->db->select('*')
        ->from($this->table)
        ->where('ww_client_id', $userid)
        ->get()->result_array();
    return $waterwells;
}

Here is my clientController:

    public function viewClient()
{
    $data['waterwells'] = $this->waterwell_model->viewClientWaterwell();
    $this->data($data);
    $this->view('waterwells/clients/viewClient');
    $this->layout();
}

I want to pass some data in a view to the client side but I can't figure out how. I think there is some problem with my model but I cannot figure out what. I'm new to this and will appreciate your feedback. Thanks!

Akshay Hegde · Accepted Answer · 2021-10-29 18:21:03Z

1

You just need to use second argument to pass data to your template or view file

Here is example to start

Inside your controller function

public function viewClient()
{
   $data = array( 'myvar' => 'I love stackoverflow' );
   $this->load->view('waterwells/clients/viewClient', $data);
}

And inside your template or view file you can access them by their name.

<?php echo $myvar; ?>

answered Oct 29, 2021 at 18:21

Akshay Hegde

17.1k2 gold badges25 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Retrieve data from database in codeigniter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related