How to add values from checkbox to database

Question

Let me start by saying that I googled this and tried different things, but I'm still stuck and need some help as this is my first time trying out checkboxes with php... I have a section in my HTML file as follows

<label class="labelStyle" for="text">XXX:</label>
                        <div class="checkboxAlign">
                            <input type="checkbox" name="XX[]" value="Apple">Apple<br>
                            <input type="checkbox" name="XX[]" value="Orange">Orange<br>
                            <input type="checkbox" name="XX[]" value="Strawberry">Strawberry<br>
                        </div>

But I am having trouble with the PHP part of it as it's not adding the checked items to my database.

Try this

if (!empty($_POST['XX']))
{
    foreach($_POST['XX'] as $check)
    {
        if(!($stmt = $mysqli->prepare("INSERT INTO table
            id = (
                SELECT id
                FROM yy
                WHERE xx = ?)"))){  
            echo "Prepare failed: "  . $stmt->errno . " " . $stmt->error;
        }
         if(!($stmt->bind_param("s",  $_POST['XX'])))    { 
        echo "Bind failed: "  . $stmt->errno . " " . $stmt->error;
    }

    }
}

I know the issue is within this php snippet, but I'm not sure what I'm doing wrong. Any help would be appreciated.

Thanks!

WHERE FoodTriggerItem = ? is the syntax

colburton
– colburton

2017-07-08 12:24:17 +00:00
Commented Jul 8, 2017 at 12:24 — colburton
– colburton, Commented Jul 8, 2017 at 12:24
@colburton I tried that too

rose
– rose

2017-07-08 12:24:44 +00:00
Commented Jul 8, 2017 at 12:24 — rose
– rose, Commented Jul 8, 2017 at 12:24
@rose Try my answer

Praveen Kumar
– Praveen Kumar

2017-07-08 12:29:27 +00:00
Commented Jul 8, 2017 at 12:29 — Praveen Kumar
– Praveen Kumar, Commented Jul 8, 2017 at 12:29
@ Praveen Kumar Thanks! Still doesn't work....

rose
– rose

2017-07-08 12:30:10 +00:00
Commented Jul 8, 2017 at 12:30 — rose
– rose, Commented Jul 8, 2017 at 12:30

rose · Accepted Answer · 2017-07-10 05:15:21Z

2

Try this

if (!empty($_POST['XX']))
{
    foreach($_POST['XX'] as $check)
    {
        if(!($stmt = $mysqli->prepare("INSERT INTO table
            id = (
                SELECT id
                FROM yy
                WHERE xx = ?)"))){  //added ? in place of $check
            echo "Prepare failed: "  . $stmt->errno . " " . $stmt->error;
        }
        if(!($stmt->bind_param("s", $check)))    { // added $check in place of $_POST['XX']
            echo "Bind failed: "  . $stmt->errno . " " . $stmt->error;
        }


    }
}

edited Jul 10, 2017 at 5:15

rose

6772 gold badges11 silver badges21 bronze badges

answered Jul 8, 2017 at 12:26

Praveen Kumar

2,3981 gold badge14 silver badges21 bronze badges

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

1 Comment

rose Over a year ago

Actually this works! I just forgot to add something earlier... Thank you!!!

B. Desai · Accepted Answer · 2017-07-08 12:27:01Z

1

change

if(!($stmt->bind_param("s", $_POST['FoodTriggerItem'])))    {
                    echo "Bind failed: "  . $stmt->errno . " " . $stmt->error;
                }

TO

if(!($stmt->bind_param("s", $check)))    {
                    echo "Bind failed: "  . $stmt->errno . " " . $stmt->error;
                }

answered Jul 8, 2017 at 12:27

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

Collectives™ on Stack Overflow

How to add values from checkbox to database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related