Login

01-21-2009, 10:07 PM

[eluser]plasmagames[/eluser]
controller

Code:
&lt;?php

class Psg extends Controller {

    function Psg()

    {

        parent::Controller();

            $config['hostname'] = "localhost";

            $config['username'] = "dbusername";

            $config['password'] = "";

            $config['database'] = "dbdatabase";

            $config['dbdriver'] = "mysql";

            $config['dbprefix'] = "";

            $config['pconnect'] = FALSE;

            $config['db_debug'] = TRUE;

            $config['cache_on'] = FALSE;

            $config['cachedir'] = "";

            $config['char_set'] = "utf8";

            $config['dbcollat'] = "utf8_general_ci";

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

    }

    function index()

    {

        $data['title'] = "Plasma Steel Games | Bring Out Your Inner Gamer!";

        $data['heading'] = "Plasma Steel Games";

        $data['slogan'] = "Bring Out Your Inner Gamer!";

        $query = $this->db->query('SELECT * FROM news');

        $this->load->view('index.php', $data, $query);

    }

}

?&gt;

view file

Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

&lt;html &gt;

&lt;head&gt;

&lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt;

&lt;title&gt;&lt;?=$title?&gt;&lt;/title&gt;

&lt;/head&gt;

&lt;body&gt;

<center>

<h1>&lt;?=$heading?&gt;</h1>

<h4>&lt;?=$slogan?&gt;</h4>

</center>

<hr />

&lt;?php foreach($query->results() as $row): ?&gt;

<hr />

<h3>&lt;?=$row->title?&gt;</h3>

<h5>&lt;?=$row->author?&gt;</h5>

<hr />

<p>&lt;?=$row->body?&gt;</p>

&lt;?php endforeach; ?&gt;

&lt;/body&gt;

&lt;/html&gt;