Doctrine 2 and Many-to-many link table with an extra field

by

A Many-To-Many association with additional values is not a Many-To-Many, but is indeed a new entity, since it now has an identifier (the two relations to the connected entities) and values.

That’s also the reason why Many-To-Many associations are so rare: you tend to store additional properties in them, such as sorting, amount, etc.

What you probably need is something like following (I made both relations bidirectional, consider making at least one of them uni-directional):

Product:

namespace Entity;

use Doctrine\ORM\Mapping as ORM;

/** @ORM\Table(name="product") @ORM\Entity() */
class Product
{
    /** @ORM\Id() @ORM\Column(type="integer") */
    protected $id;

    /** ORM\Column(name="product_name", type="string", length=50, nullable=false) */
    protected $name;

    /** @ORM\OneToMany(targetEntity="Entity\Stock", mappedBy="product") */
    protected $stockProducts;
}

Store:

namespace Entity;

use Doctrine\ORM\Mapping as ORM;

/** @ORM\Table(name="store") @ORM\Entity() */
class Store
{
    /** @ORM\Id() @ORM\Column(type="integer") */
    protected $id;

    /** ORM\Column(name="store_name", type="string", length=50, nullable=false) */
    protected $name;

    /** @ORM\OneToMany(targetEntity="Entity\Stock", mappedBy="store") */
    protected $stockProducts;
}

Stock:

namespace Entity;

use Doctrine\ORM\Mapping as ORM;

/** @ORM\Table(name="stock") @ORM\Entity() */
class Stock
{
    /** ORM\Column(type="integer") */
    protected $amount;

    /** 
     * @ORM\Id()
     * @ORM\ManyToOne(targetEntity="Entity\Store", inversedBy="stockProducts") 
     * @ORM\JoinColumn(name="store_id", referencedColumnName="id", nullable=false) 
     */
    protected $store;

    /** 
     * @ORM\Id()
     * @ORM\ManyToOne(targetEntity="Entity\Product", inversedBy="stockProducts") 
     * @ORM\JoinColumn(name="product_id", referencedColumnName="id", nullable=false) 
     */
    protected $product;
}

More Related Contents:

  1. How to set up entity (doctrine) for database view in Symfony 2
  2. Query on a many-to-many relationship using Doctrine with Symfony2
  3. How can I use DATE() in Doctrine 2 DQL?
  4. Join subquery with doctrine 2 DBAL
  5. Search engine PHP return error [closed]
  6. UTF-8 all the way through
  7. SQL injection that gets around mysql_real_escape_string()
  8. Can I mix MySQL APIs in PHP?
  9. How to include a PHP variable inside a MySQL statement
  10. MySQL query to get column names?
  11. How do you connect to multiple MySQL databases on a single webpage?
  12. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  13. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  14. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  15. Insert/update helper function using PDO
  16. How can I write SQL for a table that shares the same name as a protected keyword in MySql? [duplicate]
  17. MySQLi count(*) always returns 1
  18. Using Mysqli bind_param with date and time columns?
  19. WAMP/MySQL errors not in correct language
  20. Get Updated Value in MySQL instead of affected rows
  21. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  22. Can I blindly replace all mysql_ functions with mysqli_?
  23. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given [duplicate]
  24. return multiple response data in one response
  25. Storing datetime as UTC in PHP/MySQL
  26. How to backup MySQL database in PHP?
  27. Convert Time String to Decimal Hours PHP [closed]
  28. How do i search from serialize field in mysql database?
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment