Multidimensional array to MySQL

Question

I've got a form like so:

    Question: <input type="text" name="question[][text]" id="question" />
    Type: 
    <select name="question[][type]" id="type">
    <option value="1to5scale">1 to 5 scale</option>
    <option value="freetext">Open text</option>
    </select>

This gets repeated depending on how many items the user wants (cloned through jquery). And my php to action the form contains:

foreach ( $_POST['question'] as $key=>$question )
{
    if ($key >= 1) {
    $question_text = $question['text'];
    $type = $question['type'];
    $query = " INSERT INTO questions (question_text, survey_id, type) ". 
    " VALUES ('$question_text','$survey_id', '$type')"; 
    mysql_query($query) or die('Error ,query failed');
    }
}

Each question has a text item and a type item. However in the DB it's adding one row per question item (if that makes sense...), rather than one row per complete question. Any ideas where I'm going wrong, it's quite hard to debug forms I'm finding...

i can see those security holes from space!

Alec Gorge
– Alec Gorge

2011-02-27 19:08:55 +00:00
Commented Feb 27, 2011 at 19:08 — Alec Gorge
– Alec Gorge, Commented Feb 27, 2011 at 19:08
Agreed. Quick and dirty whilst I work out the logic.

trh88
– trh88

2011-02-27 20:56:21 +00:00
Commented Feb 27, 2011 at 20:56 — trh88
– trh88, Commented Feb 27, 2011 at 20:56

Explosion Pills · Accepted Answer · 2011-02-27 19:24:14Z

1

Change the form element name from question[][type] to question[type][]. What this form does is add to the question array for each form element ([] means add a new array element).

As the comment implies, make sure you sanitize the input.

answered Feb 27, 2011 at 19:24

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

Collectives™ on Stack Overflow

Multidimensional array to MySQL

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related