sql query using redbeans php

Question

Hi I am just beginning to use redbeans ORM. I followed the docs and tried doing a query like this

$thebean=R::find("users","id>2");

and then I loop through like:-

foreach($thebean as $bean){
echo $bean->username;
}

However I find that if the even if the users table contains more than 100 data, the above query only fetches the last data . for eg: if I have users 1 to 100. I only get the user with id=100. Can somebody please tell me what I might be doing wrong.

Try `var_dump($thebean);` and see if it is an array with all your records. — Benedikt Wölk, Nov 22 '11 at 09:57

score 3 · Answer 1 · answered Nov 23 '11 at 16:01

Could it be that your syntax is not correct? I have no experience with Redbean, but you might want to do something like this:

$users = R::find('users', 'id > ?', array('2'));
var_dump($users);

Either way, what is your result when you do the following? Does it return all your users or just one?

$users = R::find('users');
var_dump($users);

score 2 · Answer 2 · answered Jan 08 '13 at 23:40

2

You have to use "findAll" on the query. So for example:

$thebean = R::findAll('users', 'id > 2' array('id' => 2));

then you can do your standard foreach:

foreach ($thebean as $key => $bean) {

 echo $bean->username;

}

answered Jan 08 '13 at 23:40

Eddie

146
2
7

score 2 · Accepted Answer · answered Nov 24 '11 at 06:32

2

Seems that it was a problem with the id field. Solved it using tableformatter option.

answered Nov 24 '11 at 06:32

Rasmus

8,248
12
48
72

Can you tell me more details please? Thanks!! – chemitaxis Mar 21 '14 at 21:36
Please explain, I am having the exact problem. – James Jeffery Feb 27 '15 at 06:34

score 1 · Answer 4 · answered Nov 23 '11 at 15:47

1

Could be a problem on the type of field? Are you tried with: $thebean=R::find("users","id>'2'"); ?

answered Nov 23 '11 at 15:47

Galled

4,146
2
28
41

sql query using redbeans php

4 Answers4

Linked