/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

2 votes190 views2 answers
Get_boundary_post wordpress
PHP
0 vote255 views1 answer
Text or description laravel database column type
PHP
5 votes195 views1 answer
Check if divisible php
PHP
0 vote170 views1 answer
String lenghth
PHP
33 votes236 views6 answers
How to run a specific migration in laravel
PHP
0 vote265 views1 answer
Symfony 5 - Customize Twig error templates
PHP
0 vote181 views1 answer
Woocommerce change place order button text
PHP
1 vote173 views2 answers
Codeigniter query result
PHP
0 vote201 views1 answer
How to stop message of laravel mix
PHP Laravel
4 votes195 views2 answers
Auth guard (admin) is not defined laravel 8
PHP