Checkbox Results

blueboxgamer

Hi, I have a database for id, names, email address, address, etc.

My client wants a way to archive the names after he looks over them and does what he wants with them. So what i did was put another field in the database called "archived" as defult i set the value of each record to "NO" Then i have a page that displays the records and filters them to only accept records with a "NO" value for the archived field.

K So now I made it that each record has a checkbox with a value of its records ID. He will then check the records that he wants archived. and click submit.

So now this is were you come in. What is the best way to gather all the ID's that he selected to appear on the next page so i can update the database with a while() function or whatever?

Thanks
🙂

devinemke

code the form to collect all of the checkboxes into an array using the primary key field of the table:

record 1 <input type="checkbox" name="archive[]" value="1"><br>
record 2 <input type="checkbox" name="archive[]" value="2"><br>
record 3 <input type="checkbox" name="archive[]" value="3"><br>
etc...

then on the form processor do a query like this:

$result = mysql_query("UPDATE table SET archive = 'Y' WHERE id IN(" . implode(',', $_POST['archive']) . ")");

i'm assuming you are using mySQL. if you are, be advised that mySQL does have a boolean field type but it is very common to simply use a CHAR(1) field that defaults to NULL (NULL = false, Y = true). this will save storage over using the strings "YES" and "NO".

blueboxgamer

Dude your pro. Worked perfect! Thanks