Access data after sql query in CakePHP

Question

I have performed the sql statement below and it has obtained the relevant row from the table.

sql;

$user = $this->UserVerifications
                ->find()
                ->where(['code' => $hash])
                ->all();

It is getting the row from the table 'UserVerifications' where the column 'code' is equal to the value of 'hash'. This bit works, see below for output.

debug($user);
\src\Controller\UsersController.php (line 57) object(Cake\ORM\ResultSet) {

'items' => [
    (int) 0 => object(App\Model\Entity\UserVerification) {

        'id' => (int) 23,
        'code' => '4206e38996fae4028a26d43b24f68d32',
        'date_created' => object(Cake\I18n\FrozenTime) {

            'time' => '2016-11-21T18:48:45+00:00',
            'timezone' => 'UTC',
            'fixedNowTime' => false

        },
        '[new]' => false,
        '[accessible]' => [
            '*' => true
        ],
        '[dirty]' => [],
        '[original]' => [],
        '[virtual]' => [],
        '[errors]' => [],
        '[invalid]' => [],
        '[repository]' => 'UserVerifications'

    }
]

}

According to the CakePHP website, or at least the way I'm reading it, I should be able to access the value for id by doing the following;

echo $user->id;

Notice (8): Undefined property: Cake\ORM\ResultSet::$id [APP/Controller\UsersController.php, line 58]

Am I missing something simple?

Felippe Duarte · Accepted Answer · 2016-11-21 20:36:41Z

3

Your $user is a collection/ResultSet, not a UserVerifications instance.

http://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html

You should iterate over it, like:

foreach($user as $u) {
    echo $u->id;
}

answered Nov 21, 2016 at 20:36

Felippe Duarte

15.2k2 gold badges27 silver badges29 bronze badges

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

Comments

Manohar Khadka · Accepted Answer · 2016-11-22 00:46:44Z

2

If you need particular row only from table,try this:

$user = $this->UserVerifications
            ->find()
            ->where(['code' => $hash])
            ->first();

And now you can use:

$user->id;

to access value of id and so on. And if you need multiple rows from the table go with @Felippe's answer.

answered Nov 22, 2016 at 0:46

Manohar Khadka

2,1952 gold badges20 silver badges31 bronze badges

Collectives™ on Stack Overflow

Access data after sql query in CakePHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related