教义多对多插入

Doctrine Many to Many Insert(教义多对多插入)
本文介绍了教义多对多插入的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一些问题.我正在研究并尝试所有建议,但没有一项工作.

i have some promblem. i was research and try all suggest but no one work.

我最终得到:

传递给 EntityUser::addCategories() 的参数 1 必须是 EntityCategory 的实例,给定字符串,

我有很多关系、用户、user_category 和类别

i have manytomany relationship, user, user_category, and category

用户

<?php

namespace Entity;

use DoctrineCommonCollectionsArrayCollection;

use GedmoMappingAnnotation as Gedmo;
use DoctrineORMMapping as ORM;

/**
 * @Entity
 * @Table(name="user")
 */
class User
{

    /**
     * @Id
     * @Column(type="integer", nullable=false)
     * @GeneratedValue(strategy="AUTO")
     */
    public $id;

    /**
     * @Column(type="string", length=255, unique=true, nullable=false)
     */
    public $name;


    /**
     * @ManyToMany(targetEntity="EntityCategory", inversedBy="user")
     * @ORMJoinTable(name="user_category")
     */
    public $categories;

        public function __construct() {
            $this->category = new DoctrineCommonCollectionsArrayCollection();
    }

    public function getCategories()
    {
        return $this->categories;
    }

    public function addCategories(Category $category = null)
    {
        $this->categories = $category;
    }

    public function setName($name)
    {
        $this->name = $name;
    }
    public function getName()
    {
        return $this->name;
    }

}

类别

<?php

namespace Entity;

use DoctrineCommonCollectionsArrayCollection;

use GedmoMappingAnnotation as Gedmo;
use DoctrineORMMapping as ORM;

/**
 * @Entity
 * @Table(name="category")
 */
class Category
{

    /**
     * @Id
     * @Column(type="integer", nullable=false)
     * @GeneratedValue(strategy="AUTO")
     */
    public $id;

    /**
     * @Column(type="string", length=255, unique=true, nullable=false)
     */
    public $name;

    /**
     * @ManyToMany(targetEntity="EntityUser", mappedBy="category")
     */
    public $user;


    public function __construct() {
        $this->user = new DoctrineCommonCollectionsArrayCollection();
    }

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

    public function addUser(User $user = null)
    {
        $user->addCategory($this);
        $this->user = $user;
    }


    public function setName($name)
    {
        $this->name = $name;
    }
    public function getName()
    {
    return $this->name;
    }
}

插入函数

        // check existence object in database
        $res = $this->em->find('EntityUser', $this->input->post('id'));

        if($res){
            $data = $this->em->find('EntityUser', $this->input->post('id'));
        }else{
            // create a new User object
            $data = new EntityUser;                
        }


        $data->setName($this->input->post('name'));
        $data->addCategories($this->input->post('category'));


        // save the data object to the database
        $this->em->persist($data);

        $this->em->flush();

一切都很顺利,但我对设置工作感到很困惑.

Everything goes fine on get but i'm so confuse for set to work.

感谢您的帮助.对不起我的英语.

thanks for your help. sorry for my english.

推荐答案

你有很多错误(注意语法):

You have lot of errors (pay attention to grammar):

而不是

public $categories;
public function __construct() {
    $this->category = new DoctrineCommonCollectionsArrayCollection();
}

应该是:

protected $categories;

public function __construct() {
    $this->categories = new DoctrineCommonCollectionsArrayCollection();
}

代替:

public $user;
public function __construct() {
    $this->user = new DoctrineCommonCollectionsArrayCollection();
}

使用

protected $users;
public function __construct() {
    $this->users = new DoctrineCommonCollectionsArrayCollection();
}

代替

public function addCategories(Category $category = null)
{
    $this->categories = $category;
}

应该是

public function addCategory(Category $category = null)
{
    $this->categories->add($category);
}

public function removeCategory(Category $category)
{
    $this->categories->removeElement($category) ;
}
public function setCategories($categories)
{
    $this->categories = categories;
}

双方的逻辑相同.我不知道 CI 是如何工作的,但 Symfony 会自动找到 addSomething/removeSomething 方法.即使 CI 不支持该功能,您仍应按上述方式更改代码.

Same logic on both sides. I don't know how CI works but Symfony will automatically find addSomething/removeSomething methods. Even if CI doesn't support that feature, you should still change your code as above.

这篇关于教义多对多插入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Convert JSON integers and floats to strings(将JSON整数和浮点数转换为字符串)
in php how do I use preg replace to turn a url into a tinyurl(在php中,如何使用preg替换将URL转换为TinyURL)
all day appointment for ics calendar file wont work(ICS日历文件的全天约会不起作用)
trim function is giving unexpected values php(Trim函数提供了意外的值php)
Basic PDO connection to MySQL(到MySQL的基本PDO连接)
PHP number_format returns 1.00(Php number_Format返回1.00)