/PHP/How to bulk insert array into sql php

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

21 votes203 views4 answers
Php query
PHP
0 vote155 views1 answer
Phpspreadsheet middle align
PHP
9 votes232 views5 answers
Uuid in laravel
PHP Laravel
2 votes186 views2 answers
Echo query in laravel
PHP Laravel
6 votes251 views1 answer
Laravel add attribute migration column
PHP Laravel
1 vote212 views1 answer
Laravel @canany
PHP Laravel
0 vote175 views1 answer
How to add a clock in laravel
PHP Laravel
0 vote192 views1 answer
Laravel storage save file folder on disk
PHP Laravel
-1 vote158 views1 answer
How to check if there is an authenticated user laravel
PHP
1 vote180 views1 answer
Php needle haystack
PHP