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 vote173 views1 answer
Html table to array php
PHP
7 votes179 views3 answers
Laravel table in model
PHP Laravel
6 votes164 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP Laravel
5 votes142 views2 answers
Php variables as keys in arrays
PHP
0 vote175 views1 answer
Laravel delete controller still cached
PHP Laravel
2 votes140 views2 answers
Php delete directory
PHP
1 vote142 views1 answer
Npm watch laravel
PHP
0 vote117 views1 answer
Hummingbird remove caching specific page php
PHP
0 vote136 views2 answers
Laravel allow all fillable
PHP
1 vote163 views1 answer
Remove html tags from a string except p in php
PHP