CodeIgniter MVC – How To Display Single Database Value In View

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->db->query("SELECT COUNT(*) tourcount
      FROM tourdate WHERE tourcode = '$tourcode'");
    return $query->row()->tourcount;
}
}

The Controller

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

The View

Number Tours This Year : <%=$londontours%>

Tagged as: CI, Code Igniter, code igniter model example