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 vote301 views1 answer
[ERROR] InvalidArgumentException: Wrong file in C:\xampp\htdocs\magento2.4\lib\internal\Magento\Framework\Image\Adapter\Gd2.php:64 Stack trace
PHP
-2 votes299 views5 answers
Www.roblox.com
PHP
20 votes315 views1 answer
Png to pdf
PHP
10 votes342 views2 answers
Create folder php
PHP
0 vote248 views1 answer
Php warning: php startup: unable to load dynamic library 'bz2' (tried: \xampp\php\ext\bz2 (the specified module could not be found), \xampp\php\ext\php_bz2.dll (the specified module could not be found)) in unknown on line 0
PHP
2 votes355 views1 answer
Eloquent all only one culomn
PHP
0 vote292 views1 answer
WhereJsonContains laravel
PHP
1 vote301 views3 answers
Php convert special characters to normal
PHP
2 votes320 views2 answers
Php get youtube code
PHP
0 vote366 views1 answer
Codeigniter select where
PHP CodeIgniter