1

I am trying to develop a pretty complicated form. Essentially the user selects from Education, health, or water quality. Then using states the correct follow up questions are asked before all this data is submitted.

However, whenever I try to populate with a db query it acts funny. For example. Health and Education but have a dropdown select for years. Each should load the years available from the database and populate accordingly. However, the health dropdown select for year (which comes after the education) populates its self with the education's years. If I do a dpm to see what year the health year query gets, it is right, but it does not display on the dropdown.

I hope that makes sense. To sum it up: I have two queries to populate two different year forms. However, both populate themselves with the first query, even though the second one returns the right variables.

Here is the code:

$form['data_set'] = array(
    '#type' => 'select',
    '#title' => t('Please Select a Topic'),
    '#options' => array(
        'education' =>t('Education'),
        'health'    =>t('Health'),
        'water'     =>t('Water'),
    ),
    '#required' => TRUE,
);
// If User Selects Education
$form['education'] = array (
    '#type' => 'fieldset',
    '#title' => t('What Education Information are you looking for?'),
    '#states' => array(
        'visible' => array(
            ':input[name="data_set"]' => array('value' => 'education'),
        ),
    ),
);

    //Query DB for Rows
    $query = db_select('hp_education_years');
    $query->fields('hp_education_years', array('id', 'years',));
    $query->orderBy('years', 'ASC');
    $results = $query->execute();

    //define rows
    $options = array();
    foreach ($results as $result) {
        $options[$result->id] = array(
            $result->years,
        );
    }
    $form['education']['year'] = array(
        '#type' => 'select',
        '#title' => t('Year'),
        '#options' => $options,
        '#states' => array(
            'visible' => array(
                ':input[name="data_set"]' => array('value' => 'education'),
            ),
        ),
    );
    $form['education']['level'] = array(
        '#type' => 'select',
        '#title' => t('Level'),
        '#options' => array(
            'primary' => 'Primary',
            'jhs' => 'JHS',
            'shs' => 'SHS',
        ),
    );
    $form['education']['sector'] = array(
        '#type' => 'checkboxes',
        '#title' => t('Sector'),
        '#options' => array(
            'public' => t('Public'),
            'private' => t('Private'),
        ),
    );

//if user selects health
$form['health'] = array (
    '#type' => 'fieldset',
    '#title' => t('What Health Information are you looking for?'),
    '#states' => array(
        'visible' => array(
            ':input[name="data_set"]' => array('value' => 'health'),
        ),
    ),
);

    //Query DB for Rows
    $query1 = db_select('hp_health_years');
    $query1->fields('hp_health_years', array('id', 'year',));
    $query1->orderBy('year', 'ASC');
    $results1 = $query1->execute();

    //define rows
    $options1 = array();
    foreach ($results1 as $result1) {
        $options1[$result1->id] = array(
            $result1->year,
        );
    }
dpm($result1->year);
    $form['health']['year'] = array(
        '#type' => 'select',
        '#title' => t('Year'),
        '#options' => $options,
    );
1

You have the same variable ($options) for both fields. Use $options for $form['education']['year'] and $options1 for $form['health']['year'].

  • wow.... sorry for the waste of bandwidth. Thanks for looking through that for me! – Lucas Healy Aug 6 '12 at 17:10
0

You could have a look here at these examples http://d7.drupalexamples.info/examples/form_example/states

Or here http://api.drupal.org/api/examples/form_example%21form_example_states.inc/7

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.