Inserting into DB with Doctrine and Symfony - foreign key doesn't insert

Question

I use Symfony with Doctrine and I try to insert data into DB. In my table messages there's one column user_id which is set as foreign key to users.id. In my Message entitity there's this setter for user_id

/**
 * @ORM\Entity
 * @ORM\Table(name="Messages")
 */
class Message {

    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /**
     * @ORM\Column(name="user_id", type="integer")
     */
    protected $user_id;

    /**
     * @ORM\Column(name="text", type="text")
     */
    protected $text;

    /**
     * @ORM\ManyToOne(targetEntity="User")
     * */
    protected $user;

    public function setText($text) {
        $this->text = $text;
    }

    public function getText() {
        return $this->text;
    }

    public function setUserId($user_id) {
        $this->user_id = $user_id;
    }

    public function getUser_id() {
        return $this->user_id;
    }

    public function getUser() {
        return $this->user;
    }
}

However it doesn't insert variable passed to my setter but NULL. Every other colums are filled with correct data while INSERTing just this one is not. I suppose it has something to do with the foreign key (there are proper data present in table users).

Part of controller code:

if ($request->getMethod() == 'POST') {
            $form->bind($request);
            if ($form->isValid()) {
                if ($isLogged) {
                    $user = $this->get('security.context')->getToken()->getUser();
                    $message->setUserId($user->getId());
                }
                $em->persist($message);
                $em->flush();

When I change the setter to this it's inserted properly :

    public function setUserId($user_id) {
         $this->random_column_which_is_not_foreignkey = $user_id;
    }

What's wrong? Thanks

Please update with the parts of the code that persist the entities — skrilled
– skrilled, Commented Oct 24, 2013 at 23:53

Ahmed Siouani · Accepted Answer · 2013-10-25 12:23:22Z

You need to use JoinColumn.

Try this:

/**
 * @ORM\Entity
 * @ORM\Table(name="Messages")
 */
class Message {

    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /**
     * @ORM\Column(name="text", type="text")
     */
    protected $text;

    /**
     * @ORM\ManyToOne(targetEntity="User")
     * @ORM\JoinColumn(name="user_id")
     */
    protected $user;

    public function setText($text) {
        $this->text = $text;
    }

    public function getText() {
        return $this->text;
    }

    public function setUser($user) {
        $this->user = $user;
    }

    public function getUser() {
        return $this->user;
    }
}

And in your controller:

if ($request->getMethod() == 'POST') {
    $form->bind($request);
    if ($form->isValid()) {
        if ($isLogged) {
            $user = $this->get('security.context')->getToken()->getUser();
            $message->setUser($user);
        }
        $em->persist($message);
        $em->flush();
        // ...

Collectives™ on Stack Overflow

Inserting into DB with Doctrine and Symfony - foreign key doesn't insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related