CODEWITHSUNDEEP
phpcakephpcakephp-2.0
Some Ting Wong
Some Ting Wong

Reputation: 27

Cakephp 2.x - How to retrieve data from database to controller

HEELP! I have a table called "User" and the fields are id, name and mobile. I want to retrieve the mobile field so that the user can dynamically change the $number variable. I've been working in this for 2 days and I can't find the way to make it happen

This part is in the Reservation controller:

$options = array('conditions' => array('User.id' => 1), 'fields' => array('User.mobile'));
$number = $this->User->find('first', $options);

$this->PanaceaSms->username = "username";
$this->PanaceaSms->password = "password"; 
$this->PanaceaSms->send($number, "Hello there valued customers");

Forgive me for newbie question. If you have any questions feel free to ask. :)

Upvotes: 0

Views: 1640

Answers (1)

Sougata Bose
Sougata Bose

Reputation: 31739

Try with - 

$number = $this->User->field('mobile', array('User.id' => 1));

And for your code it whould be - 

$options = array('conditions' => array('User.id' => 1), 'fields' => array('User.mobile'));
$data = $this->User->find('first', $options);
$number = $data['User']['mobile'];

Upvotes: 1

Related Questions