Add HABTM data in controller

Question

In my app, Users HABTM Solicitations.

After saving the form using $this->Solicitation->save($this->request->data), I need to add another user_id value in the solicitations_users table.

$data[] = array('User' => array('id' => 5), 'Solicitation' => array('id' => 77));
$data[] = array('User' => array('id' => 6), 'Solicitation' => array('id' => 77));

  $this->Solicitation->saveMany($data);

My $datais this:

array(
'User' => array(
    'id' => (int) 6
),
'Solicitation' => array(
    'id' => '54'
)
)

I need to save the association in the form and then add the new record above to the solicitations_users table as well. It's only saving the 6 and not the data from the form. It just saves the form if I delete the second save.

I realized that in the DB, this is jumping one id. This should be 'id' 36 => 5; 'id' 37 => 6. It looks like that is updating the table.

Here is the query:

enter image description here

If you could add your model Solicitation than it would be very helpful — Moyed Ansari, Apr 10 '14 at 09:01

score 1 · Answer 1 · answered Mar 17 '14 at 14:24

1

What is your posted data structure like?

According to the cookbook it should be

Array(
    'User' => Array(
        'id' => 6
    ),
    'Solicitation' => Array(
        'title' => 'A request'
    )
)

answered Mar 17 '14 at 14:24

user221931

1,852
1
13
16

Hi!! i posted my `$data` array – Igor Martins Mar 18 '14 at 12:23
Does the user and the solicitation exist before adding the association? You should also check out saveAll() and the other methods together with their requirements. – user221931 Mar 19 '14 at 01:52
Hi!! I found the answer, pls check. – Igor Martins Apr 15 '14 at 13:01

arilia · Answer 2 · 2014-04-15T14:05:12.377

1

When you save an habtm relationship cake delete all the records relative to thet item and rewrite just the ones you are saving.

see the manual about it

So you have to save all your records at the same time providing an array like:

try

$data = array(
    'Solicitation' => array('id' => 77),
    'User' => array(
        'User' => array(6, 7)
    )
);

$this->Solicitation->saveAll($data);

you can also set 'unique' =>'keepExisting' in your habtm association array

edited Apr 15 '14 at 14:05

answered Apr 10 '14 at 10:48

arilia

9,373
2
20
44

This could do with an explanation as to why this fixes the posted problem. – Steve Apr 10 '14 at 11:22
Hi!! I found the answer, pls check. – Igor Martins Apr 15 '14 at 13:00

score 1 · Answer 3 · answered Apr 10 '14 at 16:08

Give one of these two a shot:

$data[] = array('User' => array('id' => 5), 'Solicitation' => array('id' => 77));
$data[] = array('User' => array('id' => 6), 'Solicitation' => array('id' => 77));

$this->Solicitation->saveMany($data, array('deep' => true));

OR

$data[] = array('SolicitationsUser' => array('User.id' => 5,'Solicitation.id' => 77));
$data[] = array('SolicitationsUser' => array('User.id' => 6,'Solicitation.id' => 77));

$this->Solicitation->saveMany($data);

Hi!! I found the answer, pls check. – Igor Martins Apr 15 '14 at 13:00 — Igor Martins, Apr 15 '14 at 13:00

score 1 · Answer 4 · answered Apr 13 '14 at 09:29

1

I think the easiest way is to use foreach. Like-

$data[] = array('User' => array('id' => 5), 'Solicitation' => array('id' => 77));
$data[] = array('User' => array('id' => 6), 'Solicitation' => array('id' => 77));

foreach($data as $da){
  $this->Solicitation->saveMany($da);
}

answered Apr 13 '14 at 09:29

Fazal Rasel

4,446
2
20
31

Hi!! I found the answer, pls check. – Igor Martins Apr 15 '14 at 12:59

score -1 · Accepted Answer · edited May 23 '17 at 12:28

-1

Thanks guys.

But, based on this answer : CakePHP: Creating new HABTM row instead updates other

I found that instead of SaveAll create a new row, It update that already exists with new records. Because of this, i'v used query() to add a new row.

$this->Solicitation->query("INSERT INTO `contratos`.`solicitation_users` (user_id,solicitation_id) values($id, $solicitation");

Thanks for all

edited May 23 '17 at 12:28

Community

1
1

answered Apr 15 '14 at 12:59

Igor Martins

2,015
7
36
57

this is just a workaround because it doesn't use cake syntax imho. – arilia Apr 15 '14 at 13:48
If you see the question i'v cited, there's no way to do this using the `save` methods on Cake – Igor Martins Apr 15 '14 at 13:50
did you try `'unique' =>'keepExisting'` in your association array? – arilia Apr 15 '14 at 14:07

Add HABTM data in controller

5 Answers5