Home > Backend Development > PHP Tutorial > Symfony2联合查询实现方法_php实例

Symfony2联合查询实现方法_php实例

WBOY
Release: 2016-06-07 17:08:42
Original
723 people have browsed it

本文实例讲述了Symfony2联合查询实现方法。分享给大家供大家参考,具体如下:

1.yml文件

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

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

Copy after login

1

2

3

4

5

6

7

Acme\MspadminBundle\Entity\MspChannel:

 type: entity

 table: msp_channel

 oneToMany:

   Articles:

    targetEntity: MspArticle

    mappedBy: Channel

Copy after login

1

2

3

4

5

6

7

Acme\MspadminBundle\Entity\MspUser:

 type: entity

 table: msp_user

 oneToMany:

   Userone:

    targetEntity: MspArticle

    mappedBy: User

Copy after login

2.查询代码:

1

2

3

4

5

$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();

Copy after login

希望本文所述对大家基于Symfony框架的PHP程序设计有所帮助。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template