How To Work With Findall

Yii 1.1 General Discussion
1 

$user=Users::model()->findAll('status=:status',array(':status'=>5));

using above code I need to get the


$user->email;

but it will give error

"Trying to get property of non-object "

can you tell me how do I get it;

in my model I have status and email attribute.I need get the all the email from the table where status =5

how do I get it pls help me.

2

That’s because findAll() returna ARRAY of values, not a single value.

Use find() if you want to get only one record.

3 



$user=Users::model()->findAll('status=:status',array(':status'=>5));

foreach($user as $user_1)

{

echo $user_1->email;

}

Try this…

4

can you tell me how do I get all the record not only one.

5

whaen it

echo $user_1->email it also display only one record.how do I get all the record of email column.pls help me

6

according to your condition in find all there is only one record is present , If you want all record remove the condition in the findAll()

7

can you pls post the code for that.when remove the condition it will give the error

8

http://www.yiiframework.com/doc/guide/1.1/en/database.ar

9 



$user=Users::model()->findAll();

foreach($user as $user_1)

{

echo $user_1->email;

}
10

Actually, you had a typo.

Should be


echo $user_1->email;
11

thanx