Can you post what your models look like please ?
On 14/06/12 14:00, JonStark wrote:
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
--
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
