# Query convert into cakephp

**URL:** <https://discourse.cakephp.org/t/query-convert-into-cakephp/1986>\
**Category:** Need Help\
**Created:** [February 4, 2017, 4:40am UTC](https://discourse.cakephp.org/t/query-convert-into-cakephp/1986 "2017-02-04T04:40:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nohastanvir](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/nohastanvir/32/419_2.png) [@Nohastanvir](https://discourse.cakephp.org/u/Nohastanvir)\
**Post date:** [February 4, 2017, 4:40am UTC](https://discourse.cakephp.org/t/query-convert-into-cakephp/1986/1 "2017-02-04T04:40:25Z")

</div>

"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…”;  
}

---

<div class="post-metadata">

**Author:** ![SATHISH](https://avatars.discourse-cdn.com/v4/letter/s/858c86/32.png) [@SATHISH](https://discourse.cakephp.org/u/SATHISH)\
**Post date:** [February 4, 2017, 4:45am UTC](https://discourse.cakephp.org/t/query-convert-into-cakephp/1986/2 "2017-02-04T04:45:22Z")

</div>

> [@Nohastanvir](#):
>
> findAllByEmail

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

---

<div class="post-metadata">

**Author:** ![risrik](https://avatars.discourse-cdn.com/v4/letter/r/958977/32.png) [@risrik](https://discourse.cakephp.org/u/risrik)\
**Post date:** [February 4, 2017, 9:02am UTC](https://discourse.cakephp.org/t/query-convert-into-cakephp/1986/3 "2017-02-04T09:02:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![JohnWayne](https://avatars.discourse-cdn.com/v4/letter/j/a698b9/32.png) [@JohnWayne](https://discourse.cakephp.org/u/JohnWayne)\
**Post date:** [February 7, 2017, 7:42pm UTC](https://discourse.cakephp.org/t/query-convert-into-cakephp/1986/4 "2017-02-07T19:42:50Z")

</div>

```
$email = $this->request->data['email'];

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

echo $firstEmail
```