Access custom user field from a different account

Question

The following works so far:

1. I can set a custom user field e.g. 'full_name' in Drupal Account Settings

2. The logged in user has access to this field using the following code.

   global $user; $user = user_load($user->uid); // Fully load the user object $custom_vars['full_name'] = $user->field_full_name[LANGUAGE_NONE][0]['value']; echo "My full name is : $custom_vars['full_name']";

This is what I want to do:

• I want to log in as an admin account and for a specific group of
  users who's unique IDs know I want to display this field.
• So perhaps for userID = (1234, 1175, 14532) I want to see this value for 'full_name', how do I do it?

I am hoping for a PHP solution that uses code similar to the above rather than a SQL DB call, but if I need to directly access the DB so be it.

Answer 1

This seems a bit dirty, but using your exact code as a base, something like the following may work:

$uids = array(
  // Here is the list of user ID's that you know.
);

$full_names = array();

foreach ($uids AS $uid){
  $account = user_load($uid);
  $full_names[$uid] = $account->field_full_name[LANGUAGE_NONE][0]['value'];
}

unset($account);

return $full_names;

This will give you an array of full usernames keyed by the UID.

Also to bear in mind, this performs no access checking or permission checking.

For further reading, you might want to try taking a look at something like field_get_items() as well.

Answer 2

I would investigate the user_load_multiple() function, which would allow you to do something like this:

$user_ids = array(1234, 1175, 14532);

$accounts = user_load_multiple($user_ids);

which would return an array of user objects keyed by their user id, so you would now have access to the field as:

$accounts[UID]->field_name_etc_etc_etc

If you want to simply it further, that's up to you as the rest is just PHP.

Answer 3

3 years later this is my analysis:

  $query = new EntityFieldQuery();
  $query->entityCondition('entity_type', 'user')
    //    ->propertyCondition('uid', array(21,22,23,24), 'IN')
    ->propertyCondition('status', 1);

  $result = $query->execute();
  if (isset($result['user'])) {
    $news_items_nids = array_keys($result['user']);
    $news_items = entity_load('user', $news_items_nids);
  }

Time: 6.16s

$total_users = entity_load('user', FALSE, array('status' => 1));

Time: 6.00s

$local_user = db_query('SELECT u.uid, u.name, fn.field_last_name_value FROM users as u INNER JOIN field_data_field_last_name  as fn ON u.uid = fn.entity_id WHERE u.status = 1')->fetchAll();

Time: 3.63s

Total users: 1184