Databases
StackOverflow2013
Postsdbo
POHow to define an n-m relation in doctrine?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to define an n-m relation in doctrine?
    primarykey
    data
    text
    <p>If got a table "Article" and a table "Tags". Articles can have multiple tags and tags can hang to multiple articles.</p> <p>The class BaseArticle looks like this:</p> <pre><code>abstract class BaseArticle extends Doctrine_Record { public function setTableDefinition() { $this-&gt;setTableName('article'); $this-&gt;hasColumn('article_id', 'integer', 8, array( 'type' =&gt; 'integer', 'length' =&gt; 8, 'fixed' =&gt; false, 'unsigned' =&gt; false, 'primary' =&gt; true, 'autoincrement' =&gt; true, )); $this-&gt;hasColumn('title', 'string', null, array( 'type' =&gt; 'string', 'fixed' =&gt; false, 'unsigned' =&gt; false, 'primary' =&gt; false, 'notnull' =&gt; false, 'autoincrement' =&gt; false, )); $this-&gt;hasColumn('text', 'string', null, array( 'type' =&gt; 'string', 'fixed' =&gt; false, 'unsigned' =&gt; false, 'primary' =&gt; false, 'notnull' =&gt; false, 'autoincrement' =&gt; false, $this-&gt;hasColumn('url', 'string', 255, array( 'type' =&gt; 'string', 'length' =&gt; 255, 'fixed' =&gt; false, 'unsigned' =&gt; false, 'primary' =&gt; false, 'notnull' =&gt; false, 'autoincrement' =&gt; false, )); } public function setUp() { parent::setUp(); $this-&gt;hasMany('Tag as Tags', array( 'local' =&gt; 'article_id', 'foreign'=&gt;'tag_id', 'refClass'=&gt;'Articletag') ); } </code></pre> <p>}</p> <p>The BaseTag-class like this:</p> <pre><code>abstract class BaseTag extends Doctrine_Record { public function setTableDefinition() { $this-&gt;setTableName('tag'); $this-&gt;hasColumn('tag_id', 'integer', 4, array( 'type' =&gt; 'integer', 'length' =&gt; 4, 'fixed' =&gt; false, 'unsigned' =&gt; false, 'primary' =&gt; true, 'autoincrement' =&gt; true, )); $this-&gt;hasColumn('name', 'string', null, array( 'type' =&gt; 'string', 'fixed' =&gt; false, 'unsigned' =&gt; false, 'primary' =&gt; false, 'notnull' =&gt; false, 'autoincrement' =&gt; false, )); } public function setUp() { parent::setUp(); $this-&gt;hasMany('Article as Articles', array( 'local' =&gt; 'tag_id', 'foreign'=&gt;'article_id', 'refClass'=&gt;'Articletag') ); } </code></pre> <p>}</p> <p>And the relationship class like this:</p> <pre><code> abstract class BaseArticletag extends Doctrine_Record { public function setTableDefinition() { $this-&gt;setTableName('articletag'); $this-&gt;hasColumn('article_id', 'integer', 8, array( 'type' =&gt; 'integer', 'length' =&gt; 8, 'fixed' =&gt; false, 'unsigned' =&gt; false, 'primary' =&gt; true, 'autoincrement' =&gt; false, )); $this-&gt;hasColumn('tag_id', 'integer', 4, array( 'type' =&gt; 'integer', 'length' =&gt; 4, 'fixed' =&gt; false, 'unsigned' =&gt; false, 'primary' =&gt; true, 'autoincrement' =&gt; false, )); } public function setUp() { parent::setUp(); } } </code></pre> <p>When I try to get a property from the article all goes well by using:</p> <pre><code> $article = Doctrine_Query::create()-&gt;from('Article a') -&gt;where('id = ?' , 1) -&gt;fetchOne(); echo $article-&gt;title; //gives me the title </code></pre> <p>But when I try this:</p> <pre><code> foreach($article-&gt;Tags as $tag) { echo($tag-&gt;name) } </code></pre> <p>I get an error:</p> <pre><code>Unknown record property / related component "Tags" on "Article" </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmurze
    1. USmurze
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to define an n-m relation in doctrine?
      1. USmurze
      1. VTBountyStart
    2. VO
      singulars
      1. POHow to define an n-m relation in doctrine?
      1. USShane O'Grady
      1. VTFavorite
    3. VO
      singulars
      1. POHow to define an n-m relation in doctrine?
      1. This table or related slice is empty.
      1. VTDownMod
    1. COafter reading the documentation and going over numerous examples I still can't find the problem. Could it be that n-m relations are broken in Doctrine 1.2.1?
      singulars
      1. POHow to define an n-m relation in doctrine?
      1. USmurze
    2. COMany to Many relations aren't broken, I use them on a daily basis. Using the code I provided in my answer should work ... Oh by the way, does it works if you replace "article_id" and "tag_id" with a simple "id" in the hasColumn() call ?
      singulars
      1. POHow to define an n-m relation in doctrine?
      1. USDuoSRX
 

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.

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