Symfony2聯集查詢實現方法，symfony2聯集查詢_PHP教程

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...

