Returning records from 3 tables via a Join Table with Propel in Symfony

Posted by Jon Winstanley on Stack Overflow See other posts from Stack Overflow or by Jon Winstanley
Published on 2010-03-14T23:24:42Z Indexed on 2010/03/15 13:09 UTC
Read the original article Hit count: 235

Filed under:

symfony

|

propel

|

sql

|

php

I have 3 database tables:

article
article_has_tag (2 FK's to the other tables)
tag

I currently show a list of articles with the article's tags shown underneath but the number of queries grows as the list gets longer.

I want to loop over all the articles and get the tag objects from each one in turn.

Can it be done in 1 propel query?

© Stack Overflow or respective owner

Related posts about symfony

Symfony/Doctrine/SfGuardPlugin: Redirect to requested page (route), and not referrer

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to be able to take the user to the requested page after login, but this does not happen with sfGuard. ** My Register action requires SignIn ;) ** On the listing page [http://cim/frontend_dev.php/] - user clicks the 'Register' link [@register = register/index] - user is taken to 'Signin' page… >>> More
Symfony and doctrine searchable sfDoctrinePager (symfony 1.4)

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone help me on paginating results with sfDoctrinePager? $articlesResults = Doctrine::getTable('Article') ->getTemplate('Doctrine_Template_I18n') ->getPlugin() … >>> More
Seems doctrine listener is not fired

as seen on Stack Overflow - Search for 'Stack Overflow'
Got a service which should be executed the moment an object is persisted. Though, I think the code looks like it should work, it doesn't. I configured the service like the following yml. services: bla_orm.listener: class: Bla\OrmBundle\EventListener\UserManager arguments:… >>> More
Ubuntu 13.10 Symfony installation date time issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm installing Symfony on my Ubuntu system, everything was going fine until the very last moment when I was met with a screen that said: ContextErrorException: Warning: date_default_timezone_get(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone… >>> More
Propel-load-data is causing an error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to load fixtures but myproject is erroring at the CLI and starting the indexer process. I have tried: Rebuilding the schema and model Emptying the database and starting again Clearing the cache Validating the YML file and trying much simpler data-dumps My platform is Symfony 1.0… >>> More

Related posts about propel

Using Propel ORM in my own custom classes

as seen on Stack Overflow - Search for 'Stack Overflow'
I am refactoring a few classes I wrote a while ago, into my Symfony project (v1.3.2 with Propel ORM). The classes originally used direct connections to the database, I want to refactor those classes (stored in $(SF_LIB_DIR)) so that I can call propel and also use the ORM objects. To clarify, So… >>> More
Should I choose Doctrine 2 or Propel 1.5/1.6, and why?

as seen on Programmers - Search for 'Programmers'
I'd like to hear from those who have used Doctrine 2 (or later) and Propel 1.5 (or later). Most comparisons between these two object relational mappers are based on old versions -- Doctrine 1 versus Propel 1.3/1.4, and both ORMs went through significant redesigns in their recent revisions. For example… >>> More
Propel Single Table Inheritance Issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table called "talk", which is defined as abstract in my schema.xml file. It generates 4 objects (1 per classkey): Comment, Rating, Review, Checkin It also generates TalkPeer, but I couldn't get it to generate the other 4 peers (CommentPeer, RatingPeer, ReviewPeer, CheckinPeer), so I created… >>> More
Zend Framework :: ORM - doctrine / propel over Zend_Db_Table

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys, do anyone suggest using an external ORM like Doctrine/Propel over the defualt Zend_Db_Table in Zend Framework ? I think your answers with reasons would be valuable across the ZF community. -DevD >>> More
Zend_Form Creation for Propel Objects

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently working on a project where I use Zend Framework with Propel. I'm looking for something that'll create Zend_Forms for Propel objects, preferably in a similar way to django's modelforms Is there anything out there that does this already, and if not, what would be the best way to go about… >>> More