PDO Insert multiple checkbox values in Mysql

Question

I want insert multiple checkbox values in Mysql using PDO.

HTML Form part checkbox

<form action="insert.php">
    <label>
        <input name="check[]" id="check[]" type="checkbox" value="<?=$row['id']?>" />
        <span class="lbl"></span>
    </label>
    <button type="submit" name="send" id="send" >
</form>

PHP Part insert

$checkbox = $_POST['check'];

for (i$=0; $i<sizeof($checkbox);$i++)

    $insert = $pdo->prepare("INSERT INTO table (check_value) VALUES (?)");
    $insert->execute(array(".$checkbox[$i]."));

More when i use ".$checkbox[$i]." give "Notice: Array to string conversion"

There's only one checkbox there. Could you post the whole code, maybe including the php part? I believe this is supposed to be in a loop coming from a database. — afaolek
– afaolek, Commented Jul 23, 2014 at 12:05
“HERE I WANT THE INSTRUCTION FOR INSERT EVERY CHECKBOX VALUE IN A ROW” – there is no such thing. Use a loop. — C3roe
– C3roe, Commented Jul 23, 2014 at 12:06
Beter to move that checkbox out of the label and start using the forattribute — DarkBee
– DarkBee, Commented Jul 23, 2014 at 12:07
Yeah, in truly the checkbox be inside a table, this could help? — tslopes
– tslopes, Commented Jul 23, 2014 at 12:07
I try this "for (i$=0; $i<sizeof($checkbox);$i++)" and 'code'".$checkbox[$i]." — tslopes
– tslopes, Commented Jul 23, 2014 at 12:17

DarkBee · Accepted Answer · 2014-07-23 12:22:20Z

1

One way to do this is build the SQL dynamicaly. Just add as many ? to the SQL as there are checkbox values.

<?php
if (isset($_POST['check'])) {
    $sql = 'INSERT INTO TABLE (check_value) VALUES ({foo})';

    $foo = '';
    foreach($_POST['check'] as $key => $value) $foo .= '?,';
    $foo = rtrim($foo, ',');

    $sql = str_replace('{foo}', $foo, $sql);

    $insert = $pdo->prepare($sql);
    $insert->execute($_POST['check']);
}

answered Jul 23, 2014 at 12:22

DarkBee

14.5k9 gold badges84 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PDO Insert multiple checkbox values in Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related