Welcome to the Cookbook

There is no translation yet for this section. Please help out and translate this.. More information about translations

While CakePHP’s model functions should get you where you need to go, don’t forget that model classes are just that: classes that allow you to write your own methods or define your own properties.

Any operation that handles the saving and fetching of data is best housed in your model classes. This concept is often referred to as the fat model.

class Example extends AppModel {

   function getRecent() {
      $conditions = array(
         'created BETWEEN (curdate() - interval 7 day) and (curdate() - interval 0 day))'
      );
      return $this->find('all', compact('conditions'));
   }
}

1. class Example extends AppModel {
2. function getRecent() {
3. $conditions = array(
4. 'created BETWEEN (curdate() - interval 7 day) and (curdate() - interval 0 day))'
5. );
6. return $this->find('all', compact('conditions'));
7. }
8. }

This getRecent() method can now be used within the controller.

$recent = $this->Example->getRecent();

1. $recent = $this->Example->getRecent();