By ralfph on

hello,

lately I ave been searching to find a way to load a dynamic list into a list option field.
I found the Webform module which allows one to create a webform in which we can add new fields. I also found a way to load a dynamic list option value by hacking the webform module. I found it on the following website: http://www.designhammer.com/news/providing-dynamic-select-options-to-web...

However this works only if you are creating your own webform along with the fields.

What I want is, for each user I create I would like to assign a department , this department list should be retrieved from the database.
What I managed to do is to create the list option field using the profile module. however for this list option field I want to be able to write a query to retrieve data from database.

anyone with a clue ?

Thank you !

⋅ Categories: Drupal 6.x

Comments

ralfph’s picture

ralfph commented

After you do the following modifications to the profile module you will have the following:

- have an additional field type which is 'Dynamic list selection'
-when you select this option you will be able instead of writing statically your values(as for the list selection) into the options text area, you will rather write you own query into this text area.

an example query(write it within the option text area): SELECT explanation FROM {profile_fields}

NB: the select option field takes only values only if the type of column is 'text', in our case explanation is of type text.

if you rather write: SELECT fid FROM {profile_fields}
you will have empty fields within the select list, since fid is of type int

I will keep it for you to solve this matter, and customize it to your needs.

here you go, follow these steps:

1- enable the 'Profile' module
2- in 'profile.module' file add the following code:

(line 41)

 $output .= '<li>'. t('Dynamic list selection') .'</li>';

line(264)

 case 'DynamicSelection':
        return $browse ? l($value, 'profile/'. $field->name .'/'. $value) : check_plain($value);

line(413)

case 'DynamicSelection': 
       $options = $field->required ? array() : array('--');
		//$options=db_query('SELECT options FROM {profile_fields} WHERE fid= 2', PROFILE_HIDDEN);
       $result = db_query($field->options,PROFILE_HIDDEN);
		 while ($field2 = db_fetch_object($result)) {
		 $options[]=$field2->options;
		 }
        $fields[$category][$field->name] = array('#type' => 'select',
          '#title' => check_plain($field->title),
          '#default_value' => isset($edit[$field->name]) ? $edit[$field->name] : '',
          '#options' => $options,
          '#description' => _profile_form_explanation($field),
          '#required' => $field->required,
        );
        break;

line(567)

 'DynamicSelection'=> t('Dynamic list selection'),

3- in 'profile.admin.inc' add the following code:
line(250)

if ($type == 'DynamicSelection') { // added for IPO--> adds the Options text area in which we write our own query
    $form['fields']['options'] = array('#type' => 'textarea',
      '#title' => t('Selection options'),
      '#default_value' => isset($edit['options']) ? $edit['options'] : '',
      '#description' => t('Write your own Query'),
    );
  }

4- in profile.pages.inc :
line (48)

in profile.page.inc :
 case: 'DynamicSelection':
	  $query = "v.value = '%s'";
        $arguments[] = $value;
        break;

line(73):

 if ($field->type == 'selection' || $field->type == 'list' || $field->type == 'textfield' || $field->type == 'DynamicSelection' )

thats it hope I did not miss anything !

jadowd’s picture

jadowd commented

any time you get an core update, you will over write your changes... better to try and use the hook method to add in your changes, in which case, you won't have to constantly re-implement them.

Parser’s picture

Parser commented

Bartezz has a nice example here that I used to create database driven lists on the profile page. You need to create a simple module but it super easy if you follow these steps.