symfony2联合查询实现方法，symfony2联合查询本文实例讲述了symfony2联合查询实现方法。分享给大家供大家参考，具体如下：
1.yml文件
acme\mspadminbundle\entity\msparticle: 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
acme\mspadminbundle\entity\mspchannel: type: entity table: msp_channel onetomany: articles: targetentity: msparticle mappedby: channel
acme\mspadminbundle\entity\mspuser: 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程序设计有所帮助。
您可能感兴趣的文章:symfony2创建页面实例详解symfony2.4的twig中date用法分析symfony2之session与cookie用法小结symfony2实现从数据库获取数据的方法小结symfony2框架学习笔记之表单用法详解symfony2学习笔记之插件格式分析symfony2学习笔记之系统路由详解symfony2学习笔记之控制器用法详解symfony2学习笔记之模板用法详解symfony2安装第三方bundles实例详解symfony2函数用法实例分析
http://www.bkjia.com/phpjc/1111901.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/1111901.htmltecharticlesymfony2联合查询实现方法，symfony2联合查询 本文实例讲述了symfony2联合查询实现方法。分享给大家供大家参考，具体如下： 1.yml文件 acme\ms...