Codeigniter Printing Query Results

Question

Simple question but I don't know why it is not printing correctly or working as expected. I have this in model (works because when I print_r($result) it shows data:

function get_latest_entries()
{
    $query = $this->db->get('property');
    return $query->result_array();
}

And for controller:

public function index()
{
    $resultSet['properties'] = $this->propertymodel->get_latest_entries();
    $this->load->view('home', $resultSet);
}

In the view I want to iterate over the array (the table has description, city, address columns):

<?php
foreach($resultSet as $item)
{
    echo $item->city;
    echo $item->description;
}
?>

I am getting two records on home page where am displaying the results as above:

Severity: Notice Message: Undefined variable: resultSet Filename: views/home.php Line Number: 16

And

Severity: Warning Message: Invalid argument supplied for foreach() Filename: views/home.php Line Number: 16

put it as an answer @ShayanHusaini so I can mark it as one :) — sys_debug
– sys_debug, Commented Nov 8, 2012 at 6:36

Code Prank · Accepted Answer · 2012-11-08 06:36:56Z

3

use $properties instead of $resultSet

answered Nov 8, 2012 at 6:36

Code Prank

4,2706 gold badges35 silver badges48 bronze badges

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

Comments

bipen · Accepted Answer · 2012-11-08 06:36:40Z

2

use this... you are passing $properties to your view and not $resultSet..

<?php
       foreach($properties as $item) // use properties
       {
        echo $item->city;
        echo $item->description;
       }
    ?>

answered Nov 8, 2012 at 6:36

bipen

36.6k9 gold badges51 silver badges62 bronze badges

Comments

Muhammad Sadiq · Accepted Answer · 2015-08-01 10:20:03Z

0

Here is the problem in your code. -you have returned data as array of arrays and you are trying to access as an object, -and the second one is,you have passed properties variable to view and you are accessing resultSet. -so here is your code in view which contains errors

<?php
foreach($resultSet as $item)
{
    echo $item->city;
    echo $item->description;
}
?>

-And the Correct version of your code is here...

<?php
foreach($properties as $item)
{
    echo $item['city'];
    echo $item['description'];
}
?>

answered Aug 1, 2015 at 10:20

Muhammad Sadiq

1,16511 silver badges14 bronze badges

Collectives™ on Stack Overflow

Codeigniter Printing Query Results

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related