php - cakephp 从数据库中获取数据

Question

我是 cakephp 的新手，如何在 cakephp 中编写下面的 sql 查询

$sql = "SELECT * FROM `user` WHERE `email` = '" . $email . "' AND  `password` = '" . $password . "'";

$result = mysql_query($sql, $connection);

while($fetchdata = mysql_fetch_assoc($result)){
    echo $fetchdata['name'];
}

请帮帮我谢谢

Answer 1

在您的用户 Controller 中，您可以执行以下操作:

$this->set('user',$this->User->find('all', array ('conditions' => array('email' => $email, 'password' => $password))));

在你看来

foreach ($user as $us) {
   echo($us['name']);
//your code
}