Assuming this is a HABTM relationship, you would just need to query the
following model then look in the follower relationship to see if the
users ID exists.
YES this is exactly what I want to achieve, but I'm really new to PHP/Cake,
I can't figure out how to check this.
My user array looks like :
*/app/Controller/UsersController.php* (line *28*)
array(
'User' => array(
'password' => '*****',
'id' => '1',
'username' => 'testuser',
'email' => '@',
'hash' => '',
'created' => '2012-06-12 20:49:06'
),
'Following' => array(
(int) 0 => array(
'password' => '*****',
'id' => '2',
'username' => 'anotertest',
'email' => '@',
'hash' => '',
'created' => '2012-06-13 21:03:01',
'UsersUser' => array(
'id' => '23',
'follower_id' => '1',
'following_id' => '2'
)
),
(int) 1 => array(
'password' => '*****',
'id' => '3',
'username' => 'test',
'email' => 'test',
'hash' => '',
'created' => '0000-00-00 00:00:00',
'UsersUser' => array(
'id' => '24',
'follower_id' => '1',
'following_id' => '3'
)
)
),
'Follower' => array(
(int) 0 => array(
'password' => '*****',
'id' => '2',
'username' => 'anotertest',
'email' => '@',
'hash' => '',
'created' => '2012-06-13 21:03:01',
'UsersUser' => array(
'id' => '26',
'follower_id' => '2',
'following_id' => '1'
)
)
)
)
Le jeudi 14 juin 2012 14:40:16 UTC+2, JonStark a écrit :
>
> I have a table with the following fields :
>
> id follower_id following_id
>
> So when a user clicks "follow" on an other user's profile, an entry like
> this is created :
>
> 15 1 3
>
> meaning user with id 1 follows user with id 3.
>
> If user 3 follows 1, then an entry like
>
> 16 3 1
>
> is created.
>
> But, in order to prevent users for following many time a same user,
> leading to entry such as :
>
> 17 3 1
> 18 3 1
> 19 3 1
>
> and so on, I want to replace "follow" by "unfollow" if the entry is
> already saved.
>
> So my question is : how can i "scan" the table to check if an entry as
> both X as follower_id AND Y as following_id ?
>
> 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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
