checkbox NIGHTMARE ~ help please!

Anon

example: A mysql query returns result in form of an array, that the visitor sees as a table with a bunch of rows.

Each row has it's own, "would you like to delete this row?" checkbox.

How can I make it so that if visitor puts a checkmark in one or more of the checkboxes, hits the submit button, those rows get removed where he checked the checkbox???

The logistical problems I'm running into are too numerous to mention, but they involve things like this:

I'm figuring that for each row, the checkbox has to have it's own value. So, I'm doing this:
<input type='checkbox' name='$name_of_the_actual_product_mentioned_in_this_row'>

Then, I thought I'd try an isset function like:

if (isset($name_of_product_blah_blah)) {
don't echo this table row
}

...but the values are always checked, and this is a nightmare. I'm hoping this quandry has already been figured out by someone and is easy to implement! :-)

alfoxy

maybe try putting a checked value like "yes" in the check box tags then check
if($name_of_product_blah_blah == "yes")

Dunno if this is any help
Al

amcgrath

Assuming you have a primary key for the row, name the chackbox delete[$primary_key]... then in your code loop through the array called delete[] and you got it.

Anon

I think you're onto something; except I need a wee bit of help with the code.

Here, I'll give my code, if you would please modify it:

$sqlState = "select * from mylistofproducts where product = '$sqlValues[0]' ";
for($i = 1; $i < sizeof($sqlValues); $i++) {
$sqlState .= "or product = '$sqlValues[$i]' ";
}
$rv = mysql_query($sqlState,$link);
if(mysql_num_rows($rv) >0) {
while($product = mysql_fetch_array($rv))
{
echo "<TR><TD>" . $product["description"] . "</TD></TR>";
echo "<input='checkbox' name='$product["description"]'>
blah blah
#visitor will see dozens of rows w/ all products
}

Anon

I assume your table has some sort of numeric unique primary key. Use that number for the checkbox value. I would collect all of the checkbox data as an array and build a mysql query with the array. Let's assume that you have pulled the data out of your data and $id is the unique record key.

<input type="checkbox" name="delete_ids[]" value="<?= $id ?>" Record #<?= $id ?>

(this code would be repeated vis a loop for each record). When this form is submitted you now have an array of all of the records that are to be deleted. then on your form processing page:

<?
foreach ($delete_ids as $key => $value) {
$delete_ids[$key] = "id = $value";
}
$delete_string = implode (' AND ', $delete_ids);

$result = mysql_query ("DELETE FROM table_name WHERE $delete_string");
?>

Anon

One way is to give all your checkboxes the same name with a numerical key e.g.

delete_id[0]
delete_id[1]
delete_id[2]...

or if generated on the fly use a counter

your for or while loop:

$i
whatever code you have and

print "<input type=checkbox name='delete_id[$]'>";

$i++

Then collect the delete_id on your action page as:

while($x = each($delete_id))
{
	//echo "$x[0] => $x[1]<BR>";

$id_list = $id_list . " '" . $x[1] . "',";
}

//format the query string correctly by removing ending comma
$id_list = substr("$id_list", 0, -1);
$delete_query = "DELETE * from my_field WHERE my_field_id IN ($id_list)";

Your delete_ids will be in the $id_list variable and you can use the SQL IN param to delete the records.

Hope that is clear enough

Jon B

Anon

Thanks to Devin and Jon, this should be the best code to use:

foreach ($delete_ids as $key => $value) {
$delete_ids[$key] = "'$value'";
}
$delete_string = implode (', ', $delete_ids);
$resultpt2 = mysql_query ("DELETE FROM my_field WHERE my_id IN ($delete_string)");

Hope this helps.

Mark