Welcome Guest, Not a member yet? Register   Sign In
Having little trouble getting data from database
#1

[eluser]faxtion[/eluser]
Got the following code but does not display anything in view, neither does it give me and error, any help appreciated

Code:
Controller

class Parts extends Controller {

    function index() {
        echo 'Hello World!';
    }
    
    function view() {
        $this->load->model('Parts_model');
        $data['parts'] = $this->Parts_model->get_parts();
        $this->load->view('parts_view', $data);
    }
}
?>

Code:
Model

<?php
class Parts_model extends Model {
    
    function Parts_model()
    {
        // Call the Model constructor
        parent::Model();
    }

    function get_parts() {
        //$query = $this->db->query('SELECT title FROM parts');
        $query = $this->db->get('parts', 10);
        return $query->result();
    }

}
?>


Code:
View


<html>
<head>
<title>Rally Parts Auction</title>
</head>
<body>
<h3>Parts</h3>  

<ul>
&lt;?php foreach($parts as $part):?&gt;

<h4>&lt;?=$part['postid']?&gt;</h4>
<p>&lt;?=$part['title']?&gt;</p>
<p>&lt;?=$part['description']?&gt;</p>
<p>&lt;?=$part['category']?&gt;</p>
<p>&lt;?=$part['image']?&gt;</p>
<p>&lt;?=$part['image1']?&gt;</p>
<p>&lt;?=$part['image2']?&gt;</p>

&lt;?php endforeach;?&gt;
</ul>

&lt;/body&gt;
&lt;/html&gt;


Messages In This Thread
Having little trouble getting data from database - by El Forum - 10-26-2008, 05:34 AM
Having little trouble getting data from database - by El Forum - 10-26-2008, 06:34 AM
Having little trouble getting data from database - by El Forum - 10-26-2008, 09:20 AM
Having little trouble getting data from database - by El Forum - 10-26-2008, 09:33 AM
Having little trouble getting data from database - by El Forum - 10-26-2008, 09:54 AM



Theme © iAndrew 2016 - Forum software by © MyBB