html/php multiple select with two values

Question

I currently edit an open source program and have a question: the php code is actually like this:

print "<select multiple name=\"appliesto[]\" size=\"5\">";
foreach ($products as $k => $v) {
    $pid = $k;
    $group = $v['group'];
    $prodname = $v['name'];
    print "<option value=\"$pid\">$group - $prodname</option>";
}
print "</select>

Is it possible to get 2 values with each selected option? Because I need to save $pid and $prodname in 2 different columns on a mysql table.

Thanks!

That is not possible. Can't you just look up the product name in the database since you have the product id? — Jaime
– Jaime, Commented Apr 20, 2016 at 21:22
I was just about to say what @joserojas said, however you could also have a json string as the value, then on the other end you just decode it and you then already have an array. — Rasclatt
– Rasclatt, Commented Apr 20, 2016 at 21:39

Jose Rojas · Accepted Answer · 2016-04-20 22:40:46Z

3

You can put at the value attribute some delimiter to the values something like this:

print "<select multiple name=\"appliesto[]\" size=\"5\">";
foreach ($products as $k => $v) {
    $pid = $k;
    $group = $v['group'];
    $prodname = $v['name'];
    print "<option value=\"$pid|$prodname\">$group - $prodname</option>";
}
print "</select>

when you post the data you can explode the data by the delimiter in this case | in order to get the 2 values.

list($pid,$prodname) = explode("|", $inputSelect, 2);

edited Apr 20, 2016 at 22:40

answered Apr 20, 2016 at 21:38

Jose Rojas

3,5403 gold badges29 silver badges43 bronze badges

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

2 Comments

Cave Johnson Over a year ago

If you use this solution, make sure there is no | character in the product name.

Cave Johnson Over a year ago

Also, might I suggest list($pid,$prodname) = explode("|", $inputSelect, 2);? Just to make it shorter and the extra limit parameter in the explode function call ensures that only two elements are returned (in case there is a pipe character in the product name).

Collectives™ on Stack Overflow

html/php multiple select with two values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related