教义1.2查询联接多对多
|
说我有以下许多工作和用户
Assignment:
columns:
job_id:
....
user_id:
....
relations:
user:
local: user_id
foreign: id
job:
local: job_id
foreign: id
没有找到相关结果
已邀请:
1 个回复
递劝臼类洪
$jobs = Doctrine_Query::create() ->from(\'Job j\') ->leftJoin(\'j.Assignments a\') ->innerJoin(\'a.user u\') ->execute(); foreach($jobs as $job) { foreach($job->Assignments as $assignment) { $user = $assignment->user; // do something with $job and $user here } }$users = Doctrine_Query::create() ->from(\'User u\') ->leftJoin(\'u.Assignments a\') ->innerJoin(\'a.job j\') ->execute(); foreach($users as $user) { foreach($user->Assignments as $assignment) { $job = $assignment->job; // do something with $job and $user here } }$assignments = Doctrine_Query::create() ->from(\'Assignment a\') ->innerJoin(\'a.user u\') ->innerJoin(\'a.job j\') ->execute(); foreach($assignments as $assignment) { $user = $assignment->user; $job = $assignment->job; // do something with $job and $user here }