0

I have a table with two columns: City and ZIPcode

Using HTML / PHP / MySQL

created a drop down select list with City as Label and ZIPcode as Value. Now I want to catch both City and ZIPcode of selected (using multiple selections through array[]). "explode" does not support arrays[].

Please help me how to achieve this.

Sagar Patra
  • 51
  • 1
  • 6
  • 4
    Possible duplicate of [How to post two values in an option field?](https://stackoverflow.com/questions/8027163/how-to-post-two-values-in-an-option-field) – Don't Panic Jun 02 '17 at 22:21

1 Answers1

1

If you need to do it with just HTML and PHP (no Javascript), you could place both of them in the same select with a separator character, like so:

<option value="City,Zip">City</option>

And then process it on the server like so:

<?php
     $location_data = $_POST["location_variable"];
     $exploded = explode(",", $location_data);
     $city = $exploded[0];
     $zip  = $exploded[1];
?>

You would want to include error handling, checking to make sure that the exploded data was appropriate length, etc.

However, if you have access to javascript/jQuery, you could bind the zip or city with a data attribute and send that along as well using a new hidden data attribute.

<option value="City" data-zip="zip">City</option>

And then in Javascript:

$("form").submit(function() {
     //find our zip value
     var zip   = $(this).find(":selected").data("zip");

     //create a new hidden input named "zip"
     var input = $("<input>").attr("type", "hidden").attr("name", "zip").val(zip);

     //add it to our form
     $(this).append(input);
 });
Schiem
  • 589
  • 3
  • 12
  • I did already tried the first option (HTML code), that works fine with Single selection; But I want to select up to 5 cities, so using arrays. explode does not support arrays. – Sagar Patra Jun 02 '17 at 22:25
  • @SagarPatra For a multiple selection, you'd just need to iterate the array of selections and explode each one. – Don't Panic Jun 02 '17 at 22:27