Posts tagged doctrine 2

Doctrine 2 – Use foreign key as field in DQL

12 years ago

by Pieter Vogelaar in PHP

In doctrine 2 there are by default no foreign key fields a ID. For example your “product” entity might have a “shop” property, but no “shopId” property.

To get all the products that belong to a shop you would always have to make a join like this:

/* @var $em \Doctrine\ORM\EntityManager */ $result = $em->createQuery("SELECT p FROM My\Entity\Product p JOIN p.shop s WHERE s.id = :shopId" )->setParameter('shopId', 1) ->getOneOrNullResult();

But in certain situations it would be nice to use the foreign key column directly, in this case “shopId”. That More >

doctrine 2 dql foreign key field

Doctrine 2 i18n translatable extension

12 years ago

by Pieter Vogelaar in PHP

Doctrine 2 doesn’t have an i18n (internationalization) behaviour in the core anymore like Doctrine 1 had.

But luckily for us, Gediminas Morkevičius build the translatable behavior extension for Doctrine 2. Translatable behavior offers a very handy solution for translating specific record fields in diferent languages. Further more, it loads the translations automatically for a locale currently used, which can be set to a translatable listener on it’s initialization or later for other cases through the Entity itself.

Checkout the website: http://gediminasm.org/article/translatable-behavior-extension-for-doctrine-2

doctrine 2 i18n translatable behaviour