<?php defined('SYSPATH') or die('No direct script access.');
 
class Model_Newsmodel extends Kohana_Model
{
    
    public function news_view()
        {   
           $id = isset($_GET['id']) ? $_GET['id'] : null;
           return  DB::select()
                   ->from('news')
                   ->where('id', '=', ''.$id.'')
                   ->execute()                   
                   ->as_array(); 
        }  
   
     
    public function news_index()
        {   
            return DB::select()
                    ->from('news')
                    ->order_by('id', 'DESC')
                    ->execute()                   
                    ->as_array(); 
        }   
    public function comments_save($id, $name, $text, $date)
    {

            return DB::insert('comments', array('newsid', 'name', 'text', 'date'))
                     ->values(array($id, $name, $text, $date))
                    ->execute();
                    

    }
    public function comments_view()
        {   
           $id = isset($_GET['id']) ? $_GET['id'] : null;
           return  DB::select()
                   ->from('comments')
                   ->where('newsid', '=', ''.$id.'')
                   ->execute()                   
                   ->as_array(); 
        }  
       
          
}