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 :
