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

7 votes286 views2 answers
Get order by laravel
PHP
19 votes306 views3 answers
Root composer.json requires php ^7.2.5 but your php version (8.0.3) does not satisfy that require
PHP
16 votes308 views2 answers
Composer detected issues in your platform: Your Composer dependencies require a PHP version ">= 7.3.0". You are running 7.2.34
PHP
0 vote311 views1 answer
Push collection php
PHP
1 vote351 views1 answer
Password validation rules laravel
PHP Laravel
0 vote266 views2 answers
Laravel collection->each
PHP
0 vote369 views1 answer
Laravel validating birthdate by 13 years old
PHP Laravel
0 vote416 views1 answer
How to increase the WordPress Multisite Network limit for Maximum Filesize Upload?
PHP Wordpress
0 vote344 views1 answer
Hint extension in visual studio code for laravel
PHP Laravel
4 votes328 views3 answers
Php strict-origin-when-cross-origin
PHP