本文实例讲述了symfony2联合查询实现方法。分享给大家供大家参考，具体如下：
1.yml文件
acmemspadminbundleentitymsparticle:
type: entity
table: msp_article
manytoone:
channel:
targetentity: mspchannel
inversedby: articles
joincolumn:
name: channel_id
referencedcolumnname: channel_id
user:
targetentity: mspuser
inversedby: userone
joincolumn:
name: user_id
referencedcolumnname: user_id
acmemspadminbundleentitymspchannel:
type: entity
table: msp_channel
onetomany:
articles:
targetentity: msparticle
mappedby: channel
acmemspadminbundleentitymspuser:
type: entity
table: msp_user
onetomany:
userone:
targetentity: msparticle
mappedby: user
2.查询代码：
$sql="select a.id,a.checkstatus,a.title,a.releasesysdate,
a.visittotal,u.username ,n.name from acmemspadminbundle:msparticle a
join a.user u join a.channel n";
$query = $emt->createquery($sql." where a.checkstatus = 0 ");
$mspartile = $query->getresult();
希望本文所述对大家基于symfony框架的php程序设计有所帮助。
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！