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

0 vote154 views1 answer
Laravel keep old input
PHP Laravel
0 vote147 views1 answer
Jwt auth laravel auth without password field
PHP Laravel
0 vote144 views1 answer
Get id by url wordpress
PHP
1 vote185 views3 answers
Laravel invoice toturial
PHP
1 vote156 views1 answer
Laravel 8: seed users + Jetstream teams
PHP Laravel
0 vote129 views1 answer
Php how to make sure user doesn't submit
PHP
2 votes133 views2 answers
Image upload form
PHP
0 vote130 views1 answer
Phpunit/phpunit[dev-master, 9.3.3, ..., 9.4.x-dev] require ext-dom * -> it is missing from your system. Install or enable PHP's dom extension.
PHP
3 votes173 views1 answer
Laravel cannot create an instance of class viewmodel
PHP Laravel
7 votes143 views2 answers
Laravel collection isEmpty
PHP Laravel