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 vote112 views1 answer
Laravel use variable inside callback function
PHP
12 votes126 views2 answers
Laravel update from query
PHP
0 vote109 views1 answer
Laravel make directory if not exists
PHP
4 votes106 views1 answer
Laravel deployment
PHP
1 vote106 views5 answers
Laravel validation array input
PHP
0 vote119 views3 answers
#FF0000;
PHP
12 votes106 views6 answers
Laravel validation
PHP
1 vote129 views1 answer
Get child theme path in wordpress
PHP Wordpress
1 vote125 views1 answer
Datediff in hour query builder laravel
PHP
0 vote65 views1 answer
Laravel sintax
PHP