Using multiple checkboxes

[dreampho]

Hi All!!

 

I am a little confused. I have a form where I want around 15 different checkboxes, all or some of these can be checked. When the form is sent I insert the fields into a database. I am wondering how I can have only the fields checked saved into the database, without having to have a row for each field.

 

Thanks

Chris

[fugix]

you would probably make a field for each button that you have, and when the value of a certain button is passed, save that one, or those, into your db using one row

[dreampho]

Sorry I am a bit confused.

 

Say I have three checkboxes, if I do this:

 

<?php
try{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$database = new PDO('mysql:host=localhost;dbname=db', 'username', 'password', $pdo_options);  

$execution=$database->prepare('INSERT INTO db(checkbox1, checkbox2, choeckbox3) VALUES(:checkbox1, :checkbox2, :checkbox3)'); 
$execution->execute(array('checkbox1' => $_POST['Checkbox1'],
         'checkbox2' => $_POST['Checkbox2'],
     'checkbox3' => $_POST['Checkbox3']));
<?

 

I would have to have a separate row for each checkbox in the database wouldnt I?

[dreampho]

Sorry, I meant column

[fugix]

yes that is what I was talking about

[dreampho]

Sorry, I am confusing myself here. What I was hoping was there was someway to only save the results that were checked in the same column, rather than have 15 columns. Any ideas?