Symfony2联合查询实现方法
发布:smiling 来源: PHP粉丝网 添加日期:2021-07-18 17:46:50 浏览: 评论:0
这篇文章主要介绍了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程序设计有所帮助。
Tags: Symfony2联合查询
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)