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

3 votes123 views3 answers
Laravel pagination bootstrap 5
PHP
0 vote116 views1 answer
Blade foreach key value
PHP
0 vote140 views1 answer
String match percentage php
PHP
1 vote110 views2 answers
Load session in codeigniter
PHP
5 votes147 views3 answers
Wordpress get_permalink
PHP Wordpress
28 votes158 views6 answers
Laravel make model with migration
PHP Laravel
8 votes170 views3 answers
Magento 2.4.3 how to log
PHP
0 vote134 views2 answers
Get variation id from by product id
PHP
0 vote184 views1 answer
Autoriser les contributeurs à télécharger des images
PHP
1 vote121 views1 answer
Php curl Content-Length
PHP