profile_autocomplete

• Drupal 5
• Drupal 6
• Drupal 7

Versions

5 – 7

profile_autocomplete($field, $string)

Callback to allow autocomplete of profile text fields.

Code

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

<?php
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_query_range("SELECT value FROM {profile_value} WHERE fid = :fid AND LOWER(value) LIKE LOWER(:value) GROUP BY value ORDER BY value ASC", 0, 10, array(
      ':fid' => $field,
      ':value' => $string . '%',
    ))->fetchCol();
    foreach ($values as $value) {
      $matches[$value] = check_plain($value);
    }
  }

  drupal_json_output($matches);
}
?>

Login or register to post comments