StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCakePHP is updating when it should be inserting a HasAndBelongsToMany model
text
Body
copied!<p>I have a small problem. I am making a site that has Tags and Questions. I have a Question model, Tag model, QuestionsTag model, everything fits together nicely. The user upon asking something puts the tags in the field seperated by a space (foo bar baz) much like on stackoverflow.com.</p> <p>Now, here is the code to check if a tag already exists or not and entering the tag into the database and the required associations:</p> <pre><code> function create () { if (!empty($this->data)) { $this->data['Question']['user_id'] = 1; $question = $this->Question->save ($this->data); /** * Preverimo če se je vprašanje shranilo, če se je, * vprašanje označimo. */ if ($question) { $tags = explode (' ', $this->data['Question']['tags']); foreach ($tags as $tag){ if (($tagId = $this->Tag->existsByName($tag)) != false) { /** * Značka že obstaja, torej samo povezemo trenuten * id z vprašanjem */ $this->QuestionsTag->save (array( 'question_id' => $this->Question->id, 'tag_id' => $tagId )); } else { /** * Značka še ne obstaja, jo ustvarimo! */ $this->Tag->save (array( 'name' => $tag )); // Sedaj pa shranimo $this->QuestionsTag->save(array( 'question_id' => $this->Question->id, 'tag_id' => $this->Tag->id )); $this->Tag->id = false; } ; } } } } </code></pre> <p>The problem is this, a Question has an id of 1 and I want it to have the tags with id of 1, 2, 3.</p> <p>When the 2nd and 3rd save get called, Cake sees that in the questions_tags table is already a question with id 1, so it just updates the tag.</p> <p>But this is not correct, as there should be many questions in that table with the same id, as they refer to different tags belonging to them.</p> <p>So, is there a way to prevent this? Prevent the save method from UPDATEing?</p> <p>Thank you!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload