Zend Framework: Populating DB data to a Zend Form dropdown element

Question

I have the following form:

<?php
class Application_Form_RegistrationForm extends Zend_Form{

    public function init(){

        $country = $this->createElement('select', 'country');
        $country->setLabel('country: ')
                ->setRequired(true);


        $email = $this->createElement('text', 'email_address');
        $email->setLabel('Email Address: ')
                ->setRequired(true);

        $register = $this->createElement('submit', 'register');
        $register->setLabel('Create new Account')
                ->setIgnore(true);

        $this->addElements(array(
            $country, $email, $register
        ));




    }

}

?>

The list of the countries are present in a table country in a database.

Is there anyway I can populate the country dropdown list with the country names from the database?

Any help is appreciated.

Thanks

David Snabel-Caunt · Accepted Answer · 2010-10-11 22:26:26Z

9

You sure can.

In the init method you can set the options with something like this, assuming $db is a Zend_Db adapter:

$options = $db->fetchPairs('SELECT id, name FROM country ORDER BY name ASC');
$country->setMultiOptions($options);

In case you haven't seen the fetchPairs method, it builds an array, where the first column return becomes the key, and the second column the value.

answered Oct 11, 2010 at 22:26

David Snabel-Caunt

58.4k13 gold badges118 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BasTaller · Accepted Answer · 2010-10-17 20:27:23Z

6

You could do it from controller's action (or even in Service Layer, if to be meticulous), if your list's content depends from some conditions. Usage:

$form->getElement('country')->addMultiOption('1','USA');     //add single value
$form->getElement('country')->addMultiOptions(array('1'=>'USA', '2'=>'Canada'));     //add values by array
$form->getElement('country')->setMultiOptions(array('1'=>'USA', '2'=>'Canada'));     //set values by array

Of course, to add values from DB you need to fetch them first.

See http://framework.zend.com/manual/en/zend.form.standardElements.html#zend.form.standardElements.select for more methods available.

edited Oct 17, 2010 at 20:27

answered Oct 14, 2010 at 8:17

BasTaller

80610 silver badges18 bronze badges

1 Comment

Fopa Léon Constantin Over a year ago

+1, Yet, Things changed a little bit in in Zend 2. Thus, your last line will be rewritten as $form->get('country')->setValue(array('1'=>'USA', '2'=>'Canada'));

Simon · Accepted Answer · 2010-10-17 20:36:20Z

4

The best way is to create a new class for the element:

Put this in "/application/form/element/CountySelect.php"

class Application_Form_Element_CountrySelect extends Zend_Form_Element_Select {
    public function init() {
        $oCountryTb = new Application_Model_Country();
        $this->addMultiOption(0, 'Please select...');
        foreach ($oCountry->fetchAll() as $oCountry) {
            $this->addMultiOption($oCountry['id'], $oCountry['name']);
        }
    }
}

And then add it to the form this way:

class Application_Form_RegistrationForm extends Zend_Form{
    public function init() {
        $this->addElement(new Application_Form_Element_CountrySelect('country_id'));
    }
}

answered Oct 17, 2010 at 20:36

Simon

5,2478 gold badges46 silver badges66 bronze badges

1 Comment

Andrew Koper Over a year ago

and then when this doesn't work because there is no explanation for the new Application_Model_Country()...

Collectives™ on Stack Overflow

Zend Framework: Populating DB data to a Zend Form dropdown element

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related