Русскоязычный форум, посвященный фреймворку Kohana

DB::query(DATABASE::SELECT,$sql)
         ->param(':id',$id)
         ->execute();

$query = DB::query(Database::SELECT, 'SELECT * FROM users WHERE username = :user AND status = :status') 
            ->parameters(array(    
                ':user' => 'john',    
                ':status' => 'active',
        ));

$result = $query->as_array();

$sql = "SELECT * FROM ". $this->_table ." WHERE `positions` = :positions AND 'user_id' = :user_id";
 
        $query = DB::query(Database::SELECT, $sql, FALSE)
                ->parameters(array(':positions' => $positions))
                ->parameters(array(':user_id' => $pers['user_id']))
                ->execute();

class Model_Attention extends Model {
        
    public function addlostdoc()
    {
        $query = DB::insert('attentions', array('name', 'sirname', 'fathername', 'id_doctype', 'status', 'information'))
                            ->values(array($name, $sirname, $fathername, $id_doctype, $status, $information));

        return $query->execute();
    }
}

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

class Controller_Lostdoc extends Controller_Base {

   public function action_index()
    {
        $block_center = View::factory('v_addlostdoc');        
        $styles = 'media/css/style.css';
        
        
        $this->template->page_title = 'Добавить объявление об утре';
        $this->template->block_center = array($block_center);
        
        $this->template->styles = array($styles);
    }
    
    public function action_addlost($status = 0)
    {
        if (isset($_POST['submit']))
        {
            $att = Arr::extract($_POST, array('name', 'sirname', 'fathername', 'id_doctype', 'information'));
            
            Model::factory('Attention')->addlostdoc($att['name'], 
                    $att['sirname'], 
                    $att['fathername'], 
                    $att['id_doctype'], 
                    $att['information']);
        }        
    }
}

// Controller:
Model::factory('Attention')->addlostdoc( Arr::extract($_POST, array('name', 'sirname', 'fathername', 'id_doctype', 'information')));

//Model:
public function addlostdoc($data)
    {
        $query = DB::insert('attentions', array('name', 'sirname', 'fathername', 'id_doctype', 'status', 'information'))
                            ->values($data);
        return $query->execute();
    }

// Controller:
Model::factory('Attention')->addlostdoc($_POST);

//Model:
public function addlostdoc($data)
    {
        $query = DB::insert('attentions', array('name', 'sirname', 'fathername', 'id_doctype', 'status', 'information'))
                            ->values(Arr::extract($data, array('name', 'sirname', 'fathername', 'id_doctype', 'information')));
        return $query->execute();
    }

array('name', 'sirname', 'fathername', 'id_doctype', 'status', 'information')

/**
 * Initialize Kohana, setting the default options.
 *
 * The following options are available:
 *
 * - string   base_url    path, and optionally domain, of your application   NULL
 * - string   index_file  name of your index file, usually "index.php"       index.php
 * - string   charset     internal character set used for input and output   utf-8
 * - string   cache_dir   set the internal cache directory                   APPPATH/cache
 * - boolean  errors      enable or disable error handling                   TRUE
 * - boolean  profile     enable or disable internal profiling               TRUE
 * - boolean  caching     enable or disable internal caching                 FALSE
 */
Kohana::init(array(
   'base_url'   => 'http://localhost/my-project/'
        'index_file' => FALSE,
   'profile' => (Kohana::$environment === Kohana::DEVELOPMENT),
   'caching' => (Kohana::$environment === Kohana::PRODUCTION),
   'errors'  => TRUE //(Kohana::$environment === Kohana::DEVELOPMENT),
));