I want to combine tables with multiple foreign keys with the association function of cakephp.

[Environment]
　　PHP 5.3.19
　　Cakephp 2.6.1

Is it possible to associate if there are multiple foreign keys as shown below?

 [hoge_one table]
id,
foreign_code_1,
foreign_code_2,
date,


[hoge_many table]
id,
foreign_code_1,
foreign_code_2,
hoge,
data,
etc

   h The merge key that connects the hoge_many table to hoge_one is:
      Only foreign_code_1, foreign_code_2.(no foreign key added)
   h I would like to associate from hoge_one to hoge_many by hasmany.

Thank you for your cooperation.

php cakephp

2022-09-30 21:12

1 Answers

public$hasMany=array(
    'HogeMany' = > array(
        'foreignKey' = > 'foreign_code_1',
        'conditions' = > array('HogeMany.foreign_code_2' = > 'HogeOne'.foreign_code_2),
    )
);

2022-09-30 21:12

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656