inserting items into db from checkbox

[perezf]

Hi guys i have these checkboxes that im trying to insert into a db separated by the pipe symbol,

How can i do it?

 

these are my checkboxes

 

<input type="checkbox" name="interestlifestyles[]" value="1">
<input type="checkbox" name="interestlifestyles[]" value="2">
<input type="checkbox" name="interestlifestyles[]" value="3">
<input type="checkbox" name="interestlifestyles[]" value="4">
<input type="checkbox" name="interestlifestyles[]" value="5">

[BlueSkyIS]

assuming the form is POST'ed:

 

$in_value = implode('|',$_POST['interestlifestyles']);
$sql = "INSERT INTO some_table (some_field) VALUES ('$in_value')";

[perezf]

Yes the form is posted

I tried what you said

and it only inserted the first item, but i selected multiple checkboxes but it didnt add them all just the first

[BlueSkyIS]

you want all selected values separated by a pipe symbol, then inserted into a single field, correct? if so, this works for me:

 

<?php
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$in_value = implode('|',$_POST['interestlifestyles']);
$sql = "INSERT INTO some_table (some_field) VALUES ('$in_value')";
echo $sql;
}
?>
<FORM METHOD='POST'>
<input type="checkbox" name="interestlifestyles[]" value="1">
<input type="checkbox" name="interestlifestyles[]" value="2">
<input type="checkbox" name="interestlifestyles[]" value="3">
<input type="checkbox" name="interestlifestyles[]" value="4">
<input type="checkbox" name="interestlifestyles[]" value="5">
<INPUT TYPE='submit'>
</FORM>

 

output:

 

INSERT INTO some_table (some_field) VALUES ('1|2|4')

 

[perezf]

It is only inserting 1 of the checkboxes

[BlueSkyIS]

did you run my code? what did the echo'd SQL look like?

[johne90]

I have had an issue with this before.

 

I ended up just doing something like this:

 

<?php
foreach($_POST['interestlifestyles'] as $value){
$string="id='$field' or ".$string;
}

$string = substr($string, 0, -3);
$sql = "INSERT INTO some_table $string";
?>