Insert multidimensional array into mysql database with each array as mysql column

Question

Need to insert PHP array into mysql database as each array as column.

$test_array = array((1,2,3),(test1,test2,test3));

And output like

1   test1

2   test2

3   test3

UPDATE

foreach($test_array AS $test){
              $info_item = array(
                  "name"   => $test[0],
                  "name1"   => $test[1],
               );   
  $id = $fun_obj->insert($info_item,'test_table');
}

like this inserting each array as row.but i need each array as column

Thank you

Welcome to SO, please consider the following article to get some help. — hassan
– hassan, Commented Jan 22, 2018 at 11:56
Please add the code you use for that and specify the problem you have with it. — Philipp Maurer
– Philipp Maurer, Commented Jan 22, 2018 at 11:56
You just need a loop for your array to insert it's not that hard. What have you tried so far? — pr1nc3
– pr1nc3, Commented Jan 22, 2018 at 12:00
yes i tried.using loop each array inserting as new row.i need each array as coulmn — Aishu
– Aishu, Commented Jan 22, 2018 at 12:05

Strawberry · Accepted Answer · 2018-01-22 12:13:37Z

3

<?php

$test_array = array(
                    array(1,2,3),
                    array('test1','test2','test3')
                   );

$new_array = array_map(null, $test_array[0], $test_array[1]);

print_r($new_array);

?>

Outputs:

Array
(
    [0] => Array
        (
            [0] => 1
            [1] => test1
        )

    [1] => Array
        (
            [0] => 2
            [1] => test2
        )

    [2] => Array
        (
            [0] => 3
            [1] => test3
        )

)

answered Jan 22, 2018 at 12:13

Strawberry

34k14 gold badges43 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Insert multidimensional array into mysql database with each array as mysql column

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