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 vote209 views1 answer
Run phpcs from vs code for wordpress
PHP
1 vote202 views1 answer
Integer default value laravel
PHP
0 vote158 views1 answer
Fatal error: cannot redeclare
PHP
0 vote214 views2 answers
How do i use php read excel file
PHP
0 vote254 views1 answer
Include navbar or part in layout in laravel blade template
PHP Laravel
0 vote207 views1 answer
Hash not found laravel
PHP
1 vote211 views1 answer
How to upload pdf file using php
PHP
6 votes197 views5 answers
Laravel disable cors
PHP
20 votes208 views6 answers
Cmd run php file
PHP
0 vote214 views2 answers
Launch uikit modal from php
PHP