[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">
<?php foreach($pagecont as $content_item):?>
<h4><?php echo $content_item['ros_sidecont_title']; ?></h4>
<p><?php echo $content_item['ros_sidecont_text']; ?></p>
<?php endforeach; ?>
</div>
<div id="sidebar">
<?php foreach($sidecont as $side_item):?>
<div class="sideitem">
<div class="sidetitle">
<h3><?php echo $side_item['ros_sidecont_title']; ?></h3>
</div>
<p><?php echo $side_item['ros_sidecont_text']; ?></p>
</div>
<?php endforeach; ?>
</div>
</div>