Simplest way to populate select list from a taxonomy vocabulary

By creativepragmatic on 13 Sep 2012 at 18:04 UTC

I am currently working on a custom registration form module. While there are a lot of posts about this, none of them really provide a clear picture of how to populate a select list from taxonomy terms programmatically.

The machine name of the taxonomy terms is 'cities'. Here is the code so far:

  $form['cities'] = array(
    '#type' => 'select',
    '#title' => t('Click on your city'),
    '#multiple' => true,
    '#options' => ???,
    '#description' => t('Click on one or more cities.'),
  );

Comments

just insert a field in the

shyamsukhamit commented 13 September 2012 at 18:10

just insert a field in the form select the type as term refernce and then select the taxonomy term as city.
the field is populate...

I do not have extensive

creativepragmatic commented 13 September 2012 at 20:49

I do not have extensive module development experience so I am not sure how to express this in PHP code. Is this what you mean?

  $form['cities'] = array(
    '#type' => 'term reference',
    '#taxonomy' => 'cities',
    '#title' => t('Click your city'),
    '#multiple' => true,
    '#required' => TRUE,
  );

me too don't have module

shyamsukhamit commented 14 September 2012 at 02:58

me too don't have module development experience , but as the term reference are multiple I think there should be some kind of loop to fetch all the values..

sorry If I am wrong..

This is what I ended up

creativepragmatic commented 14 September 2012 at 15:55

This is what I ended up with:

  $cities = db_query("SELECT tid, name FROM {taxonomy_term_data} WHERE vid = 1")->fetchAllKeyed();
  
  $form['cities'] = array(
    '#type' => 'select',
    '#title' => t('Click on your city'),
    '#multiple' => true,
    '#options' => $cities,
    '#description' => t('Click on one or more cities.'),
  );

I hoped to find a function that would take the machine name of the taxonomy term and return results that match the query. I checked the taxonomy functions but didn't find anything that would do this. Is there a more elegant way of expressing this?

It doesn't help with the

henrikakselsen commented 17 September 2012 at 09:15

It doesn't help with the name/id thing, but there is a function called taxonomy_get_tree that is helpful with this kind of things so you don't have to query the db yourself.

_{Henrik Akselsen | frontkom | Twitter: @FrontHenrik}

That's why I couldn't find a

creativepragmatic commented 17 September 2012 at 16:40

That's why I couldn't find a function in Drupal Core. I was being too specific in my search. taxonomy_get_tree is a more generic function than what I was searching for. Thank you for taking the time to explain that Henrik.

Here's how to do it in Drupal

davidwhthomas commented 16 March 2014 at 07:10

Here's how to do it in Drupal 7, for those looking:

// Populate FAPI select box from vocabulary term values.
// In this case term_reference field is field_category
$form = array();
$form['category_default'] = array(
  '#type' => 'select',
  '#title' => t('Default category'),
  '#options' => taxonomy_allowed_values(field_info_field('field_category')),
  '#description' => t('The selected category will be shown by default on listing pages.')
);
return $form;

Thanks for updating an old thread!

tgshannon commented 28 May 2014 at 18:55

I was just looking for a solution and found the answer in your recent post. THANKS!

So useful code in most of

er.pushpinderrana commented 29 May 2014 at 08:34

So useful code in most of cases.

Thank you for sharing this nice solution.

Pushpinder Rana #pushpinderdrupal
Acquia Certified Drupal Expert

select in an API form

manuel_mra commented 31 July 2014 at 15:39

Thanks.
It's easy to do it ... with help ...

Manuel Ruiz Alvarez
Lima - Perú
South America

Excellent and consise

DrCord commented 21 August 2014 at 16:44

Thanks for this snippet, it is exactly what the doctor ordered, clean and to the point.

Thanks

manuel_mra commented 11 September 2014 at 12:57

By this way it was easy to solve filling a select list in an API form.
Thank you.

Manuel Ruiz Alvarez
Lima - Perú
South America

And It's taxonomy_form() In D6

emanaton commented 23 October 2014 at 01:23

In case anyone else was looking for the Drupal 6 version of this answer:

<?php
$vid = variable_get('my_stored_vid', FALSE);
$form['category_default'] = taxonomy_form($vid);
unset($form['category_default']['#weight']);
$form['category_default']['#title'] = t('Default category');
$form['category_default']['#default_value'] = variable_get('category_default', 0);
$form['category_default']['#description'] = t('The selected category will be shown by default on listing pages.');
?>

It doesnt work for me

aguchoca commented 27 May 2015 at 16:18

I already have my taxonomy vocabulary but it does return an empty array ?

any advice ?

Thanks

This is working for me..

chippyjacob commented 31 January 2018 at 07:02

This is working for me...Thank you

Use autocmplete for a FAPI

manuel_mra commented 4 December 2015 at 22:33

I have found this link that helped me a lot : http://drupal.stackexchange.com/questions/78899/display-a-taxonomy-terms...

Manuel Ruiz Alvarez
Lima - Perú
South America

<?phptaxonomy_get_tree($vid);

jlongbottom commented 7 December 2015 at 15:58

$terms = taxonomy_get_tree($vid);

building elegant solutions efficiently

$results = db_query("SELECT

pramodk commented 31 May 2016 at 09:16

  $results = db_query("SELECT tid, name FROM {taxonomy_term_data} WHERE vid = 1")->fetchAll();

$options = array();

foreach($results  as $key=>$value){
$options[$key] = $vlaue;
}

$form['cities'] = array(
    '#type' => 'select',
    '#title' => t('Click on your city'),
    '#multiple' => true,
    '#options' => $options,
    '#description' => t('Click on one or more cities.'),
  );

This does not works for me..

chippyjacob commented 26 February 2018 at 12:12

This does not works for me..Anyway thank you

helper function

berramou commented 28 February 2018 at 00:17

- try this function to get vocabulary and pass it to options :

/**
 * @return array of all vocabulary of city taxonomy
 *
 */
function _get_cities_helper_function(){
  $options = array();
  $vid = taxonomy_vocabulary_machine_name_load('cities')->vid;
  $options_source = taxonomy_get_tree($vid);
  foreach($options_source as $item ) {
    $key = $item->tid;
    $value = $item->name;
    $options[$key] = $value;
  }
  return $options;
}

Simplest way

karthid commented 23 April 2019 at 05:23

$options = db_query("SELECT tid, name FROM {taxonomy_term_data} WHERE vid = 1")->fetchAllKeyed(0,1);

$form['cities'] = array(
    '#type' => 'select',
    '#title' => t('Click on your city'),
    '#multiple' => true,
    '#options' => $options,
    '#description' => t('Click on one or more cities.'),
  );