Php pdo multiple insert

function placeholders($text, $count=0, $separator=","){
    $result = array();
    if($count > 0){
        for($x=0; $x<$count; $x++){
            $result[] = $text;
        }
    }

    return implode($separator, $result);
}

$pdo->beginTransaction(); // also helps speed up your inserts.
$insert_values = array();
foreach($data as $d){
    $question_marks[] = '('  . placeholders('?', sizeof($d)) . ')';
    $insert_values = array_merge($insert_values, array_values($d));
}

$sql = "INSERT INTO table (" . implode(",", $datafields ) . ") VALUES " .
       implode(',', $question_marks);

$stmt = $pdo->prepare ($sql);
$stmt->execute($insert_values);
$pdo->commit();

Source: stackoverflow.com

Similar codes

2 votes343 views1 answer
How many files in dir php
PHP
0 vote339 views1 answer
Installation request for pokemon-tcg/pokemon-tcg-sdk-php ^1.2 -> satisfiable by pokemon-tcg/pokemon-tcg-sdk-php[1.2.0]
PHP
7 votes333 views6 answers
Set session in laravel
PHP Laravel
0 vote301 views1 answer
Make fa icon bigger bootstrap
PHP
6 votes329 views2 answers
Laravel debugbar disable in production
PHP
0 vote328 views1 answer
Export laravel path fedora
PHP
0 vote311 views5 answers
Download file laravel s3
PHP
0 vote383 views1 answer
Template string php
PHP
2 votes380 views2 answers
Disable Bitnami Banner Wordpress
PHP
0 vote311 views1 answer
Php huruf besar di awal
PHP