save checkbox values in a db

eye

Hi all,

I need some help here. I'm trying to save some values in my db if you click on selected operating system.
...
for ($i=0; $i<count($checkbox); $i++)
mysql_query ("INSERT INTO os (checkbox) values (".$checkbox[$i].")");
...
<input type="checkbox" name="checkbox[]" value="BSD">
BSD <br>
<input type="checkbox" name="checkbox[]" value="Linux">
Linux<br>
<input type="checkbox" name="checkbox[]" value="Unix">
Unix<br>
...

This script won't work 🙁, don't know why, anyway but how can I make possible to put values in a db ?

Thank you for any help.

Eye

rIkLuNd

Try This:


<?php
for ($i=0; $i<count($checkbox); $i++) 
{
   mysql_query ("INSERT INTO os (checkbox) values ('".$checkbox[$i]."')");
}
?>
... 
<input type="checkbox" name="checkbox[0]" value="BSD"> 
BSD <br> 
<input type="checkbox" name="checkbox[1]" value="Linux"> 
Linux<br> 
<input type="checkbox" name="checkbox[2]" value="Unix"> 
Unix<br> 
...

eye

It's not working 🙁, any other idea or solution for my problem ?

rIkLuNd

maybe you've got to use the $POST or $GET variable???

eye

Could be, but how ?
With implode () should be also possible, always same question "how"?

PHP-Editors_com

See my reply on this post , it a very similiar problem.

eye

Thanks. I tried allready (script above) without db like:

xy.php
...
$sports = array ("bball", "soccer", "badminton");
$i_max = count($sports);
for ($i=0;$i<$i_max;$i++) {
echo "<input type=\"checkbox\" name=\"sport[]\" value=\"".$sports[$i]."\"> ".$sports[$i]."\n";
}
query.php
...
$i_max = count($sport);
for ($i=0;$i<$i_max;$i++) {
echo (in_array($sport[$i],$sports)) ? $sport[$i]."" : $sport[$i]." selected";
}

It will show you like: soccer selected
I tried similar way in script above with db, didn't worked.
To put values in a db isn't same way ?