php多维数组入库的问题

Question

Array
(

[name] => Array
    (
        [0] => 打豆豆
        [1] => 111
        [2] => 222
    )

[jine] => Array
    (
        [0] => 111
        [1] => 111
        [2] => 22
    )

[renshu] => Array
    (
        [0] => 11
        [1] => 11
        [2] => 222
    )

)

这样的数组怎么入库 php mysql
name 是一个字段 jine是一个字段 有多少个序号就插入多少条数据 分别对应name jine renshu

Answer 1

<?php
$arr = [
'name'   =>
    [
        '打豆豆',111,111
    ],
'jine'   => [
        '111','111','111'
    ],
'renshu' => [
        11,111,11
    ]
];
// 整理数组
$settle_array = [];
$count = count($arr);
$i     = 0;

while ( $i < $count) {
    $settle_array[] = [
        'name' =>  $arr['name'][$i],
        'jine' =>  $arr['jine'][$i],
        'renshu' =>  $arr['renshu'][$i],
    ];
    ++$i;
}
// 数据入库
insertMore($settle_array);
function insertMore(array $param)
{
    $keys    = [];
    $values  = [];
    $fill    = '';
    $data    = [];
    foreach ($param as $param_key => $param_val) {
        foreach($param_val as $child_key => $child_val){
                array_push($values,$child_val);
        }
        if( is_array($param_val)){
            $fill.= '('.implode(',', array_fill(0, count($param_val), '?')).'),';
        }
    }

    $sql  = 'INSERT INTO `'.$this->table.'` ('.implode(',', array_keys($param[0])).') VALUES '.trim($fill,',');
    $stmt = $this->pdo->prepare($sql);

    $stmt->execute($values);
    $this->errorInfo = $stmt->errorInfo();
    return $this->getLastInsertId();
}