Many to One

[Mohamed Nazim]

I just started using RB.

I can't seem to find a solution to the problem.

I have two tables so far - both autogenerated in fluid mode.

user
emailverifications

The latter being a child of user. After a find an emailverification using

$verification = R::find("emailverifications", "code = ?" , [$code];

I try to get the related parent user:

$user = $verification->user;

but I am getting error "Trying to property of non-object"

I checked emailverifications table and there is a related user_id field.

What am I doing wrong?

Appreciate any help :)

[Łukasz Strzyżowski]

Try to check if $verification is bean that is really found. Maybe its just empty.

[gabor]

Sorry for my late reply, migrating the RedBeanPHP server... :)


Use R::findOne instead of R::find.
R::find returns an array not an object ;)


Anyway,

Over here this works:

R::setup();
$user = R::dispense('user');
$user->name = 'Nazim';
$ev = R::dispense('emailverification');
$ev->code = 'ABC';
$user->ownEmailverificationList[] = $ev;
$id = R::store($user);

//now lets load...
$verification = R::findOne('emailverification', ' code = ? ', ['ABC']);
echo $verification->user;

It prints:

{"id":"1","name":"Nazim"}

cheers
Gabor