/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

1 vote350 views1 answer
How to change laravel 8 login credentials
PHP
3 votes365 views3 answers
Laravel csrf-token in view
PHP Laravel
0 vote315 views1 answer
Validate rule if row exist laravel
PHP
3 votes329 views2 answers
Undefined method JeroenNoten\LaravelAdminLte\Helpers\MenuItemHelper::isSearchBar()
PHP
1 vote403 views1 answer
Laravel set config value dynamically
PHP Laravel
0 vote402 views1 answer
Request file create cammand laravel
PHP Laravel
7 votes346 views5 answers
Php undefined index
PHP
2 votes382 views2 answers
Laravel insert timestamp now
PHP Laravel
0 vote342 views1 answer
Php registration form and login in same page
PHP
0 vote379 views1 answer
Toggle between login and logout buttons php
PHP