[RESOLVED] Array in a form

[netfrugal]

I have a form with a checkbox and a submit button. I populate the name of the checkbox with as many items I have in my table. My frustration is finding out how to insert into the table: xlink the data from the form below.

See code below for Form.php

<form name="form1" method="POST" action="update.php">
<tr>
<td class='nicetableheader'>ID</td>
<td class='nicetableheader'>Product Name</td>
<td class='nicetableheader'>Cross Link</td>
</tr>

<?
$sql = mysql_query("SELECT * FROM servers ORDER BY server_name ASC"); // Perform MySQL query on only the current page number's results

while ($row = mysql_fetch_array($sql)) { ?>
<tr>
<td class='nicetablerow'><? echo $row['productID']; ?></td>
<td class='nicetablerow'><?php echo $row['server_name']; ?></td>
<td class='nicetablerow'><input type="checkbox" name="xlink" value="<? echo $row['productID']; ?>"></td>
</tr>
<? } ?>
<input class="textbox" type="submit" name="Submit" value="update">
</form>

update.php

This is the part where I get confused. I know how to write INSERT and UPDATE statements for anything not in an array, or in a while statement. But for as many checkboxes show up I am lost as to creating an INSERT or UPDATE statement for every checkbox, if checked!

Does anyone know a good tutorial on this? or have some simple way to explain putting arrays into forms and sql statements?

thanks!

[stolzyboy]

start by naming the checkbox like: name="xlnk[]", that'll create an array on your processing page called $_POST['xlink']

then you can iterate thru the array like:

<?
while (list ($key, $val) = each ($_POST['xlink'])) 
{
//do your insert/update here
}
?>

or

<?
foreach ($_POST['xlink'] as $key => $value)
{
//do insert/update here
}
?>

this is just for an example, in real situation, you'd "clean" the $_POSTed array and then use your new clean variable in the loops

[netfrugal]

That totally worked!

Here is what I did:

FORM.php

<input type="checkbox" name="xlink[]" value="<? echo $row3['productID']; ?>">
<input name="productID" type="hidden" id="productID" value="<? echo $productID; ?>">
<input class="textbox" type="submit" name="Submit" value="update">

---

UPDATE.PHP

$productID = $_POST['productID ']; // from the hidden field(which is the main product page.

foreach($_POST['xlink'] as $array_insert) {

$sql = "INSERT INTO xlink(productID,xlink_ID) VALUES ( '$productID', '$array_insert')";
$result = mysql_query($sql,$connection) or die('now!');

}