Php bulk insert mysql

How to bulk insert array into sql php

$sql = array(); 
foreach( $data as $row ) {
    $sql[] = '("'.mysql_real_escape_string($row['text']).'", '.$row['category_id'].')';
}
mysql_query('INSERT INTO table (text, category) VALUES '.implode(',', $sql));

Php bulk insert mysql

$values = array(); 
foreach($data as $row ) {
    $values[] = '('.$row['id'].', "'.mysql_real_escape_string($row['name']).'")';
}
mysql_query('INSERT INTO table (id, name) VALUES '.implode(',', $sql));

Similar codes

49 votes146 views6 answers
Laravel migration add column to existing table
PHP
0 vote147 views1 answer
Php artisan queue start
PHP Laravel
0 vote150 views1 answer
Php multiplication
PHP
0 vote329 views1 answer
Create model for existing table in laravel
PHP Laravel
3 votes190 views1 answer
Generate autodump laravel
PHP Laravel
0 vote220 views1 answer
Convert stdclass to json in php
PHP
1 vote167 views1 answer
Php beautify json
PHP
0 vote235 views1 answer
How to set cookie expire time in php
PHP
11 votes194 views4 answers
Laravel validator make custom message
PHP Laravel
5 votes154 views2 answers
Laravel group by with where clause
PHP