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

0 vote241 views1 answer
Tailwindcss - bootstrap - vue - react
PHP
0 vote246 views1 answer
Php-oop
PHP
10 votes269 views4 answers
Error_log wordpress
PHP
0 vote332 views1 answer
Action after model is created laravel
PHP
0 vote260 views1 answer
Php include external directory path
PHP
0 vote257 views5 answers
Movie Name -inurl:(htm|html|php|pls|txt) intitle:index.of “last modified” (mp4|wma|aac|avi)
PHP
0 vote247 views1 answer
Tina4 create route
PHP
0 vote263 views1 answer
Blocking youtube adds in php
PHP
47 votes284 views4 answers
Substr() php
PHP
9 votes268 views3 answers
Alias seeddb='php artisan db:seed'
PHP