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 vote405 views1 answer
Find the next 7 date data in laravel eloquent
PHP Laravel
0 vote405 views1 answer
Make controller laravel history open link
PHP Laravel
0 vote327 views1 answer
Twig\Error\SyntaxError: Unknown "file_uri" function. Did you mean "file_url"?
PHP
7 votes424 views2 answers
Reset wordpress password in database
PHP Wordpress
6 votes270 views1 answer
Change website address wordpress
PHP
0 vote313 views2 answers
Show query in laravel
PHP
3 votes337 views1 answer
Php grab year from date
PHP
0 vote367 views1 answer
Laravel return a single dimensional array
PHP Laravel
0 vote423 views1 answer
Get thumbnail alt wordpress
PHP Wordpress
1 vote399 views2 answers
Get the current page id in wordpress
PHP Wordpress