[SOLVED] insert into db only is isset

[rvdb86]

Hi,

 

I have a list of check box options that is generated from the database.

I need to insert values into a table only if they have been selected by the user.

 

each name of the check boxes starts with area and then the id. eg: area1, area2 etc..

 

I am pretty sure i need a for loop I'm just not to sure about the format.

 

Thanks in advance.

[bcode]

if(isset($POST[area1]){
run code here
}

[rvdb86]

thanks for the reply but maybe i did not explain the problem properly.

 

Because the list of check boxes is generated from a database I do not know how many options the user will have.

therefore I cannot use the following code:

if (isset(area1)){
code
}

if (isset(area2)){
code
}

 

I think I need to create an array of all the $_POST variables that start with area and then insert their values.

 

Again this is a guess and I may be wrong. However I hope the problem is clearer now.

[Jnerocorp]

How many areas are there to chose from?

 

-John

[rvdb86]

I don't know how many areas there will be as the user will be able to add and remove areas from the database.

[mikesta707]

what do your checkboxes look like? they should be of the format

<input type="checkbox" name="boxes[]" value="something" />clicky
<input type="checkbox" name="boxes[]" value="somethingelse" />clicky1
<input type="checkbox" name="boxes[]" value="athirdvalue" />clicky2

 

when you submit a checkbox, on the values that were selected will be in the $_POST['boxes'] array.

[Jnerocorp]

and on the processing page

 

you would put:

 

$boxes = $_POST['boxes'];

foreach ($boxes as $b) {
echo $b."<br />";
}

[rvdb86]

Great guys it works a treat