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 vote302 views6 answers
Laravel get last id
PHP Laravel
0 vote256 views1 answer
Push collection php
PHP
0 vote308 views1 answer
Php array_pop with key
PHP
0 vote285 views1 answer
Pass variable in laravel ancher tag laravel 8
PHP Laravel
0 vote270 views1 answer
How to develop package beside laravel project
PHP
15 votes304 views6 answers
Laravel migration delete column
PHP
63 votes265 views6 answers
Clear all cache in laravel
PHP
16 votes315 views5 answers
Laravel blade for loop
PHP Laravel
1 vote269 views1 answer
Convert any phone number in us number format php
PHP
0 vote261 views1 answer
Larvel Print last query
PHP