/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

40 votes339 views6 answers
Php remove element from array
PHP
0 vote385 views1 answer
Régler l’enregistrement automatique dans WordPress
PHP
3 votes351 views1 answer
Run laravel cron job on cpanel
PHP
134 votes609 views6 answers
Php find if string contains
PHP
0 vote335 views2 answers
How do we calculate average in laravel 8
PHP
4 votes346 views3 answers
Install php7.4 linux
PHP
0 vote336 views1 answer
Php header redirect same page
PHP
0 vote322 views1 answer
Class PHPUnit_Util_Log_TeamCity does not exist
PHP
1 vote340 views1 answer
Laravel parent child same table
PHP
0 vote341 views1 answer
Hint extension in visual studio code for laravel
PHP