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

55 votes231 views18 answers
Php generate random number string
PHP
8 votes254 views2 answers
Store file into specific directory laravel using storage facade
PHP
2 votes250 views1 answer
Change php max upload size
PHP
14 votes255 views2 answers
Pass php object to javascript
PHP
0 vote257 views1 answer
Drupal 9 modify a views query
PHP
6 votes262 views2 answers
Create migration model and seeder laravel at once
PHP Laravel
0 vote322 views1 answer
Why phpunit don't work in commend laravel
PHP Laravel
4 votes247 views1 answer
Password match laravel
PHP
0 vote280 views1 answer
Log data into file php
PHP
0 vote316 views1 answer
Wordpress custom post type disable add new
PHP Wordpress