save data into db from 2 dimensional array - php

Question

I have 2 dimensional array to be save into mysql. The problem is, how do i get the data from that array and save it into DB Here is my array:

Array
(
[1a] => Array
    (
        [ans] => 1
    )

[2a] => Array
    (
        [ans] => 1
        [oth] => ABC
    )

[3a] => Array
    (
        [ans] => 1
    )

[3b] => Array
    (
        [ans] => 2
    )

[3f] => Array
    (
        [oth] => 
    )

)

so when saved, it will be look like this:

| qid | ans | oth |
===================
|  1a |  1  |     |
|  2a |  1  | ABC |
|  3a |  1  |     |
|  3b |  2  |     |
|  3f |     |     |
===================

please help me n thanks.

Could you provide a bit more information regarding your columns, whether or not the columns accept NULL values, if not what are their defaults? It'll make a big difference in the structure of any solution. — CBusBus
– CBusBus, Commented Jan 18, 2012 at 4:54

Ashraf · Accepted Answer · 2012-01-18 04:31:25Z

1

Let say you have the array with name x

foreach($x as $key=>$details)
{
   $qid = $key;
   $ans = $details["ans"];
   $oth = $details["oth"];
   //Then Save to DB
   // Insert into table (qid,ans,oth) values('$qid',$ans,'$oth') ...

}

answered Jan 18, 2012 at 4:31

Ashraf

2,6091 gold badge23 silver badges38 bronze badges

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

5 Comments

CBusBus Over a year ago

This doesn't cover the entries where those array keys don't exist. The OP will need to provide column details (NULL, DEFAULT) before you can handle them though.

Ashraf Over a year ago

I think the vars $oth and $ans will get the NULL value if there was no array key while looping , then the default value of the columns in the table will be inserted . thank you .

CBusBus Over a year ago

It wouldn't work that way sadly. If you don't use isset($array[<key] the script will though errors and if it did Sql wouldn't translate the ("1a",,) missing values into NULL.

Ashraf Over a year ago

I agree the second sentence ("1a",,) , but i think it won't throw php errors .

CBusBus Over a year ago

It'll depend on the version of Php; they've been strict about array keys since 5.3

xdazz · Accepted Answer · 2012-01-18 04:31:28Z

0

foreach ($your_array as $qid => $value) {
   $ans = isset($value['ans']) ? $value['ans'] : null;
   $oth = isset($value['oth']) ? $value['oth'] : null;
   //then you get the $qid, $ans, $oth and insert them to the db.
   ....
}

answered Jan 18, 2012 at 4:31

xdazz

161k38 gold badges255 silver badges278 bronze badges

Collectives™ on Stack Overflow

save data into db from 2 dimensional array - php

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related