Symfony2 checkboxes & Doctrine

Question

I would like to record a choice of checkboxes in my data base. I get this error:

ContextErrorException: Notice: Array to string conversion in //vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 120

My form :

public function buildForm(FormBuilderInterface $builder, array $options)
    {
        $builder->add('adult_available', 'choice', array(
            'choices'   => array('A' => 'Adult', 'C' => 'Children'),
            'required'  => false,
            'expanded' => true,
            'multiple' => true
        ));

My field :

/**
     * @ORM\Column(type="string", columnDefinition="CHAR(1) NOT NULL")
     */
    protected $adult_available;

My form looks good! But when I submit I got the ContextErrorException exception

Thanks!

That field holds a single value, but you have allowed the form to expect multiple values. — Flosculus
– Flosculus, Commented Jan 20, 2014 at 16:19
You say that is my field is wrong : @ORM\Column(type="string", columnDefinition="CHAR(1) NOT NULL") ? — Anthony
– Anthony, Commented Jan 21, 2014 at 10:16
I don't know whether the field should be a collection, or if the form should only return a single value on submit. I only know that at the moment it looks like they contradict each other. — Flosculus
– Flosculus, Commented Jan 21, 2014 at 10:20
Thanks. I'm very new with symfony and doctrine. I would like to store in database a multiple choice (with chexboxes) but without create a new entity. Is it possible? — Anthony
– Anthony, Commented Jan 21, 2014 at 10:40

Flosculus · Accepted Answer · 2014-01-21 10:45:33Z

1

Try this:

/**
 * @var array
 *
 * @ORM\Column(name="adult_available", type="simple_array")
 */
private $adultAvailable;

answered Jan 21, 2014 at 10:45

Flosculus

6,9563 gold badges22 silver badges44 bronze badges

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

1 Comment

Flosculus Over a year ago

@user2775846 tick me then! :)

Collectives™ on Stack Overflow

Symfony2 checkboxes & Doctrine

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related