Check Boxes

Anon

I am new to programming as well as PHP. Please visit www.indiantreks.com/deleterecords.php3
I have added checkboxes. Now I want to delete the record where the checkboxes have been checked. I have tried out some of the codes in this forum, but still being an amateur, am still unable to complete my task. Please give some specific help. I would be extremely grateful. Thanks

lisnaskea

Call your checkboxes "delete[]" so that they will be passed as an array.

In the script that processes the form add this function

function getcheckboxes ($checkbox)
{
foreach($checkbox as $value) {
$values .= "," . $value;
}
$values = substr($values, 1);
return($values);
}

This function when supplied with the $delete array will return a string of comma separated values (i.e "2,7,254,32")

So to call the function do this:

$records_to_delete = getcheckboxes($delete)

Now all you need to do is run an sql query to delete all records where id in $records_to_delete

DELETE * FROM table WHERE id IN ('$records_to_delete')

replace table and id with whatever your using obviously

Anon

Hi !
Thanks for your prompt reply

I have tried this :
<?php
function getcheckboxes ($checkbox)
{
foreach($checkbox as $value) {
$values .= "," . $value;
}
$values = substr($values, 1);
return($values);
}

$records_to_delete = getcheckboxes($deleterec);
DELETE * FROM seller WHERE seller_id IN ('$records_to_delete');

I have also tried using $deleterec instead of $checkbox.
I get a parsed error on line 12 (the delete query. I guess I have reached a mental block, working for the past 3 days and nights continiously. Please help !

lisnaskea

no no no you cant just stick in an sql query like that. thats why ur getting the parse error.

Now...This all depends on your db vendor. Here is an example with MySQL.

Assuming youve connected to your database...

$result = mysql_query("DELETE * FROM seller WHERE seller_id IN ('$records_to_delete')");

$result holds a boolean value indicating success or failure of the delete statement.

If your still having trouble try investing in a caopy of "PHP Bible" ISBN 0-7645-4716 This will teah you all you need to know about using php with a database etc..