Acquiring multiple values from one select option value. PHP HTML

Question

How do I have acquire multiple values from one select option value. An example here,

<html>

<form method="post" action="#">
   <select name="retrive_destination">
       <?php while($row = mysql_fetch_assoc($result)){
                    $destinationID = $row['destinationID'];
                    $destination_place = $row['destination_place'];
                    echo '<option value="'.$destinationID.'">'.$destination_place.'</option>
       ?>
      <input type="submit">
</select>

</form>
</html>

How do i get both values '$destinationID' and '$destination_place' from one option value , when the form i submitted as i need both values when the user selects an option on the next step. THank you guys cheers.

piacente.cristian · Accepted Answer · 2014-02-28 17:53:06Z

4

Compose the two values and then explode them server-side

<html>

<form method="post" action="#">
   <select name="retrive_destination">
       <?php while($row = mysql_fetch_assoc($result)){
                    $destinationID = $row['destinationID'];
                    $destination_place = $row['destination_place'];
                    echo '<option value="'.$destinationID."_".htmlentities($destination_place).'">'.$destination_place.'</option>
       ?>
      <input type="submit">
</select>

</form>
</html>

Php server-side

$value= $_REQUEST['retrive_destination'];
$explode=explode("_",$value,2);
$destinationID =$explode[0];
$destination_place =$explode[1];

edited Feb 28, 2014 at 17:53

answered Feb 28, 2014 at 17:46

piacente.cristian

7774 silver badges11 bronze badges

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

6 Comments

steinmas Over a year ago

This is what I was going to put as an answer, you may want to include the explode statement as well in case he doesn't know how to use it.

SajithNair Over a year ago

Also put a dot between $destination_place'">'

piacente.cristian Over a year ago

Edited the answer as suggested

SajithNair Over a year ago

Even though concatenating the value to ID is an easy method, you need to be careful, since the $destination_place looks like a Text entity and can contain quotes or > < symbols, so have to encode these

ShanjayG Over a year ago

Thank you @Piancentecristian. the explode worked excellently. this was blast.

|

Hackerman · Accepted Answer · 2014-02-28 17:55:42Z

2

Jquery Version:

Add an input type hidden on your form:

<form method="post" action="#">
<select name="retrive_destination" id="des">
   <option value="1">Ibiza</option>
   <option value="2">Mallorca</option>
   <option value="3">Chile</option>
</select>
<input type="hidden" name="destination" id="dest"/>
<input type="submit" />
</form>

Jquery:

$(document).ready(function(){
$("#des").change(function(){
   $("#dest").val($("#des option:selected").text());  
});
});

PHP:

$destId  = $_POST['retrive_destination'];
$destVal = $_POST['destination'];

answered Feb 28, 2014 at 17:55

Hackerman

12.3k2 gold badges37 silver badges47 bronze badges

Comments

SajithNair · Accepted Answer · 2014-02-28 17:53:32Z

0

Best is to have the form only submit the ID as you can always fetch the destination place from database in your server side.

answered Feb 28, 2014 at 17:53

SajithNair

3,8851 gold badge20 silver badges23 bronze badges

Collectives™ on Stack Overflow

Acquiring multiple values from one select option value. PHP HTML

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related