New CI User - need assistance with Model issue please.

Code:

&lt;?php



class Site extends CI_Controller

{

    function index()

    {

        $this->load->database();

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

        $data['records'] = $this->site_model->getAll();

        

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

    }

}

Code:

&lt;?php



class Site_model extends CI_Model

{

    function getAll()

    {

        $this->CI = get_instance();

        

        $this->CI->load->database();

        $q = $this->CI->db->get('test');

        

        if($q->num_rows() > 0)

        {

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

            {

                $data[] = $row;

            }

            

            return $data;

        }

    }

}

Code:

<p>My view has been loaded</p>

<pre>&lt;?php print_r($records); ?&gt;</pre>

Code:

&lt;?php



class Site_model extends CI_Model

{

    function getAll()

    {

        //$this->CI = get_instance();

        

        // $this->CI->load->database(); you do not need this here your loading the database in your controller

        $q = $this->db->get('test');

        

        if($q->num_rows() > 0)

        {

            // should be $q->result_array()

            foreach($q->result_array() as $row)

            {

                $data[] = $row;

            }

            

            return $data;

        }

    }

}

Code:

&lt;?php



class Site_model extends CI_Model

{

    function getAll()

    {

        //$this->CI = get_instance();

        

        // $this->CI->load->database(); you do not need this here your loading the database in your controller

        $q = $this->db->get('test');

        

        if($q->num_rows() > 0)

        {

            // should be $q->result_array()

            foreach($q->result_array() as $row)

            {

                $data[] = $row;

            }

            

            return $data;

        }

    }

}

Code:

&lt;?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');



class Site extends CI_Controller {



    // Class Variables.

    // --------------------------------------------------------------------





    // --------------------------------------------------------------------



    /**

     * __construct()

     *

     * PHP 5+    Constructor

     *

     * You do not really need this unless you setting up stuff!

     *

     * @access    public

     * @return    void

     */

    public function __construct()

    {

        parent::__construct();

    }



    // --------------------------------------------------------------------



    /**

     * index()

     *

     * Default Controller index method.

     *

     * @access    public

     * @return    void

     */

    public function index()

    {

        $this->load->database();

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



        $data['records'] = $this->site_model->get_all();



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

    }



}



// ------------------------------------------------------------------------

/* End of file name.php */

/* Location: ./application/controllers/site.php */

Code:

&lt;?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');



class Site_model extends CI_Model {



    // --------------------------------------------------------------------



    /**

     * Class Variables.

     *

     * protected, private, public and static variables.

     * --------------------------------------------------------------------

     */



    private $CI;





    // --------------------------------------------------------------------



    /**

     * __construct()

     *

     * PHP 5+    Constructor.

     *

     * You do not really need this unless you setting up stuff!

     *

     * @access    public

     * @return    void

     */

    public function __construct()

    {

        parent::__construct();



        // Get the CI Super Global Object to a local variable for use later.

        $this->CI =& get_instance();



    }



    public function get_all()

    {

        $query = $this->db->get('posts');    // change to your test!



        if ($query->num_rows() > 0)

        {

            foreach ($query->result_array() as $row)

            {

                $data[] = $row;

            }



            return $data;

        }

    }

}



// ------------------------------------------------------------------------

/* End of file Site_model.php */

/* Location: ./application/models/site_model.php */

Code:

<!DOCTYPE html>

&lt;html lang="en"&gt;

&lt;head&gt;

    &lt;meta charset="utf-8"&gt;

    &lt;title&gt;Welcome to CodeIgniter&lt;/title&gt;



&lt;style type="text/css"&gt;



body {

 background-color: #fff;

 margin: 40px;

 font-family: Lucida Grande, Verdana, Sans-serif;

 font-size: 14px;

 color: #4F5155;

}



a {

 color: #003399;

 background-color: transparent;

 font-weight: normal;

}



h1 {

 color: #444;

 background-color: transparent;

 border-bottom: 1px solid #D0D0D0;

 font-size: 16px;

 font-weight: bold;

 margin: 24px 0 2px 0;

 padding: 5px 0 6px 0;

}



code {

 font-family: Monaco, Verdana, Sans-serif;

 font-size: 12px;

 background-color: #f9f9f9;

 border: 1px solid #D0D0D0;

 color: #002166;

 display: block;

 margin: 14px 0 14px 0;

 padding: 12px 10px 12px 10px;

}



&lt;/style&gt;

&lt;/head&gt;

&lt;body&gt;



<h1>Welcome to CodeIgniter!</h1>



<p>The page you are looking at is being generated dynamically by CodeIgniter.</p>



<p>If you would like to edit this page you'll find it located at:</p>

<code>application/views/welcome_message.php</code>



<p>The corresponding controller for this page is found at:</p>

<code>application/controllers/welcome.php</code>



<p>If you are exploring CodeIgniter for the very first time, you should start by reading the <a href="user_guide/">User Guide</a>.</p>



<p>My view has been loaded</p>

<pre>&lt;?php print_r($records); ?&gt;</pre>



<p>&lt;?php echo 'CodeIgniter Reactor ver: '.CI_VERSION;?&gt;</p>



<p>Page rendered in {elapsed_time} seconds</p>

<p>Memory Usage: {memory_usage}</p>



&lt;/body&gt;

&lt;/html&gt;