/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 vote129 views2 answers
Php file download from url
PHP
0 vote143 views1 answer
Laravel request input default value
PHP
11 votes206 views3 answers
Php number format
PHP
28 votes131 views6 answers
Xhr request javascript
PHP
3 votes220 views1 answer
Php expire a session
PHP
0 vote142 views1 answer
Intl extension php ubuntu
PHP
9 votes134 views5 answers
Return view with variable laravel
PHP
1 vote144 views1 answer
Dispatch queue jobs
PHP
1 vote139 views1 answer
Remove all post in wordpress by query
PHP Wordpress
0 vote140 views1 answer
How to get meta information from pagination in laravel controller
PHP