$this->{model}->find('all',
                               array(
                                       'conditions' => null,//Where的条件
                                       'fields' => null,//显示的字段
                                       'joins' => array(), //关联的表
                                       'limit' => null,//显示的数据条数
                                       'offset' => null,//移动的条数
                                       'order' => null, //排序的条件
                                       'page' => null, //页数
                                       'group' => null, //Group By的条件
                                       )
                               );

$reviseModel=array('belongTo'=>array('user'));//定义需要修改那部分的model
$this->{model}->unbindModel($reviseModel);//禁止使用revisedModel中定义的model
$this->{model}->find();//搜索数据
$this->{model}->bindModel($reviseModel);//重新加载之前禁止使用的model

Example User Model, saved in /app/models/user.php  
<?php  
  
//AppModel gives you all of Cake's Model functionality  
  
class User extends AppModel  
{  
     // Its always good practice to include this variable.  
     var $name = 'User';
  
     // This is used for validation, see Chapter 11.
     var $validate = array();
  
     // You can also define associations.
     // See section 6.3 for more information.
  
     var $hasMany = array('Image' =>
                    array('className' => 'Image')  
                    );  
  
    // You can also include your own functions:  
     function makeInactive($uid)  
     {  
         //Put your own logic here...  
     }  
}  
  
?>  

Example Model Functions  
<?php  
class Post extends AppModel  
{  
    var $name = 'Post';  
  
    function hide ($id=null)  
    {  
       if ($id)  
       {  
           $this->id = $id;  
           $this->saveField('hidden', '1');  
       }  
    }  
  
    function unhide ($id=null)  
    {  
       if ($id)  
       {  
           $this->id = $id;  
           $this->saveField('hidden', '0');  
       }  
    }  
}  
?>  

findAll
  string $conditions
  array $fields
  string $order
  int $limit
  int $page
  int $recursive

find
  string $conditions
  array $fields
  string $order
  int $recursive

findAllBy<fieldName>
  string $value

<?
$this->Post->findByTitle('My First Blog Post');  
$this->Author->findByLastName('Rogers');  
$this->Property->findAllByState('AZ');  
$this->Specimen->findAllByKingdom('Animalia');  ?>

findNeighbours
  string $conditions
  array $field
  string $value

<?
class ImagesController extends AppController  
{  
     function view($id)  
     {  
         // Say we want to show the image...  
  
         $this->set('image', $this->Image->find("id = $id");  
  
         // But we also want the previous and next images...  
  
         $this->set('neighbours', $this->Image->findNeighbours(null, 'id', $id);  
  
     }  
}  ?>

field
  string $name
  string $conditions
  string $order

findCount
  string $conditions

generateList
  string $conditions
  string $order
  int    $limit
  string $keyPath
  string $valuePath

<?
$this->set(  
     'Roles',  
     $this->Role->generateList(null, 'role_name ASC', null, '{n}.Role.id', '{n}.Role.role_name')  
);  
  
//This would return something like:  
array(  
     '1' => 'Account Manager',  
     '2' => 'Account Viewer',  
     '3' => 'System Manager',  
     '4' => 'Site Visitor'  
);
?>

read
  string $fields
  string $id

query
  string $query
  
execute
  string $query

Custom Sql Calls with query()  
<?php  
class Post extends AppModel  
{  
     var $name = 'Post';  
  
     function posterFirstName()  
     {  
         $ret = $this->query("SELECT first_name FROM posters_table
                                  WHERE poster_id = 1");  
         $firstName = $ret[0]['first_name'];  
         return $firstName;  
     }  
}  
?>  

<?
array  
(  
     "Post.title"   => array("First post", "Second post", "Third post"),  
     "Post.created" => "> " . date('Y-m-d', strtotime("-2 weeks"))  
)  
?>

<?
array  
("or" =>  
     array  
     (  
         "Post.title" => array("First post", "Second post", "Third post"),  
         "Post.created" => "> " . date('Y-m-d', strtotime("-2 weeks"))  
     )  
)  
?>

<?
array  
("Author.name" => "Bob", "or" => array  
     (  
         "Post.title" => "LIKE %magic%",  
         "Post.created" => "> " . date('Y-m-d', strtotime("-2 weeks")  
     )  
)  
?>

<?
Array  
(  
     [ModelName] => Array  
         (  
             [fieldname1] => 'value'  
             [fieldname2] => 'value'  
         )  
)  
?>

<?
function edit($id)  
{  
  
    //Note: The property model is automatically loaded for us at $this->Property.  
  
    // Check to see if we have form data...  
    if (emptyempty($this->data))  
    {  
         $this->Property->id = $id;  
         $this->data = $this->Property->read();//populate the form fields with the current row  
    }  
    else  
    {  
       // Here's where we try to save our data. Automagic validation checking  
       if ($this->Property->save($this->data['Property']))
       {
          //Flash a message and redirect.
          $this->flash('Your information has been saved.',
                      '/properties/view/'.$this->data['Property']['id'], 2);  
       }  
       //if some fields are invalid or save fails the form will render  
    }  
}  
?>

del
  string $id
  boolean $cascade

saveField
  string $name
  string $value

getLastInsertId

beforeFind
  string $conditions

afterFind
  array $results

beforeValidate

beforeSave

// Date/time fields created by HTML Helper:  
// This code would be seen in a view  
  
$html->dayOptionTag('Event/start');  
$html->monthOptionTag('Event/start');  
$html->yearOptionTag('Event/start');  
$html->hourOptionTag('Event/start');  
$html->minuteOptionTag('Event/start');  
  
/*=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-*/  
  
// Model callback functions used to stitch date  
// data together for storage  
// This code would be seen in the Event model:  
  
function beforeSave()  
{  
    $this->data['Event']['start'] = $this->_getDate('Event', 'start');  
  
    return true;  
}  
  
function _getDate($model, $field)  
{  
    return date('Y-m-d H:i:s', mktime(  
        intval($this->data[$model][$field . '_hour']),  
        intval($this->data[$model][$field . '_min']),  
        null,  
        intval($this->data[$model][$field . '_month']),  
        intval($this->data[$model][$field . '_day']),  
        intval($this->data[$model][$field . '_year'])));  
}  

afterSave
[code]
保存完成后执行的动作。[ToDo 如果保存出错是否会触发？]

[code]
beforeDelete

afterDelete

hasOne

hasMany

belongsTo

hasAndBelongsToMany

/app/models/user.php hasOne  
<?php  
class User extends AppModel  
{  
    var $name = 'User';  
    var $hasOne = array('Profile' =>  
                        array('className'    => 'Profile',  
                              'conditions'   => '',  
                              'order'        => '',  
                              'dependent'    =>  true,  
                              'foreignKey'   => 'user_id'  
                        )  
                  );  
}  
?>  

$user = $this->User->read(null, '25');  
print_r($user);  
  
//output:  
  
Array  
(  
    [User] => Array  
        (  
            [id] => 25  
            [first_name] => John  
            [last_name] => Anderson  
            [username] => psychic  
            [password] => c4k3roxx  
        )  
  
    [Profile] => Array  
        (  
            [id] => 4  
            [name] => Cool Blue  
            [header_color] => aquamarine  
            [user_id] = 25  
        )  
)  

/app/models/profile.php belongsTo  
<?php  
class Profile extends AppModel  
{  
    var $name = 'Profile';  
    var $belongsTo = array('User' =>  
                           array('className'  => 'User',  
                                 'conditions' => '',  
                                 'order'      => '',  
                                 'foreignKey' => 'user_id'  
                           )  
                     );  
}  
?>  

$profile = $this->Profile->read(null, '4');  
print_r($profile);  
  
//output:  
  
Array  
(  
  
    [Profile] => Array  
        (  
            [id] => 4  
            [name] => Cool Blue  
            [header_color] => aquamarine  
            [user_id] = 25  
        )  
  
    [User] => Array  
        (  
            [id] => 25  
            [first_name] => John  
            [last_name] => Anderson  
            [username] => psychic  
            [password] => c4k3roxx  
        )  
)  

/app/models/user.php hasMany  
<?php  
class User extends AppModel  
{  
    var $name = 'User';  
    var $hasMany = array('Comment' =>  
                         array('className'     => 'Comment',  
                               'conditions'    => 'Comment.moderated = 1',  
                               'order'         => 'Comment.created DESC',  
                               'limit'         => '5',  
                               'foreignKey'    => 'user_id',  
                               'dependent'     => true,  
                               'exclusive'     => false,  
                               'finderQuery'   => ''  
                         )  
                  );  
  
    // Here's the hasOne relationship we defined earlier...  
    var $hasOne = array('Profile' =>
                        array('className'    => 'Profile',
                              'conditions'   => '',
                              'order'        => '',
                              'dependent'    =>  true,
                              'foreignKey'   => 'user_id'  
                        )  
                  );  
}  
?>

$user = $this->User->read(null, '25');  
print_r($user);  
  
//output:  
  
Array  
(  
    [User] => Array  
        (  
            [id] => 25  
            [first_name] => John  
            [last_name] => Anderson  
            [username] => psychic  
            [password] => c4k3roxx  
        )  
  
    [Profile] => Array  
        (  
            [id] => 4  
            [name] => Cool Blue  
            [header_color] => aquamarine  
            [user_id] = 25  
        )  
  
    [Comment] => Array  
        (  
            [0] => Array  
                (  
                    [id] => 247  
                    [user_id] => 25  
                    [body] => The hasMany assocation is nice to have.  
                )  
  
            [1] => Array  
                (  
                    [id] => 256  
                    [user_id] => 25  
                    [body] => The hasMany assocation is really nice to have.  
                )  
  
            [2] => Array  
                (  
                    [id] => 269  
                    [user_id] => 25  
                    [body] => The hasMany assocation is really, really nice to have.  
                )  
  
            [3] => Array  
                (  
                    [id] => 285  
                    [user_id] => 25  
                    [body] => The hasMany assocation is extremely nice to have.  
                )  
  
            [4] => Array  
                (  
                    [id] => 286  
                    [user_id] => 25  
                    [body] => The hasMany assocation is super nice to have.  
                )  
  
        )  
)  

下面是生成的数据库脚本：

Here's what the SQL dumps will look like for our Posts HABTM Tags example:

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) default NULL,
  `title` varchar(50) default NULL,
  `body` text,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  `status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

--
-- Table structure for table `posts_tags`
--

CREATE TABLE `posts_tags` (
  `post_id` int(10) unsigned NOT NULL default '0',
  `tag_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`,`tag_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tag` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;With our tables set up, let's define the association in the Post model:

/app/models/post.php hasAndBelongsToMany
<?php
class Post extends AppModel
{
    var $name = 'Post';
    var $hasAndBelongsToMany = array('Tag' =>
                               array('className'    => 'Tag',
                                     'joinTable'    => 'posts_tags',
                                     'foreignKey'   => 'post_id',
                                     'associationForeignKey'=> 'tag_id',
                                     'conditions'   => '',
                                     'order'        => '',
                                     'limit'        => '',
                                     'uniq'         => true,
                                     'finderQuery'  => '',
                                     'deleteQuery'  => '',
                               )
                               );
}
?>

post = $this->Post->read(null, '2');  
print_r($post);  
  
//output:  
  
Array  
(  
    [Post] => Array  
        (  
            [id] => 2  
            [user_id] => 25  
            [title] => Cake Model Associations  
            [body] => Time saving, easy, and powerful.  
            [created] => 2006-04-15 09:33:24  
            [modified] => 2006-04-15 09:33:24  
            [status] => 1  
        )  
  
    [Tag] => Array  
        (  
            [0] => Array  
                (  
                    [id] => 247  
                    [tag] => CakePHP  
                )  
  
            [1] => Array  
                (  
                    [id] => 256  
                    [tag] => Powerful Software  
                )  
        )  
)  

//------------Post Comment都没有持久化------------  
  
/app/controllers/posts_controller.php (partial)  
function add()  
{  
    if (!emptyempty($this->data))  
    {  
        //We can save the Post data:  
        //it should be in $this->data['Post']  
          
        $this->Post->save($this->data);  
  
        //Now, we'll need to save the Comment data  
        //But first, we need to know the ID for the  
        //Post we just saved...  
  
        $post_id = $this->Post->getLastInsertId();  
  
        //Now we add this information to the save data  
        //and save the comment.  
  
        $this->data['Comment']['post_id'] = $post_id;  
  
        //Because our Post hasMany Comments, we can access  
        //the Comment model through the Post model:  
  
        $this->Post->Comment->save($this->data);  
  
    }  
}  

/app/controllers/posts_controller.php (partial)  
//Here's how it would look if the URL param is used...  
function addComment($post_id)  
{  
    if (!emptyempty($this->data))  
    {  
        //You might want to make the $post_id data more safe,  
        //but this will suffice for a working example..  
  
        $this->data['Comment']['post_id'] = $post_id;  
  
        //Because our Post hasMany Comments, we can access  
        //the Comment model through the Post model:  
  
        $this->Post->Comment->save($this->data);  
    }  
}  

app/views/posts/add.thtml Form for creating posts

                <h1>Write a New Post</h1>
                
                    <table>  
                    
                    <tr>    
                    
                        <td>Title:</td>  
    
                        <td><?php echo $html->input('Post/title')?></td>
    
                    </tr>
                    
                    <tr>        
                    
                        <td>Body:<td>
    
                        <td><?php echo $html->textarea('Post/title')?></td>
    
                    </tr>
                    
                    <tr>
                    
                    <td colspan="2">
    
                        <?php echo $html->hidden('Post/user_id', array('value'=>$this->controller->Session->read('User.id')))?>
                        
                        <?php echo $html->hidden('Post/status' , array('value'=>'0'))?>
                        
                        <?php echo $html->submit('Save Post')?>
                        
                    </td>
    
                    </tr>
                    
                    </table>

/app/views/posts/add.thtml (Tag association code added)
<h1>Write a New Post</h1>
    <table>
        <tr>
            <td>Title:</td>
            <td><?php echo $html->input('Post/title')?></td>
        </tr>
        <tr>
            <td>Body:</td>
            <td><?php echo $html->textarea('Post/title')?></td>
        </tr>
        
        <tr>
            <td>Related Tags:</td>
            <td><?php echo $html->selectTag('Tag/Tag', $tags, null, array('multiple' => 'multiple')) ?>
            </td>
        </tr>
        
        <tr>
            <td colspan="2">
                <?php echo $html->hidden('Post/user_id', array('value'=>$this->controller->Session->read('User.id')))?>
                <?php echo $html->hidden('Post/status' , array('value'=>'0'))?>
                <?php echo $html->submit('Save Post')?>
            </td>
        </tr>
</table>

leader.php and follower.php  
<?php  
  
class Leader extends AppModel  
{  
    var $name = 'Leader';  
  
    var $hasMany = array(  
        'Follower' => array(  
            'className' => 'Follower',  
            'order'     => 'Follower.rank'  
        )  
    );  
}  
  
?>  
  
<?php  
  
class Follower extends AppModel  
{  
    var $name = 'Follower';  
}  
  
?>  

leaders_controller.php (partial)  
function someAction()  
{  
    //This fetches Leaders, and their associated Followers  
    $this->Leader->findAll();  
  
    //Let's remove the hasMany...  
    $this->Leader->unbindModel(array('hasMany' => array('Follower')));
    
    //Now a using a find function will return Leaders, with no Followers
    $this->Leader->findAll();

    //NOTE: unbindModel only affects the very next find function.
    //注意：unbindModel方法只作用一次，第二次find方法调用时则仍然是关联关系有效的
    //An additional find call will use the configured association information.

    //We've already used findAll() after unbindModel(), so this will fetch  
    //Leaders with associated Followers once again...  
    $this->Leader->findAll();  
}  

leaders_controller.php (partial)  
funciton anotherAction()  
{  
    //There is no Leader hasMany Principles in the leader.php model file, so  
    //a find here, only fetches Leaders.  
    $this->Leader->findAll();  
  
    //Let's use bindModel() to add a new association to the Principle model:  
    $this->Leader->bindModel(  
        array('hasMany' => array(
                'Principle' => array(
                    'className' => 'Principle'
                )
            )
        )
    );

    //Now that we're associated correctly, we can use a single find function  
    //to fetch Leaders with their associated principles:  
    $this->Leader->findAll();  
}  

Generic bindModel() example  
$this->Model->bindModel(  
        array('associationName' => array(  
                'associatedModelClassName' => array(  
                    // normal association keys go here...  
                )  
            )  
        )  
    );