将多维数组插入mysql数据库，每个数组作为mysql列

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

Answer 1

<?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
        )

)