Welcome Guest, Not a member yet? Register   Sign In
Model Error
#1

[eluser]georgerobbo[/eluser]
I have a model which pulls content from a MySQL database. When I use the query in my controller it works fine, however I am having difficulties in the model. The error being returned is:

Quote:A PHP Error was encountered
Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: views/content.php

Line Number: 13

This is my code:

Code:
<?php

class Welcome extends Controller {

    function Welcome()
    {
        parent::Controller();
    }
    
     function index()
    {
        $data['title'] = 'Home';
        
        $this->load->model('Ros_sidecont');
        $data['sidecont'] = $this->Ros_sidecont->get_sidecont();
                
        $this->load->view('meta', $data);
        $this->load->view('header');
        $this->load->view('panel');
        $this->load->view('content', $data);
        $this->load->view('footer');    
   }
}
?>

Code:
<?php

class Ros_sidecont extends Model {

    function Ros_sidecont()
    {
        parent::Model();
    }
    
    function get_sidecont()
    {    
        $query = $this->db->query('SELECT ros_sidecont_title, ros_sidecont_text FROM ros_sidecont');
        $data['sidecont'] = array();
        foreach($query->result_array() as $row)
        {
            $data['sidecont'][] = $row;
        }
    }
}

Code:
<div id="content">
        
        &lt;?php foreach($pagecont as $content_item):?&gt;
        <h4>&lt;?php echo $content_item['ros_sidecont_title']; ?&gt;</h4>
        <p>&lt;?php echo $content_item['ros_sidecont_text']; ?&gt;</p>
        &lt;?php endforeach; ?&gt;

    </div>
    
    <div id="sidebar">

        &lt;?php foreach($sidecont as $side_item):?&gt;
        <div class="sideitem">
            <div class="sidetitle">
                <h3>&lt;?php echo $side_item['ros_sidecont_title']; ?&gt;</h3>
            </div>
                <p>&lt;?php echo $side_item['ros_sidecont_text']; ?&gt;</p>
        </div>
        &lt;?php endforeach; ?&gt;
          
    </div>
        
    </div>


Messages In This Thread
Model Error - by El Forum - 08-11-2009, 04:08 AM
Model Error - by El Forum - 08-11-2009, 04:36 AM
Model Error - by El Forum - 08-11-2009, 04:45 AM
Model Error - by El Forum - 08-11-2009, 04:48 AM
Model Error - by El Forum - 08-11-2009, 04:52 AM
Model Error - by El Forum - 08-11-2009, 08:57 AM



Theme © iAndrew 2016 - Forum software by © MyBB