How to get value from custom profile field in moodle in code?

Question

How to get value from custom profile field in moodle?
i want to include the profile field in user.php

Answer 1

If you want to load all the user profile fields, then you can start with a user object

$user = $DB->get_record('user', array('id' => $userid));

and then call

profile_load_custom_fields($user); 

to fill in the $user->profile with an array of all the custom fields.

Alternatively, you can get the contents of a single profile field via:

$sql = "SELECT ud.data 
FROM {user_info_data} ud 
JOIN {user_info_field} uf ON uf.id = ud.fieldid
WHERE ud.userid = :userid AND uf.shortname = :fieldname";
$params = array('userid' =>  $userid, 'fieldname' => 'NameOfCustomField');

$fieldvalue = $DB->get_field_sql($sql, $params);

Note this code is written off the top of my head and untested, so it may have some typos in it.