$_POST Issue

Jezz

I have a form which posts, amongst other variables $ProductId.

When the form loads an sql query gets all availiable product Id's, and displays them along with the product name as a list of checkboxes, (one for each product).

I then want to be able to select a quantity of them, i.e. more than one, and post them. A second SQL query then inserts these values into a ProductId field in another table.

The problem I have is that it only ever seems to post 1 value for $ProductId - regardless of how many were selected. It always posts the last checkbox value selected, e.g. it overides the previously selected checkbox.

How can I get around this, so that it posts a value for ProductId for each checkbox selected?

(Latest version of PHP/MySQL/Apache)

tsinka

Hi,

post the code. Do the checkboxes have the same name ? Change the names from e.g. ProductId to ProductId[]. That should post the selected values to an array with the name ProductId.

Thomas

velanzia

a little add on to the reply, it was really correct.

probably the problem was you were using the same name to the chackboxes, so the script reads the most latest value ... means, probably the last one 😉

so name the check box like,

<input type="checkbox" name="prodID[]" value="$intPHPValueFromDB" />

and then in php you can read the thing as an array, means ... $_POST['prodID'] ... itself will be an array ....

Jezz

code now looks like this -

<input type=\"checkbox\" name=\"ProductId[]\" value=\"$ProductId\">$ProductName ($ProductId)</input><br>";

the following in the SQL insert -

$sql = "insert into $table_name values('','$POST[Name]', '$POST[CompanyName]', '$POST[EmailAddress]',
'$POST[ProductId]')";

I have checked the value of $_POST[ProductId] after it posts, value is shown as "ARRAY" - However no actual value is being inserted into the DB, regardless of which checkboxes are selected.

I didn't get this bit of code in your example:

value="$intPHPValueFromDB" - as you can see I have not used it, what does it do? am I supposed to put the actual DB name in? 'FromDB' seems a tad vague.

LarsLai

hi!
i think you cannot insert the complete array in a mysql db.
i can think of two possibilities, but for both i would give every checkbox a value (marked = 1, unmarked = 0):
1. you extract the values from the array and concatenates them.
then you store the result in mysql in a SET-typed field.
or 2. you make a TINYINT- or ENUM-typed field in mysql for every checkbox