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 vote230 views2 answers
Laravel pagination layout issue
PHP Laravel
0 vote189 views2 answers
Get custom post type taxonomy value
PHP
0 vote228 views3 answers
Not Found The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/8.0.6 Server at localhost Port 80
PHP
0 vote186 views1 answer
Symfony dump request headers
PHP
0 vote227 views1 answer
Add character after x characters in php
PHP
0 vote232 views1 answer
Php afosto / yaac urn:ietf:params:acme:error:malformed 405
PHP
0 vote177 views1 answer
Auto check a category when creating new post
PHP
1 vote239 views2 answers
Fetch body show in php code
PHP
0 vote299 views2 answers
Wordpress single post template
PHP Wordpress
1 vote181 views1 answer
Get taxonomy name in singhle post
PHP