CodeIgniter Model Example, MVC, How To Display Database Data In A View

CodeIgniter MVC -How To Display Single Database Value In View

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

How To Display A Singleton Select Value in CodeIgniter

When you are new to MVC it is not always obvious how to get data out of the database and into a view. This example shows how to display the result of a singleton select - i.e a query that always returns one row, and in this case, only one value.

The Model

class Tourdata extends Model {
function Tourdata(){
parent::Model();
}
function counttours($tourcode){
$query = $this-&gt;db-&gt;query("SELECT COUNT(*) tourcount FROM tourdate WHERE tourcode = '$tourcode'");
return $query-&gt;row()-&gt;tourcount;
}
}

The Controller

class Publicuser extends Controller {
var $data;
function Publicuser(){
parent::Controller();
$this-&gt;load-&gt;database();
$this-&gt;load-&gt;model('tourdata');
}
function index(){
$this-&gt;data['londontours'] = $this-&gt;tourdata-&gt;counttours('LONDON');
$this-&gt;load-&gt;view('publicuser/viewindex', $this-&gt;data);
}

The View


Number Tours This Year : &lt;%=$londontours%&gt;

Written by Liz Jamieson

Posted in: Code Igniter | by Liz Jamieson

Tags: CI, Code Igniter, code igniter model example

This entry was posted on Thursday, April 17th, 2008 at 10:49 am and is filed under Code Igniter. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.