how to query many-to-many relationship in same table by redbeanphp?
Navid_pdp11
I have a table named "user" and this table has many to many relation over its own such as favorite action. this means a user can favorite multiple users and can be Favorited by multiple users.
now I want query over this relation and get every users those Favorite a spacial user.
I use this code :
$users = $agent->via($TB_Favorite,"agent_id=? and favorite.action=?", array($userId,FAVORITE_TYPE_USER_FAVORITE))->sharedUsers ;
I debug this code by profiling database and get this result:
SELECT
`users`.* ,
COALESCE(
NULLIF(`favorite`.`users_id`, `users`.id),
NULLIF(`favorite`.`users2_id`, `users`.id)) AS linked_by
FROM `favorite`
INNER JOIN `users` ON
( `users`.id = `favorite`.`users2_id` AND `favorite`.`users_id` IN ('13') ) OR
( `users`.id = `favorite`.`users_id` AND `favorite`.`users2_id` IN ('13') )
but in this case it must use favorite.agent_id instead favorite.users2_id how can i resolve this problem ?
this is my table diagram : 
may be this make my position clear.
Gabor de Mooij
Okay, thanks for the diagram and the additional explanation. So, you want to query the users associated with the favorite activities of a user. Here's one possible solution (tested on an empty db here):
$x = R::dispense(array(
'_type' => 'user',
'name' => 'Q',
'ownActivity' => array(
array('_type'=>'favorite',
'name'=>'A',
'agent'=> array(
'_type'=>'user',
'name'=>'X')),
array('_type'=>'favorite',
'name'=>'B',
'agent'=> array(
'_type'=>'user',
'name'=>'Y')),)));
R::store($x);
$me = R::findOne('user', ' `name` = ? ', array('Q'));
$favoriteActivities = $me->ownFavoriteList;
foreach($favoriteActivities as $activity) {
$agent = $activity->fetchAs('user')->agent;
$favoriteUsers[$agent->id] = $agent;
echo $agent->name;
}
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Dynamically create hash of hash with array ref values
- Next: Will I run into trouble with python's Global Interpreter Lock?
Related
Related Related
- 1
query over many to many relationship in redbeanphp
- 2
Many to many relationship in the same table?
- 3
how to query a many to many relationship?
- 4
How to query a pivot table data in MySQL (many to many relationship)
- 5
One to many relationship on the same table
- 6
many to many in redbeanphp is not full
- 7
How to populate a many-to-many relationship as table
- 8
How to map a double Many To One relationship to the same table in Doctrine 2?
- 9
How to query a one to many/many to many relationship in Flask SQL Alchemy?
- 10
Fetching one to many relationship from same table
- 11
Laravel 4 how to set up many-to-many relationship with the same table
- 12
EntityFramework CodeFirst: CASCADE DELETE for same table many-to-many relationship
- 13
Many-to-many relationship between same table with extra column in EF
- 14
How to get all books from another table when using many to many relationship Laravel / Eloquent / Query builder
- 15
hibernate not locating junction table in query of many to many relationship
- 16
Query for retrieving data from a bridging table of many to many relationship
- 17
hibernate not locating junction table in query of many to many relationship
- 18
Query many to many relationship with DetachedCriteria
- 19
eloquent: query many to many relationship
- 20
Recursive relationship on a many to many table
- 21
SQL many to many relationship table
- 22
Junction table/many to many relationship
- 23
How to query one-to-many relationship in JPQL?
- 24
How to query for many to many relationship between products and filters in MySQL?
- 25
How to efficiently query many-to-many relationship on two columns
- 26
how to write a Linq query with a EF code first Many to Many relationship
- 27
One to many relationship table
- 28
How can I reference an intersection table of a many-to-many relationship?
- 29
MySQL - How to insert into table that has many-to-many relationship
Comments