PDO MySQL：在一个查询中插入多行?mysql

您好，我正在制作一个在pdo中进行多次插入的类。

是这样的

INSERT INTO $table (key1,key2,key3,etc) VALUE (value1,value2,value3,etc), (value1,value2,value3,etc), (value1,value2,value3,etc) 搜索后，我发现我必须建立类似

INSERT INTO $table (key1,key2,key3,etc) VALUE (:key1,:key2,:key3,etc), (:key1,:key2,:key3,etc), (:key1,:key2,:key3,etc) 然后用这个执行$this->execute($data); ，其中$data是

0 => array 'key1' => 'value1' 'key2' => 'value2' 'key3' => 'value3' 1 => array 'key1' => 'value1' 'key2' => 'value2' 'key3' => 'value3'

etc 问题是我还得到一个错误Array to string conversion就$insert->execute($data);如何解决呢？

这是我正在做的一小段。

public function multipleInsert($table, $data = array()) {

# INSERT (name) VALUE (value),(value)
if (count($data) > 1) 
{
    $fieldnames = array_keys($data[0]);
    $count_inserts = count(array_values($data));
    $count_values = count(array_values($data[0]));

    # array(????) untill x from first data
    for($i = 0; $i < $count_values; $i++)
    {
        $placeholder[] = '?';
    }

    # array((????),(????),(????)) for query
    for ($i=0; $i < $count_inserts; $i++) 
    { 
        $placeholders[] = '('. implode(',',$placeholder) . ')';
    }

    $query  = 'INSERT INTO '. $table;
    $query .= '(`'. implode('`, `', $fieldnames) .'`)';
    $query .= ' VALUES '. implode(', ', $placeholders);

    $insert = $this->start->prepare($query);

    $i = 1;
    foreach($data as $item) 
    {
        foreach ($item as $key => $value) 
        {
           $insert->bindParam($i++, $item[$key]);
        }
    }

    echo $query;
    $insert->execute();

    $return['status'] = true;
    $return['lastid'] = $this->start->lastInsertId();

    return $return;
} 
else 
{
    die('$data is less then two array, use single insert instead.');
}

}