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

40 votes112 views3 answers
H:i:s explode in php by ":"
PHP
0 vote113 views1 answer
Fat-free captcha plugin
PHP
10 votes164 views4 answers
Laravel table data types
PHP
1 vote115 views1 answer
Laravel order by raw
PHP
0 vote114 views1 answer
33
PHP
0 vote114 views1 answer
Error: Class '\App\Models\User' not found in file D:\teraNinga\mazadat\vendor\laravel\framework\src\Illuminate\Auth\EloquentUserProvider.php on line 183
PHP
2 votes120 views2 answers
Laravel foreach first
PHP Laravel
0 vote140 views1 answer
Add multi product at the same time using repearter default view laravel
PHP Laravel
0 vote71 views1 answer
Wordpress get tagline
PHP Wordpress
4 votes131 views2 answers
Ubuntu laravel storage permission
PHP Laravel