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 vote318 views2 answers
Woocommerce show data to cart page
PHP
1 vote355 views1 answer
Php artisan migrate --env=testing
PHP
0 vote331 views1 answer
Laravel faker select between options
PHP
0 vote381 views1 answer
Laravel old value not working in textarea
PHP Laravel
1 vote321 views2 answers
Teaching php in interactive mode
PHP
16 votes331 views4 answers
Wordpress debug mode enabled
PHP
0 vote327 views1 answer
Regex to remove span tags using php [duplicate] codegrepper
PHP
0 vote448 views1 answer
Zend Framework 2 in a ZF1 project
PHP Zend
1 vote270 views1 answer
The iso 8601 date format php
PHP
0 vote316 views1 answer
Laravel query builder select first
PHP