cakephp get data from db

Question

I'm new to cakephp how to write below sql query in cakephp

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

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

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

Please help me Thanks

coz I need to know how to write normal mysql code in cakephp. I mention it on my answer — iswan
– iswan, Commented Feb 22, 2013 at 10:07

Alessandro Minoccheri · Accepted Answer · 2013-02-22 09:55:33Z

2

In your User controller you can do something like:

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

And in your view

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

answered Feb 22, 2013 at 9:55

Alessandro Minoccheri

36.1k22 gold badges128 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mukul Kant · Accepted Answer · 2017-03-15 07:29:45Z

1

For your query:

<?php

 $this->loadmodel('User');
 $result = $this->User->find('first',array('conditions' => array('email' => $email,  
 'password' => $password)));
 foreach($result as $row)
 {
   //do whatever you want to do

 }
?>

edited Mar 15, 2017 at 7:29

Mukul Kant

7,1705 gold badges44 silver badges57 bronze badges

answered Feb 22, 2013 at 9:58

kidz

3081 silver badge8 bronze badges

2 Comments

Alessandro Minoccheri Over a year ago

Your code isn't correct you have miss a ' after User and he wants all result not only first

kidz Over a year ago

Thanks, that was a typo. I fixed it. And for first/all, please look into the query. For those type of queries, there should be always only one email with password combination. But still there are options to get all, instead of first. I hope I am clear now

Raj Adroit · Accepted Answer · 2013-02-22 09:54:15Z

1

read this for easy authentication with cakephp framework http://book.cakephp.org/2.0/en/tutorials-and-examples/blog-auth-example/auth.html

answered Feb 22, 2013 at 9:54

Raj Adroit

3,8885 gold badges34 silver badges44 bronze badges

Comments

Dipesh Parmar · Accepted Answer · 2013-02-22 10:05:43Z

1

Use cakephp find method to do that.

<?php

    $users = $this->User->find('first',array
    (
        'conditions' => array
        (
            'User.email'    => $email,
            'User.password' => $password
        )
    ));

    pr($users);
    exit;

?>

i have added pr($users);exit; for debugging result of query.

You can also pass recursive, limit , order etc along with find method read more about find at cakephp

answered Feb 22, 2013 at 10:05

Dipesh Parmar

27.3k8 gold badges65 silver badges92 bronze badges

Comments

A.A Noman · Accepted Answer · 2017-02-09 05:37:18Z

1

If you are in Users Controller then it is not necessary to load your Model and connect your database. If you access users Model from another Model then load your User Model in your controller. You load your model in two ways

$this->loadmodel('User');
or
public $uses = array('User');
$results = $this->User->find('all',array('conditions' => array('email' => $email,'password' => $password)));
$this->set(compact('results '));

now in your view file use this

foreach ($results as $users) {
  echo h($users['User']['email']);
  echo h($users['User']['password']);
}

answered Feb 9, 2017 at 5:37

A.A Noman

5,2669 gold badges28 silver badges49 bronze badges

Collectives™ on Stack Overflow

cakephp get data from db

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related