php - Symfony Doctrine QueryBuilder -
I try to change this query to Query Builder:
SELECT * Include invitation from landingpage_sign` as landingpages_content.id as CID LandingPage_ct_centent_id = content.Id is where the content. Enabled = 1and landingpage_site Landing page_id =? ORDER BY LandingPage_sign.order`
This is my QueryBuilder code:
$ queryBuilder - & gt; Select ('*, Landing Page _ content as CID') - & gt; ('LandingPage_saint', 'LandingPage_saint') - & gt; Bayangon ('LandingPage_site content_id', 'content .id', tap) - & gt; Where ('content.enabled = 1') - & gt; And ('Landingpages_content.landingpage_id =: id') - & gt; Setpalmator ('id', $ id) - & gt; Orderbank ('landingpage_sign'. Command '', 'asc');
this return
invalidErmentation exception: query builder can not be included.
you are wrong leftJoin
the method is wrong in this way Do something:
$ querybuilder - & gt; ('LandingPage_content .ID CID as', '') - ('LandingPage_saint', 'LandingPage_saint') - & gt; Left Zones ('(' Content.enabled = 1 ') - & gt; and where (' landingpages_content.landingpage_id =: id '' landingpage_oint content '', 'content', 'on', 'landing page_oint content_id = content.) - & gt; ; Setpamator ('id', $ id) - & gt; orderbase ('landingpage_sign.order', 'asc');
Comments
Post a Comment