Re: Saving HABTM erases existing records...

Here's an old article the relates to 1.3 (we have used this behaviour on sites and it works) that you might be able able to amend for 2.0 or Google a more recent example. Or, follow the example on the cookbook that changes the relationships from habtm to hasMany - belongsTo - hasMany.

Jeremy Burns

Class Outfit

http://www.classoutfit.com

On 1 May 2012, at 11:09:14, JonStark wrote:

I justs checked that out, but how can I change this behaiour ?

Le mardi 1 mai 2012 12:02:08 UTC+2, JonStark a écrit :

Hello,

I currently having a problem achieving a follower system with HABTM.

In a word, my relationships seem to be well set up :

User HABTM Follower , and in my join table (users_uers) I have the tables  ID (auto increment) user_id and follower_id

I have a button "follow this user" :

<!--Follow-->

<?php 

echo $this->Form->create('User', array(

'action' => 'follow',

));

echo $this->Form->input('id', array(

'type' => 'hidden',

'value' => $user['User']['id'],

));

echo ("<input type='submit' class='btn btn-primary' value='Follow'>"); ?></td>

</form><!--End form-->

With this in the controller :

public function follow() {

        $this->User->set($this->data);

        if ($this->request->is('post')) {

        $this->request->data['Follower']['follower_id'] = $this->Auth->user('id');

        $this->User->save($this->request->data);

        $this->Session->setFlash(__('You are now following this user.'));

        $this->redirect(array('controller' => 'users', 'action' => 'index'));

        }

    }

I tough this would work ace, and it semmly did, but I have since understood that when saving a new relationship, Cake erases all previous existing one...

So if 1 followed by 3, when 3 follows 1 it erases the previous relation... In a word, it cannot work properly for a follower system.

I tough that adding the auto increment ID colums would prevent this, but I was wrong... so how can I save HABTM NEX relationships without erasing previous ones ? Is there a better solution for a follower system ? Thanks a lot.

 

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php