SOLAR^1.1.2

对于fetch()方法，其参数是一个主键值（或是由主键值构成的数组）。

<?php
// a single blog record, blog.id = 1
$item = $model->blogs->fetch(1);

// a collection of blog records
$list = $model->blogs->fetch(array(1, 2, 5));

其他的获取方法有一系列参数，这些参数最终构成了SELECT语句。这些参数都是以关联数组的形式出现的。

<?php
$fetch = array(
    // SELECT ... FROM blogs AS zim
    'alias' => 'zim',
    
    // select these columns
    'cols' => array('id', 'foo', 'bar', 'SUM(baz) AS total'),
    
    // WHERE conditions
    'where' => array(
        'foo = :foo',
        'dib IN (?)' => array(1, 2, 5),
        'OR bar > ?' => $bar,
    ),
    
    // GROUP BY columns
    'group' => array('zim.id'),
    
    // HAVING conditions
    'having' => array(
        'total > ?' => $total,
    ),
    
    // ORDER BY columns
    'order' => array('total'),
    
    // you can use regular LIMITs ...
    'limit' => array($count, $offset),
    
    // ... or let the model calculate a page-based LIMIT
    'page'   => $page_number,
    'paging' => $rows_per_page,
    
    // do a followup query without limits to get a page count
    'count_pages' => true,
    
    // bind these placeholder values to the query
    'bind' => array('bar' => $bar),
);

// fetch a collection using the fetch params
$list = $model->blogs->fetchAll($fetch);

通过使用魔术方法__call()动态解析输入的方法名并且把它转化为一系列WHERE从句，模型对象允许获取记录和集合的简写形式。

有两种可识别的魔术方法：fetchAllBy...()和fetchOneBy...()。方法名中的其它词被当作被And分隔的字段名（其中column_name会被转化为ColumnName）。方法的参数和方法名中字段的值相等；额外的获取参数中最后一个结尾参数也是可识别的（译者注：如下面示例中最后一个fetch）。

<?php
// fetch a single blog record WHERE foo = 'bar'
$item = $model->blogs->fetchOneByFoo('bar');

// fetch a collection of blogs WHERE foo = 'bar' AND baz = 'dib'
$list = $model->blogs->fetchAllByFooAndBaz('bar', 'dib');

// fetch a collection of blogs WHERE zim = 'gir',
// with additional parameters
$params = array('order' => 'id DESC');
$list = $model->blogs->fetchAllByZim('gir', $params);