将所选名称POST到数据库

Question

I have a combobox which is populated from my database:

<select id="product" name="product">
<option value="1">One</option>
<option value="2">Two</option>
<option value="3">Three</option>
</select>

I am using the form method post to send the selected value to my database:

$product = $_POST['product'] ;

When I send the data to my database I only get the selected value in my database ('1', '2' or '3').

I also want to send the name of the selected option to my database ('One', 'Two' or 'Three').

Does someone know if it is possible to post the name of the selected value to the database?

Answer 1

You could use a hidden field, and update that field, on option change with JavaScript.

<input type="hidden" name="numberWritten" id="numberWritten" value="" />

JavaScript:

document.getElementById('product').onchange = function() {
    var element = document.getElementById('product');
    var otherValueFromOption = element[element.selectedIndex].innerHTML;
    document.getElementById('numberWritten').value = otherValueFromOption;
}

You now have a $_POST['numberWritten']. With a value of either One Two or Three