StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
11059559
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2012-06-15T23:56:35.447
FavoriteCount
0
LastActivityDate
2015-03-02T08:48:21.917
LastEditDate
2015-03-02T08:48:21.917
LastEditorUserId
792690
OwnerUserId
1266661
ParentId
10186185
PostTypeId
2
Score
24
ViewCount
0
LastEditorDisplayName
text
Body
OK, I finally figured out how to do it properly: <pre class="lang-php prettyprint-override"><code>namespace Test\TestBundle\Form; use Symfony\Component\Form\AbstractType; use Symfony\Component\Form\FormBuilder; use Doctrine\ORM\EntityRepository; use Symfony\Component\Form\FormEvents; use Symfony\Component\Form\Event\DataEvent; use Test\TestBundle\Entity\Country; use Test\TestBundle\Entity\State; use Test\TestBundle\Entity\City; class CityType extends AbstractType { public function buildForm(FormBuilder $builder, array $options) { $builder->add('name'); $factory = $builder->getFormFactory(); $refreshStates = function ($form, $country) use ($factory) { $form->add($factory->createNamed('entity','state', null, array( 'class' => 'Test\TestBundle\Entity\State', 'property' => 'name', 'empty_value' => '-- Select a state --', 'query_builder' => function (EntityRepository $repository) use ($country) { $qb = $repository->createQueryBuilder('state') ->innerJoin('state.country', 'country'); if ($country instanceof Country) { $qb->where('state.country = :country') ->setParameter('country', $country); } elseif (is_numeric($country)) { $qb->where('country.id = :country') ->setParameter('country', $country); } else { $qb->where('country.name = :country') ->setParameter('country', null); } return $qb; }) )); }; $setCountry = function ($form, $country) use ($factory) { $form->add($factory->createNamed('entity', 'country', null, array( 'class' => 'TestBundle:Country', 'property' => 'name', 'property_path' => false, 'empty_value' => '-- Select a country --', 'data' => $country, ))); }; $builder->addEventListener(FormEvents::PRE_SET_DATA, function (DataEvent $event) use ($refreshStates, $setCountry) { $form = $event->getForm(); $data = $event->getData(); if ($data == null) { return; } if ($data instanceof City) { $country = ($data->getId()) ? $data->getState()->getCountry() : null ; $refreshStates($form, $country); $setCountry($form, $country); } }); $builder->addEventListener(FormEvents::PRE_BIND, function (DataEvent $event) use ($refreshStates) { $form = $event->getForm(); $data = $event->getData(); if(array_key_exists('country', $data)) { $refreshStates($form, $data['country']); } }); } public function getName() { return 'city'; } public function getDefaultOptions(array $options) { return array('data_class' => 'Test\TestBundle\Entity\City'); } } </code></pre> The jQuery AJAX selector <pre class="lang-js prettyprint-override"><code>$(document).ready(function () { $('#city_country').change(function(){ $('#city_state option:gt(0)').remove(); if($(this).val()){ $.ajax({ type: "GET", data: "country_id=" + $(this).val(), url: Routing.generate('state_list'), success: function(data){ $('#city_state').append(data); } }); } }); }); </code></pre> I hope this will be helpful to somebody else facing the same situation.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POsymfony2 chained selectors
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USDinuka Thilanga
UserOwnerUserId
1. USDavid Barreto
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POsymfony2 chained selectors
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COwhere does the `Routing.generate('state_list'),` come from? where is the controller handling the `state_list` route?
 singulars
 PostPostId
 PO
 UserUserId
 USgondo
2. COHi David, great answer there, just wondering - do you have any idea how to use this created city when you select, for example, an address for a person? So select a country, which refreshes states, select a state, which refreshes cities? I know it's got something to do with Form Events, but it seems to me you need to nest them somehow? I've posted a question regarding this [here](http://stackoverflow.com/questions/20544442/add-event-listener-to-form-element-added-by-event-listener). Any ideas?
 singulars
 PostPostId
 PO
 UserUserId
 USiLikeBreakfast

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.