I have a form with a checkbox array which facilitates my application for the classes held in a competition and an input to enter the price of that class
So I am looping from the database the id of the row for the class which is the value for the selected checkbox (class field). Now the price isn't stored in the database so in essence it's just an input field for the user to enter in a price.
I've set the input field's name to price[]
so it is an array of prices in the form submission.
The issue im having is iterating through the arrays with foreach loops.
$classes= $_POST["classes"]; == (checkbox )
$price= $_POST["price"]; == ( input text field )
my foreach is like so
foreach($classes as $key=>$n){
// print_r($price[$key]);
mysql_query("INSERT INTO tbl_set_shows (show_id, class, price)
VALUES (
'$showid',
'$n',
'$price[$key]')")
or die(mysql_error().'error');
}
For example, I check class options 1, 2, and 3 (in that order) and it's fine and I get the values for price and class perfectly in my table.
However if I select say classes 5, 10, and 15 together with the price input, I lose the value of price hence // print_r($price[$key]);
which is empty if I don't follow that order.
Could anyone point me in the right direction?