CakePHP - 只有一个来自外部模型的查询

Question

I've two Models:

class Post extends AppModel {
    var $name = 'Post';
    var $belongsTo = array(
        'User' => array(
            'className' => 'User', 
            'foreignKey' => 'user_id'
        )
    );      
}

and

class User extends AppModel {
    var $name = 'User';
    var $hasMany = 'Post';
}

Now I'm having a problem with a query in the PostsController. I've an add() function and the view add.ctp which is basically a form. Now I would like to show some User information in that form.

class PostsController extends AppController {
    var $name = 'Posts';
    var $helper = array('Html', 'Form');
    var $uses = array('User');

    public function index() {
        $this->set('posts', $this->Post->find('all'));
    }

    function add() {
        $user_id = 1;
        $this->set('user', $this->User->findById($user_id));
        if ($this->request->is('post')) {
            if ($this->Post->save($this->request->data)) {
                $this->Session->setFlash('Your post has been saved.');
                $this->redirect(array('action' => 'index'));
            } else {
                $this->Session->setFlash('Unable to add your post.');
            }
        }
    }
}

But now the add-view-page shows that actually two queries where triggered. So if I print_r($user) within the add-view I'm getting an array with two arrays. One for a Post with user_id = 1 and one for the actual User with id = 1. But I would like to get only the User id = 1.

Answer 1

Try setting recursive to false on the User model before calling findById, so you won't get any data from associated models. Like this:

function add() {
    $user_id = 1;
    $this->User->recursive = false;
    $this->set('user', $this->User->findById($user_id));
    if ($this->request->is('post')) {
        if ($this->Post->save($this->request->data)) {
            $this->Session->setFlash('Your post has been saved.');
            $this->redirect(array('action' => 'index'));
        } else {
            $this->Session->setFlash('Unable to add your post.');
        }
    }
}