function profile_autocomplete

Callback to allow autocomplete of profile text fields.

File

modules/profile/profile.pages.inc, line 118

Code

function profile_autocomplete($field, $string) {
    $matches = array();
    $autocomplete_field = (bool) db_query_range("SELECT 1 FROM {profile_field} WHERE fid = :fid AND autocomplete = 1", 0, 1, array(
        ':fid' => $field,
    ))->fetchField();
    if ($autocomplete_field) {
        $values = db_select('profile_value')->fields('profile_value', array(
            'value',
        ))
            ->condition('fid', $field)
            ->condition('value', db_like($string) . '%', 'LIKE')
            ->groupBy('value')
            ->orderBy('value')
            ->range(0, 10)
            ->execute()
            ->fetchCol();
        foreach ($values as $value) {
            $matches[$value] = check_plain($value);
        }
    }
    drupal_json_output($matches);
}