articles_model.php

<?php

class Articles_model extends CI_Model

{
    private $table = "article";

    return $this->db->select('`id`,  DATE_FORMAT(`date`,\'%d/%m/%Y &agrave; %H:%i:%s\') AS \'date\'', `titre`, 'contenu', false)
            ->from($this->table)
            ->order_by('id', 'desc')
            ->limit($nb, $debut)
            ->get()
            ->result();
}