/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

0 vote113 views1 answer
Curl failed laravel centos
PHP Laravel
0 vote93 views1 answer
Laravel (8) - Routing to controller with optional parameters
PHP
0 vote103 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
6 votes95 views2 answers
Create migration model and seeder laravel at once
PHP
0 vote96 views1 answer
Iterating rows in php
PHP
1 vote128 views1 answer
Laravel set config value dynamically
PHP Laravel
1 vote112 views1 answer
Tackle discount in php laravel blade
PHP Laravel
9 votes132 views3 answers
Laravel enum migration example
PHP Laravel
2 votes116 views2 answers
Laravel validation unique email except self
PHP Laravel
1 vote82 views1 answer
Trim laravel
PHP Laravel