Query convert into cakephp

Need Help
1

"SELECT email FROM members WHERE email = ‘$email’ LIMIT 1"
Please Convert this query into cakephp…
I have tried in

$nam=$_POST[‘name’]; //post method…
$srch= $this->Users->findAllByEmail($nam)->limit(1);
if(!empty)
{
echo “This record is already exist…”;
}

2

$srch= $this->Users->->find(‘all’, [
‘email’ => [‘Users.email’ => $nam]
]);
$row = $query->first();

1 Like
3

You shouldn’t access $_POST directly…
I’d use:
$nam = $this->request->data(‘name’);
$srch = $this->Users->find()
->where([‘Users.email’ => $nam)
->first();

2 Likes
4 
$email = $this->request->data['email'];

$firstEmail = $this->Members
      ->findByEmail($email)
      ->select(['email')]
      ->hydrate(false)
      ->first()

echo $firstEmail