Inserting Data From Database Into View - Codeigniter

Question

Okay, so I'm grabbing the data I need properly from the database. However, how do I take the "echo data" and echo it as a variable in my view?

For example,

<? echo $row1->title; ?>

is not working when placed in the view.

Here's a portion of my controller:

// Pricing and package details insert from db
    $query = $this -> db -> query('SELECT title, price, number_sites, number_entries, white_label FROM pricing');

    $row1 = $query->row(0); // 0 grabs first row in table: Package 1         

    echo $row1->title;
    echo $row1->price;
    echo $row1->number_sites;

If you want to view the entire controller, check it here: http://codepad.org/4nRrywzl

Kami · Accepted Answer · 2012-11-06 18:09:23Z

1

You need to pass through the data from the controller to the view.

Currently you are passing $data to the view, add another field in this array for the row.

$data['row1'] = $row1;
$this->load->view('shared/header_view', $data); // or any other view

and this should work in the view

echo $row1->$title;

Not tested the code above - but it should work.

answered Nov 6, 2012 at 18:09

Kami

19.5k4 gold badges53 silver badges65 bronze badges

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

9 Comments

Mike Barwick Over a year ago

Thanks! I tried that originally, but I get an error: "Message: Undefined variable: row1" and "Message: Trying to get property of non-object" in the view.

Kami Over a year ago

Remember to assign the variable to the array you are sending to the view

Kami Over a year ago

The error you received on your earlier attempt and quoted in your comment was likely to have been caused by the variable not being assigned to the $data array.

Mike Barwick Over a year ago

I did that...I had the $data assigned to the load->view from before... codepad.org/4nRrywzl

Will Sampson Over a year ago

you're wiping out the data array when you do $data = array(.... Try putting $data[row1] = $row1 after that statement. Also you should be making the database call in a model not in your controller. You can read about models here: codeigniter.com/user_guide/general/models.html

|

Collectives™ on Stack Overflow

Inserting Data From Database Into View - Codeigniter

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related