PHP Checkbox problem

[kevinkhan]

I have this form

 

<?php  echo "<input class=\"events\" type=\"checkbox\"  name=\"events[]\"  value=\"Teenage Discos\" /><span>Teenage Discos</span><br />";?>
            <?php  echo "<input class=\"events\" type=\"checkbox\"  name=\"events[]\"  value=\"Teenage Discos\" /><span>Teenage Discos</span><br />";?>
            <?php  echo "<input class=\"events\" type=\"checkbox\"  name=\"events[]\"  value=\"Teenage Discos\" /><span>Teenage Discos</span><br />";?>
            <?php  echo "<input class=\"events\" type=\"checkbox\"  name=\"events[]\"  value=\"Teenage Discos\" /><span>Teenage Discos</span><br />";?>
            <?php  echo "<input class=\"events\" type=\"checkbox\"  name=\"events[]\"  value=\"Teenage Discos\" /><span>Teenage Discos</span><br />";?>

 

and trying to extract the values out and insert them into a database..

 

$events = $_POST['events'];

$query = "INSERT INTO user
                    (
                    events
                    )
                    VALUES
                    (
                    '{$events}'
                    )";
             
       
           $result = mysql_query($query, $connection);

 

When i go to the database it shows up as array.. How do i get it to show up as the values?

 

Thanks

[PHP Monkeh]

$_POST['events'] is an array because you have multiple checkboxes.  So you'll need to loop through each of the checkboxes when doing your insert:

 

for($i=0; $i<count($_POST['events']); $i++)
{
mysql_query("INSERT INTO user (events) VALUES ('" . $_POST['events'][$i] . "')", $connection);
}

[kevinkhan]

my query is actually like this

 

$firstName = mysql_prep($_POST['firstName']);
          $lastName = trim(mysql_prep($_POST['lastName']));
          $mobile = mysql_prep($_POST['mobile']);
          $email = mysql_prep($_POST['email']);
          $county = trim(mysql_prep($_POST['county']));
          $dateOfBirth = mysql_prep($_POST['date3']."-".$_POST['date2']."-".$_POST['date1']);
          $gender = trim(mysql_prep($_POST['gender']));
          $events = $_POST['events'];
          $comments = trim(mysql_prep($_POST['comments']));



$query = "INSERT INTO user
                    (
                    firstName,lastName,mobile,email,county,dateOfBirth,gender,events,comments
                    )
                    VALUES
                    (
                    '{$firstName}','{$lastName}','{$mobile}','{$email}','{$county}','{$dateOfBirth}','{$gender}','{$events}','{$comments}'
                    )";

 

is there anyway of linking your code into this?

[jl5501]

if the events column of your database just takes a comma separated string of the values of the checked checkboxes then

where you have

$events = $_POST['events'];

you could have

$events = implode(",",$_POST['events']);

[kevinkhan]

Thanks thats exactly what i was looking for