/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

0 vote159 views1 answer
Drupal 9 loop term objects to retrieve term data (id, name, uuid)
PHP Drupal
1 vote150 views3 answers
Laravel api enable cors
PHP
0 vote106 views1 answer
Index:of curiosa 2019 mp4
PHP
1 vote104 views3 answers
Laravel eloquent to array key value
PHP
0 vote104 views1 answer
Create if not exist laravel
PHP
5 votes105 views2 answers
Laravel vue
PHP
0 vote107 views1 answer
Drop down list display only seleted item only
PHP
0 vote103 views1 answer
Sql update views +1
PHP
0 vote119 views1 answer
Codecept run single test
PHP
0 vote190 views1 answer
Latavel attach method
PHP