build delete query from checkboxes

sd1

Hello you all
my english is poor, so i hope you'll understand my problem.

i have a form with some checkboxes. i name every checkbox witht the name verify[] and the value with some numeric number.

i.e:
<input type=checkbox name=verify[] value=1>
<input type=checkbox name=verify[] value=2>
<input type=checkbox name=verify[] value=3>
and so on.

i also have a submit button.

now, i also have a table namt tbl1 with this fields:
id,verifyID

what i want to do is that:
check which checkboxes weren't checked by the user, then check if it's value exist in the table, if it's true, i want to delete this row from the database.

i.e.: if the user didn't checked the first checkboxes (the one with the value=1), i want to check in the table if there is a row in tbl1 with the verifyID=1 and delete this row

hope you can help me

ir4z0r

isn't it possible to change the checkboxes to be checked for deletion?
would be much easier, schema:

// mysql_connect() and mysql_select_db() here
$boxes = $_POST['boxes'];
for ($i=0; $i < sizeof($boxes); $i++)
{
  // deletes if entry exist, not if it not exist ;-)
  $result = mysql_query("DELETE FROM tbl1 WHERE verifyID='" . $boxes[$i] . "'");
}

sd1

i need to delete if the checkboxes isn't checked!

i mean, if the user didn't checked the checkbox, i need to delete the value. the problem is, that the form doesn't send this varibale

ir4z0r

okay, if you can't change it ...

are the values sequential? 1,2,3,4..., or mixed? 123,543,32,...

sd1

they are mixed

i take the data from the database

xblue

just a thought -

// generate a list from the submitted ids
$id_list = implode(',', $verify);
$sql = "DELETE FROM table WHERE id NOT IN ($id_list)";
mysql_query($sql) or die(mysql_error());

laserlight

that could be rather dangerous

for example, the form could be on different pages (assuming too many rows), then the query would delete the rows that arent listed on the current page.

actually, why cant you delete if the checkboxes are checked?

wouldnt that be simpler?

sd1

hi all and thanx a lot for your help
i can't delete checked boxes because what i'm trying to build is a system that will manage authorizes, so if the admin want to remove user authorize, he shuld unchech the box

Blob

Couldn't you just have "Check this box to remove User Authorise"?

sd1

no, i think it will look funny.
i know it's a bit problem, but there must be a solution

ir4z0r

you have a limited number of permissions then?

so create an array which contains ALL perms
get all checked perms
get the difference of these two arrays et voila!

sd1

that's a good idea
i can put one array as hidden fields and the other as the checkboxes

but, how can i compare the 2 arrays? this one i don't know to do

ir4z0r

$diffarray = array_diff($array1, $array2);

sd1

10x a lot

i used that:

$diffarray = array_diff($verify, $verifyHid);
for($i=0;$i<sizeof($diffarray);$i++) {
echo $diffarray[$i];
}

but what i get is the values that were checked in the form

ir4z0r

strange 😕

the first parameter must be the one containing ALL entries,
the second the chosen ones from the checkbox array

if you've done that I suggest you read all the examples and comments
to array_diff() at www.php.net, maybe that helps (?)

btw for printing, you can use print_r($diffarray)

sd1

hi!
it's finally working for me!

thanks a lot for yor great help