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 vote139 views1 answer
Check if post id exists wordpress
PHP
0 vote148 views1 answer
Trying to access variable outside laravel collection
PHP Laravel
7 votes154 views10 answers
Php .com
PHP
6 votes144 views3 answers
Laravel $loop->iteration
PHP Laravel
26 votes118 views6 answers
Laravel migration rollback
PHP
6 votes149 views4 answers
Illuminate database queryexception could not find driver laravel
PHP
1 vote168 views1 answer
Laravel realation with has
PHP
2 votes150 views5 answers
Php last day of month
PHP
5 votes161 views2 answers
Exec output php
PHP
9 votes130 views3 answers
Start php session
PHP