带有参数的Cakephp原始查询 - Cakephp raw query with paramaters

Cakephp raw query with paramaters

本文关键字：原始查询 Cakephp 参数 | 更新日期: 2023-09-27

有可能在CakePHP中做这样的事情吗？

            $messages = $this->Message->query("SELECT * FROM messages WHERE
                 (from_id = :id AND to_id = :user_id) OR
                 (to_id = :id AND from_id = :user_id)
                 ORDER BY created DESC", 
                 array(
                    'id' => $id,
                    'user_id' => $user_id
                )
            );

你可以试试这个：

$messages = $this->Message->find('all', array(
    'conditions' => array(
        'OR' => array(
            array('from_id' => $id, 'to_id' => $user_id),
            array('to_id' => $id, 'from_id' => $user_id),
        ),
    ),
    'order' => array(
        'created' => 'DESC',
    )
));