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 vote292 views1 answer
Php split large text on line breaks into array
PHP
43 votes324 views2 answers
Array count items
PHP
8 votes297 views3 answers
Php get timezone
PHP
12 votes343 views2 answers
Timestamp false in laravel
PHP Laravel
0 vote319 views1 answer
Laravel easy form
PHP
3 votes328 views2 answers
Creating default object from empty value
PHP
0 vote356 views1 answer
Disable laravel cors
PHP
0 vote309 views1 answer
Convert any date to db date in suitecrm
PHP
12 votes323 views3 answers
How to log object laravel logger
PHP
0 vote309 views1 answer
Edit paginator object
PHP