passing form variables

sandgnat

I have a form that consists of some checkboxes and one submit button. Each checkbox has a unique number for it's name and for it's value.

So for exemple,

<input type="checkbox" name="1" value="44444">
<input type="checkbox" name="2" value="22222">
and so on...

The number of checkboxes in the form will vary depending on the number of records returned by a database (a checkbox is given at the end of each record for the user to check signifying "delete this record" and they may or may not check them all).

So, I need to pass each checkbox value to another php script that will actually do the record deleting based on the value of each checkbox. I need to get the value of each checkbox as the "key" in some array. Then I will need to loop through each value until all the records are deleted. How can I do this? How do I do the $_Post part?

I want to code the record delete like this:

$query="DELETE FROM info WHERE account='$checkbox_value' ";

I'll need to keep running this query until all the values that where passed are used.

Does my problem make sense?? Any suggestions?

Thanks so much! I need help big time!!🙁

ecg

Are all the checkboxes for deleting?
in that case try naming them the same thing and using an array....
sorry I use postgresql.. so your query will be slightly different obviously...

<?php
$Query = pg_query("Select * from Filename;");
for($i  = 0 ; $i < pg_num_rows($Query); $i++) {
	$Row = pg_fetch_object($Query, $i);
		$ID =$Row->ID;
		$Name =$Row->Name;
?>
<tr>
<td><input type ="checkbox" name="Remove[<?php echo $ID?>]" ></td>
<td><?php echo $Name; ?></td>
</tr>
<?php } ?>

print_r($Remove); to see whats in the array if you want.

then in your processing :

$Query = pg_query("Select * from filename");
for ($i = 0; $i <pg_num_rows($Query); $i++) {
	$Row = pg_fetch_object($Query, $i);
	$ID = $Row->VoucherID;
	if ($Remove[$ID] !="") {
		$sSQL ="delete from filename where ID = $ID";
		ExecuteQuery($sSQL);
		}
}

Does that work for you?

mogster

Your form-field for selecting articles needs to look about like the one below, and the code in the receiving end is below the field:

## All form checkboxes has same name, but different value: ##
<input type="checkbox" name="selectedArticles[]" value="<?PHP echo (int)$article_id; ?>">
<?PHP
## Function ##
deletearticle($article_id) {
mysql_query("delete from table where article_id='$article_id'");
}

## Run code ##
$k = 0;
for ($k = 0; $k < sizeof($selectedArticles); $k ++) {
deletearticle($selectedArticles[$k]);
}
?>

Or something like that 😃

kntm

bretticus

My first question would be....why do you need a separate name and value for each checkbox? I understand one or the other of course. Unless you have a reason for the checkbox names to be different, I would suggest the following:

Use an array for the name, by adding on braces '[]' at the end of the name:

Next, insert the record ID as the vale of each individual record:

Now in your form hander, loop through the array values and build a query for each iteration and execute it or use OR for 1 query:

<?
foreach($_POST['records'] as $checkbox_value){
$query="DELETE FROM info WHERE account='$checkbox_value' ";
(execute query...)
}
?>

If you want to 1 query, build your OR statements in the loop.

sandgnat

You guys are GREAT!!!! What a fast response!

bretticus,
You're advice worked right off the bat! It wasn't important that each checkbox have a different number. I gave each one a unique number because I wasn't sure if it was needed or not. You showed me that it wasn't necessary. I was more conerned with its value.

Just one last question, even though naming each checkbox as record [ ] works, I don't understand the logic behind it. How does the next php script understand what to do with it? I would have never known to do that.

Thanks to EVERYONE that helped me!!! 😃

bretticus

Glad that it worked for you.

In PHP, at least, if you put braces on a form name it tells the second script (or form handler) that this POST data key should be treated as an array. With check boxes, the value is only sent if the checkbox is checked. As the form hander get's the first 'record[]' POST key it sees the braces and adds the first value as an array element and so on. Therefore, you can then loop through the array to pull out the values as we did the the previous example.

ciao!

dan2158

OMG I love this website. It was killing me to find out the same thing all I needed to do was a quick search and I found the answer. Everyone here is a great help.
Thanks,
Dan