Entering multiple check box value into the database with php

Asked Oct 04 '13 at 05:54

Active Oct 04 '13 at 06:01

Viewed 1,009 times

I'm trying to enter multiple check box value into the database, the thing is, only those checkbox value will be entered which are checked and im doing it with PDO, but it is just not inserting the value, here is my code-

HTML

<li><input class="check" type="checkbox" name="checkbox[]" value="1"     checked="checked"/>Accesories</li>
<li><input class="check" type="checkbox" name="checkbox[]" value="2" checked="checked"/>Bags</li>
<li><input class="check"  type="checkbox" name="checkbox[]" value="3" checked="checked"/>Caps & Hats</li>
<li><input class="check" type="checkbox" name="checkbox[]" value="4" checked="checked"/>Hoodies & Sweatshirts</li>

PHP

$checkbox = $_POST['checkbox'];

for($i=0; $i<sizeof($checkbox);$i++)
{
    $insersql = "INSERT INTO user_branch(branch_id,user_id) SELECT :checkbox, user.user_id FROM user WHERE email=:email";
    $stmt=$dbh->prepare($insersql);
    $stmt->bindparam(":checkbox",$checkbox[$i]);
    $stmt->bindparam(":email",$email);
    $stmt->execute();
}

edited Oct 04 '13 at 06:01

Fluffeh

33,228
16
67
80

asked Oct 04 '13 at 05:54

user2845328

Check `$_POST['checkbox']` values - `var_dump` or `print_r` – u_mulder Oct 04 '13 at 05:58
If you haven't got `$email` set, it's not going to work - and I can't see it anywhere in the code provided. – Fluffeh Oct 04 '13 at 06:00
Yes i set that in the code, i just posted the related code to check box – user2845328 Oct 04 '13 at 06:02
@user2845328 http://stackoverflow.com/questions/4997252/get-post-from-multiple-checkboxes check the link – Abhi Oct 04 '13 at 06:06
1

Take a look at this answer to find out what the error is when PDO fails - http://stackoverflow.com/a/15990858/689579 – Sean Oct 04 '13 at 06:12
`bindParam`? (note the capital *P*) – DrColossos Oct 04 '13 at 14:59

Entering multiple check box value into the database with php

0 Answers0