/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

8 votes193 views2 answers
Php convert spaces to underscores
PHP
0 vote189 views1 answer
Php and ajax on select option
PHP
0 vote224 views1 answer
Disable cors policy symfony
PHP Symfony
19 votes286 views5 answers
Get url php
PHP
1 vote233 views1 answer
Use of segment in laravel 8
PHP Laravel
0 vote167 views1 answer
Get random post laravel
PHP Laravel
3 votes233 views5 answers
How to create slug in laravel
PHP Laravel
3 votes202 views10 answers
Traductor
PHP
2 votes234 views1 answer
Cakephp 2 savefield
PHP
2 votes196 views1 answer
Php get only numbers
PHP