CakePHP 3 dropdown values

Question

I have a dropdown that only shows the id of a table row. I like to show multiple values from that table to the user in the dropdown.

Do I need to add an array with columnames in the variabele from the controller or something like that?

Edit: In function add I've this variable

$addresses = $this->Users->Addresses->find('list', ['limit' => 200]);

In the view

echo $this->Form->input('address_id', ['options' => $addresses]);

I only want to show the values address_id, city, street, zipcode in the dropdown.

can you please add some code? And add some explanation about the desidered behavior? — arilia
– arilia, Commented Feb 4, 2016 at 11:23
@dnns you shouldn't need to tell Cake what the options array is if you use the plural of the model name as you are. i.e. Cake will assume that the variable $addresses populates the options for a foreign key $address_id. So your input code would look like $this->Form->input('address_id');. You should only need to pass the options value when using a variable other than the one Cake is expecting (if that makes sense). :-) — drmonkeyninja
– drmonkeyninja, Commented Feb 4, 2016 at 12:36

arilia · Accepted Answer · 2016-02-04 11:48:35Z

5

Use a virtual field:

in your Addresses entity file you can do

function _getFullName()
{
    $ret = $this->city.' '.$this->street.' '.$this->zipcode;
    return $ret;
}

and then in your controller you can do

$addresses = $this->Users->Addresses->find(
    'list', 
    ['limit' => 200, 'valueField' => 'full_name']
);

answered Feb 4, 2016 at 11:48

arilia

9,3982 gold badges24 silver badges47 bronze badges

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

4 Comments

Sevvlor Over a year ago

This is better than what I suggested +1. Forgot about those.

user5853948 Over a year ago

Nice, I think this is a clean way of doing this. Exactly what I was looking for.

user5853948 Over a year ago

Is it also possible to acces the underlying table of Addresses and place it in $ret?

Sevvlor Over a year ago

@dnns I am not entirely sure what you are asking for, maybe it's worth to shoot in another question about that?

Sevvlor · Accepted Answer · 2016-02-04 11:14:07Z

0

The Form::Select() only needs one array for it's values to display. It uses the index to define the value and the the value of the array to display.

What you could do is fetch the needed columns from the table and use concat() to create one string from those two columns which you then put into an array.

Alternatively you could take a look at the displayField() in the Table class which accepts an array. The downside of doing this is when you use $table->find('list'); you'll get something along the lines of Sevvlor;1 which is probably not what you want.

answered Feb 4, 2016 at 11:14

Sevvlor

5601 gold badge7 silver badges24 bronze badges

Collectives™ on Stack Overflow

CakePHP 3 dropdown values

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related