AHAH Dependent dropdown with options provided from a database query

Hi - Please start SIMPLE.

Start by just changing the existing dependent dropdown and implementing _ahah_example_get_first_dropdown_options() and _ahah_example_get_second_dropdown_options() using your database instead of the static initialization technique.

Note that the normal situation would be to have an associative array with key=>value instead of the Strings => Strings type thing that drupal_map_assoc() provides.

When you get those two functions implemented against your database, if they're working, the dependent dropdown should work. Then you can go forward from there actually implementing something for your own purposes.

-Randy

Sorry, I need you to explain more explicitly what you want to do.

i need same multiple dropdown based on single product

i used ahah but not working

I know this is for drupal6 (im orking with drupal7) but the case is I need to implement dependent dropdowns with retrieved data from a db, but i need these dependent dropdowns to be in the user registration form... any idea how to insert them in the registration form and feed the table 'users´with the choices of the user in these dropdowns?

thanks a lot (and sorry I couldn´t help you)

You use hook_form_alter() to do AJAX in a form that you didn't create. An example would be appreciated here. The most common request is an example of a hook_form_alter of the node page.

The basic dependent dropdown example should be adequate.

I made it, I used #after_build and the dropdowns are in the form now. Still they don't validate and submit with the rest of the form. I guess is not the correct atribute.
Also (and more important, I dont know how to accomplish the "dependent query" Do you know where can i look for an example also?
Here is the code:

function myform_form_alter(&$form, &$form_state, $form_id) {
  //first, let's check if the form is thregistration form or the profile form
  if (!($form_id == 'user_register_form' || $form_id == 'user_profile_form')) {
    return;
  }
  //then, let's add a new validate function to the user form to handle the status
  $form['#validate'][] = 'company_status_validate';
  
  //now, let's alter the submit function by creating a custom submit (incl. my queries)
  $form['#submit'][] = 'company_status_submit';
  
  //also add a dependent dropdown based in a new function made in ajax
  $form['#after_build'][] = 'myform_dependent_dropdown';

  //add a fieldset for the confirmation of the user's status
  $form['account']['member_status'] = array(
    '#type' => 'fieldset',
    '#title' => t('Confirm you are a company'),
    '#collapsible' => TRUE,
    '#collapsed' => FALSE,
    );
  
  //add a pair of radios buttons for the user to say if he/she is a company
  $form['account']['member_status']['im_company'] = array (
    '#type' => 'radios',
    '#description' => t('You can only enter in %site-name if you are a company, so tell us the truth', array('%site-name' => variable_get('site name', 'drupal'))),
    '#default_value' => 0,
    '#options' => array(t('I am a company'), t('Well, I am not'))
  );
  
  //add a select field with the sector options, withdrawn from db
   $form['account']['member_status']['sector'] = array(
    '#type' => 'select',
    '#title' => t('Sector'),
    '#description' => t('Choose the sector of your company'),
    '#options' => array(),
  );
  if (isset($form['account']['member_status']['sector'])) {
    $sectors = array();
    $result = db_query("SELECT sector_id, sector_name FROM {sectors}");
    foreach ($result as $record) {
      $sectors[$record->sector_name] = $record->sector_name;
    }
    $form['account']['member_status']['sector']['#options'] = $sectors;
  }
}

/**
  * Now let's make the form validation as called in the alter function
 */
function company_status_validate($form, &$form_state) {
  global $user;
  // did user say you were a company?
  if ($form_state['input']['im_company'] <> 0) {
    form_set_error('im_company', t('You must be a company, didnt you know that?'));
  }
}

/**
  * Implements a hook_submit() function
  *   like this we intercept the original submit in the altered form
  */
function company_status_submit($form, &$form_state) {
  global $user;
    $sector = $form_state['input']['sector'];
    drupal_set_message(t('We have a lot of opportunities for the %sector sector', array('%sector' => $sector)));
    $imaco = $form_state['input']['im_company'];
  //insert into the db
    db_merge('imacompany')
      ->key(array('uid'=>$user->uid))
      ->fields(array(
        'imaco' => $imaco,
        'sector_name' => $sector,
      ))
      ->execute();
}

/**
  * Implements hook_user_view_alter().
  *   we are trying to show our results from the db in a new section  of the profile "view"
  */
function myform_user_view_alter(&$build) {
  global $user;
  if ($build['#account']->uid = $user->uid) {
	$build['summary']['sector'] = array(
	  '#type' => 'user_profile_item',
	  '#title' => t('My sector'),
	  '#weight' => 5,
	);
  }
}

/**
 * A form with a dropdown whose options are dependent on a
 * choice made in a previous dropdown.
 *
 * On changing the first dropdown, the options in the second
 * are updated.
 */
function myform_dependent_dropdown($form, &$form_state) {
  //get the list of options to populate the first dropdown
  $options_first = _myform_get_sector_options();
  // If we have a value for the first dropdown from $form_state['values'] we use
  // this both as the default value for the first dropdown and also as a
  // parameter to pass to the function that retrieves the options for the
  // second dropdown.
  $selected = isset($form_state['values']['sector']) ? $form_state['values']['sector'] : key($options_first);
  
  $form['sector'] = array(
	'#type' => 'select',
	'#title' => 'Economic sector',
	'#options' => $options_first,
	'#default_value' => $selected,
	 // Bind an ajax callback to the change event (which is the default for the
	// select form type) of the first dropdown. It will replace the second
	// dropdown when rebuilt
	'#ajax' => array(
	  // When 'event' occurs, Drupal will perform an ajax request in the
	  // background. Usually the default value is sufficient (eg. change for
	  // select elements), but valid values include any jQuery event,
	  // most notably 'mousedown', 'blur', and 'submit'.
	  // 'event' => 'change',
	  'callback' => 'myform_activity_callback',
	  'wrapper' => 'activity-replace',
	),
  );
  $form['activity'] = array(
	'#type' => 'select',
	'#title' => t('Economic activities from your chosen sector:'), 
	 // The entire enclosing div created here gets replaced when dropdown_first
	// is changed.
	'#prefix' => '<div id="activity-replace">',
	'#suffix' => '</div>',
	// when the form is rebuilt during ajax processing, the $selected variable
	// will now have the new value and so the options will change
	'#options' => _myform_get_activity_options($selected),
	'#default_value' => isset($form_state['values']['activity']) ? $form_state['values']['activity'] : '',
   );
   return $form;
}
	
/**
 * Selects just the second dropdown to be returned for re-rendering
 *
 * Since the controlling logic for populating the form is in the form builder
 * function, all we do here is select the element and return it to be updated.
 *
 * @return renderable array (the second dropdown)
 */
function myform_activity_callback($form, &$form_state) {
  return $form['activity'];
}

/**
 * Helper function to populate the first dropdown. This was accomplished with drupal_map_assoc, but
 * i'll try with a db query...
 *
 * @return array of options
 */
function _myform_get_sector_options() {
  $sectors = array();
  $result = db_query("SELECT sector_id, sector_name FROM {sectors}");
  foreach ($result as $record) {
	$sectors[$record->sector_id] = $record->sector_name;
  }
  return $sectors;
}

/**
 * Helper function to populate the second dropdown. This was accomplished with drupal_map_assoc, but
 * i'll try with a db query...
 *
 * @param $key
 *   This will determine which set of options is returned.
 *
 * @return array of options
 */
 // function _myform_get_activity_options($key) {
//   $options = array();
//   $chosen_sector = db_query("SELECT sector_name, sector_id FROM {sectors} WHERE sector_id = :sector_id",
// 	array(':sector_id' => $key,
//     ));
//   foreach ($chosen_sector as $record) {
//     $options[$record->sector_id] = $record->sector_id;
//   }
//   $matching_activity = db_query("SELECT sector_id, activity_id, activity-name FROM {activities} WHERE sector_id = :sector_id",
// 	array(':sector_id' => '',
//     ));
//   foreach ($matching_activity as $record2) {
//     $options[$record2->sector_id] = $record2->sector_id;
//   }
//   return $options;
// }
function _myform_get_activity_options($key = '') {
  // RIGHT NOW THERE IS A FAKE SNIPPET, I DONT KNOW HOW TO CONNECT BOTHE DROPDOWNS
  $options = array(
    $form['input']['sector'] => array(t('yes')),
  );
  if(isset($options[$key])) {
    return $options[$key];
  }
}

thanks a lot.

Please use http://drupal.stackexchange.com for support like this. Thanks!

As always... Change status as needed.