Model_Chat

<?php defined('SYSPATH') or die('No direct script access.');

class Model_Chat extends Model
{
    protected $_tableChat = 'chat';

    /**
     * Get comments for article
     * @return array
     */
    public function get_chat()
    {
        $query = DB::select('user', 'chat_msg')
                ->from($this->_tableChat)
                ->order_by('date', 'DESC')
                ->execute()
                ->as_array();

        if($query)
            return $query;
        else
            return array();
    }

    /**
     * Create new comment
     */
    public function create_chat_msg($user, $chat_msg, $date)
    {
        DB::insert($this->_tableChat, array('user', 'chat_msg', 'date'))
            ->values(array($user, $chat_msg, $date))
            ->execute();
    }
}