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

31 votes299 views3 answers
Carbon laravel use
PHP
1 vote303 views1 answer
Syntax error or access violation: 1072 Key column 'user_id' doesn't exist in table (SQL: alter table `groups` add constraint `groups_user_id_foreign` foreign key (`user_id`) references `users` (`id`))
PHP
4 votes299 views2 answers
Laravel eloquent get first
PHP
1 vote292 views1 answer
Laravel check if eloquent just created
PHP
2 votes312 views3 answers
Laravel check if field has changed
PHP Laravel
0 vote268 views1 answer
Add brackets to string php
PHP
1 vote308 views1 answer
Laravel emial unique igration error
PHP
0 vote339 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP Laravel
4 votes369 views2 answers
Add class to body class wordpress
PHP Wordpress
5 votes331 views2 answers
How to clear session in laravel
PHP Laravel