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

-1 vote257 views1 answer
Tackel discount in javascript
PHP
0 vote236 views1 answer
<?php function find total( $my_list ) { //Insert your code here } ?>
PHP
1 vote262 views1 answer
Laravel profile migration tool
PHP
0 vote243 views2 answers
Get_template_directory_uri
PHP
0 vote245 views1 answer
Codeigniter email print debugger
PHP
0 vote291 views2 answers
Wordpress profile queries
PHP Wordpress
9 votes228 views4 answers
Composer laravel ui
PHP
0 vote241 views1 answer
Call to undefined method CI_DB_mysqli_result::order_by()
PHP
0 vote267 views1 answer
Elasticsearch php search date range
PHP
0 vote238 views1 answer
Create email template php
PHP