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

0 vote351 views2 answers
Php json request get value of an array element
PHP
55 votes295 views18 answers
Php generate random number string
PHP
0 vote414 views1 answer
Php faker long text
PHP
6 votes442 views6 answers
Get url parameters in laravel blade
PHP Laravel
1 vote392 views1 answer
Config smp gamil laravel
PHP Laravel
0 vote370 views1 answer
Old value on edit table laravel 6
PHP
4 votes367 views2 answers
Php xml to array
PHP
7 votes348 views5 answers
Laravel foreach loop index
PHP
5 votes372 views3 answers
Laravel created_at where date format
PHP Laravel
43 votes359 views2 answers
Php can't upload gif
PHP