Count the number of followers and print it PHP

Question

I have this in my BD:

following: 12,13,2,4 (this is the user id of the following list of one user)

and I want to count how many followers has a single user.

I have this code:

  $followers = $db->fetch_field($db->simple_select('users', 'COUNT(*) AS followers' , "buddylist IN ($useruid) "), 'followers');
  $Followers = $followers;

This only works if the first number of the list is the same that $useruid. Example:

$useruid = 1, buddylist = 3,2,1

$followers = $db->fetch_field($db->simple_select('users', 'COUNT(*) AS followers' , "buddylist IN ($useruid) "), 'followers');
      $Followers = $followers;

the out put its 0

if buddylist is 1,2,3

the output is one.

What's wrong? :(

Do you want a PHP solution? Return the string, explode by comma and count bits, otherwise a SQL solution would need to do something similar — scrowler, Aug 29 '14 at 02:27

score 0 · Accepted Answer · edited May 23 '17 at 12:27

You could use FIND_IN_SET() instead of IN(), since IN will look for the string you compare in a group of structured fields, whereas your field is a comma separated string of IDs. FIND_IN_SET() will look within that string:

$followers = $db->fetch_field(
    $db->simple_select(
        'users',
        'COUNT(*) AS followers',
        "FIND_IN_SET($useruid, buddylist)"
    ),
    'followers'
);

See this related question.

score -1 · Answer 2 · answered Aug 29 '14 at 02:45

-1

It is hard to tell not knowing your DB contents.

I suppose you have users in $useruid as array

convert your array to string by `implode(',',$useruid)` and substitute $useruid before mysql statment

and all should work fine

answered Aug 29 '14 at 02:45

bart

1
2

Count the number of followers and print it PHP

2 Answers2