StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>It seems, that you are trying to manually create/update records for M:N relation. This isn't needed, because Dotrine ORM will create or delete these records in middle table for M:N relation automatically.</p> <ul> <li><p>Check, that you have correct relations in your database structure. You can visualize your database structure in some database modeling application, like <a href="https://www.mysql.com/products/workbench/" rel="nofollow">Mysql Workbench</a>.</p></li> <li><p>Map correctly your database structure to doctrine config files. Reverse engineering of your database may help: <a href="http://symfony.com/doc/current/cookbook/doctrine/reverse_engineering.html" rel="nofollow">http://symfony.com/doc/current/cookbook/doctrine/reverse_engineering.html</a> In doctrine config file "User.orm.xml" should be <em>many-to-many</em> relation. For example:</p></li> </ul> <pre><code> <many-to-many field="cityId" target-entity="City" inversed-by="userId"> <join-table name="user_has_city"> <join-columns> <join-column name="id_user" referenced-column-name="id_user"/> </join-columns> <inverse-join-columns> <join-column name="city_id" referenced-column-name="city_id"/> </inverse-join-columns> </join-table> </many-to-many> </code></pre> <ul> <li><p>Add __toString() method to your City entity:</p> <p> <pre><code>//...some code of entity... public function __toString() { return $this->name; //or $this->title, $this->label etc. - based on the name of variable, which stores the city's name. } </code></pre></li> <li><p>In file AcmeExampleBundle/Admin/UserAdmin.php:</p> <p> <pre><code>$formMapper ->add('cityId', 'sonata_type_model', array( 'required' => false, 'label' => $this->trans('City name'), 'expanded' => true, )); </code></pre></li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload