Codeigniter model foreach pass array to controller -> to view

Question

Here is my model - I want to assign the rows and echo out on the view page e.g <?php echo $product?>

class Model_products extends CI_Model {

    function printer()
    {

    $id = $this->uri->segment(3, 0);

        $q = $this->db->get_where('printer', array('id' => $id));

        if ($q->num_rows == 1)
        { 
            foreach ($q->result() as $row)
            {

                echo $row->name; # THIS WORKS
                $data['product'] = $row->name;  # THIS DOES NOT WORK
                $data['desc'] = $row->description;
                $data['size'] = $row->size;
                $data['options'] = $row->options;
                $data['more'] = $row->more_info;
            }
        }


    }
}

Here's my controller

public function products()
{

    $this->load->model('Model_products');

    $this->Model_products->printer();

    $this->load->view('products', $data);

    $this->load->view('pricing');
}

My view is

<h1>
<?php echo $product; ?>
</h1>

<p>
<?php echo $desc; ?>
</p>


<h3>
Size
</h3>
<p>
<?php echo $size; ?>
</p>

How do I properly pass my model array to my controller so that I can echo out on my view?

in controller,give $data = $this->Model_products->printer(); — Bhuvan Rikka
– Bhuvan Rikka, Commented Sep 27, 2012 at 6:24

Muhammad Raheel · Accepted Answer · 2012-09-27 08:15:14Z

Simply return $data to controller

class Model_products extends CI_Model {

    function printer()
    {
        $data   =   array();
        $id = $this->uri->segment(3, 0);

        $q = $this->db->get_where('printer', array('id' => $id));

        if ($q->num_rows == 1)
        { 
            foreach ($q->result() as $row)
            {

               // echo $row->name; # THIS WORKS
                $data['product'] = $row->name;  # THIS DOES NOT WORK
                $data['desc'] = $row->description;
                $data['size'] = $row->size;
                $data['options'] = $row->options;
                $data['more'] = $row->more_info;
            }
        }

    return $data;
    }
}

No win Controller

public function products()
{

    $this->load->model('Model_products');

    $data['products']   =   $this->Model_products->printer();

    $this->load->view('products', $data);

    $this->load->view('pricing');
}

And in view

<?   
   echo '<pre>';
   print_r($products);
?>

EDIT Also correct your model code.

        foreach ($q->result() as $row)
        {

            echo $row->name; # THIS WORKS
            $data[]['product'] = $row->name;  # THIS DOES NOT WORK
            $data[]['desc'] = $row->description;
            $data[]['size'] = $row->size;
            $data[]['options'] = $row->options;
            $data[]['more'] = $row->more_info;
        }

If you are not using multidimensional array it will overwrite the last record.

Fad · Accepted Answer · 2012-09-27 06:23:54Z

0

You need to return the data from the model back to the controller and then from there, pass the data to the view.

In your model function, place a return statement at the end.

return $data;

Then in your controller, assign the returned value from the model to a variable.

$data = $this->Model_products->printer();

Those 2 steps should fix your problem.

answered Sep 27, 2012 at 6:23

Fad

9,8683 gold badges48 silver badges65 bronze badges

Comments

Muhammad Raheel · Accepted Answer · 2012-09-27 08:15:00Z

0

Where your return statement

if ($q->num_rows == 1)
    { 
        foreach ($q->result() as $row)
        {

            echo $row->name; # THIS WORKS
            $data['product'] = $row->name;  # THIS DOES NOT WORK
            $data['desc'] = $row->description;
            $data['size'] = $row->size;
            $data['options'] = $row->options;
            $data['more'] = $row->more_info;
        }
        return $data;
    }

and/or in your controller

public function products()
{ 
   $this->load->model('Model_products');
   $data = $this->Model_products->printer();
   $this->load->view('products', $data);
   $this->load->view('pricing');
}

edited Sep 27, 2012 at 8:15

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

answered Sep 27, 2012 at 6:22

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

Comments

muttalebm · Accepted Answer · 2013-04-05 18:40:41Z

0

I used @raheel's code and it works. But I would just change a bit:

   $i=0;
   foreach ($q->result() as $row)
        {


            echo $row->name; # THIS WORKS
            $data[$i]['product'] = $row->name;  # THIS DOES NOT WORK
            $data[$i]['desc'] = $row->description;
            $data[$i]['size'] = $row->size;
            $data[$i]['options'] = $row->options;
            $data[$i]['more'] = $row->more_info;
        }

This will help extracting the data

answered Apr 5, 2013 at 18:40

muttalebm

5521 gold badge6 silver badges22 bronze badges

Collectives™ on Stack Overflow

Codeigniter model foreach pass array to controller -> to view

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related