CAKEPHP 3.x-保存在副表中

Question

i具有以下表结构。

Mandator表

class MandatorTable extends Table
{
public function initialize(array $config)
    {
        $this->table('mandators');
        $this->belongsToMany('Seminar', [
            'foreignKey' => 'mandator_id',
            'targetForeignKey' => 'seminar_id',
            'joinTable' => 'mandators_seminars'
        ]);
    }
}

半足球表

class SeminarTable extends Table
{
    public function initialize(array $config)
    {
        $this->table('seminars');
        $this->belongsToMany('Mandator', [
            'foreignKey' => 'seminar_id',
            'targetForeignKey' => 'mandator_id',
            'joinTable' => 'mandators_seminars'
        ]); 
    }   
}

这两个表都属于" mandators_seminars"表

mandator_id，siminar_id

保存数据时，它保存在研讨会表中，而不是在" mandators_seminars"表

中

查询

$seminartable = $this->Seminar->newEntity();
$this->request->data['mandator'][0] = 1;
$seminardata = $this->Seminar->patchEntity($seminartable, $this->request->data);
$this->Seminar->save($seminardata)

请求数据

Array
(
    [bookable] => test
    [released] => aaa
    [linkable] => bb
    [name] => ccc
    [internalnote] => ddd
    [abstract] => ttt
    [description] => ddd
    [Category] => 14
    [mandator] => Array
        (
            [0] => 1
        )
    [mandator_owner_id] => 1
)

Answer 1

看，您有两个表格设备，并且与单数相似，但是您的连接表是复数的。首先检查一下。如果仍然有问题，请通过关联检查此cakephp

您可以看到您的协会应该是这样的：

$this->belongsToMany('Mandator', [
        'foreignKey' => 'seminar_id',
        'targetForeignKey' => 'mandator_id',
        'through' => 'PluginName.MandatorsSeminars'
        'joinTable' => 'mandators_seminars',
        'className' => 'PluginName.Mandator'
    ]); 

还有一个提示：应将表称为复数。