too long

Question

This question already has an answer here:

• getting multiple checkboxes names/id's with php 4 answers

I have SQL database which has a table (results) that is gonna save all of the results of my survey.

One of the questions is checkbox (multiple answer), so I made a code that should gather the results of checkbox questions and put its values into the database.

But, something's missing, it overwrites the last value in the array so obviously there is an easy solution which I cannot see. To clarify, I want to store all values of one checkbox question if user checks everything.

HTML FORM

<input type="checkbox" name="checkbox1" value="This is the first value">
<input type="checkbox" name="checkbox1" value="This is the second value">
<input type="checkbox" name="checkbox1" value="This is the third value">

PHP SCRIPT

for($i=1;$i<101;$i++) {
    if(isset($_POST['checkbox'.$i])) {
        $q[$i] .= $_POST['checkbox'.$i].'; ';
    }}

<?php
$db =& JFactory::getDBO(); 
$query = "INSERT INTO jos_results(question1) VALUES ('$q[1]')"; 
$db->setQuery($query); 
$db->query();
?>

</div>

Answer 1

If the name of check box type is same then use array then only it will work. like here

<input type="checkbox" name="checkbox1[]" value="This is the first value">
<input type="checkbox" name="checkbox1[]" value="This is the second value">
<input type="checkbox" name="checkbox1[]" value="This is the third value">