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

13 votes248 views6 answers
Laravel array validation
PHP
0 vote232 views1 answer
Message"Class 'Input' not found"
PHP
0 vote234 views1 answer
Install Older Version of Laravel using Composer
PHP
1 vote236 views1 answer
Laravel inverse seeder
PHP Laravel
1 vote247 views2 answers
Mac php ini file path
PHP
3 votes220 views2 answers
Replace multiple characters one string php
PHP
1 vote211 views2 answers
Get file name from url in php
PHP
0 vote248 views2 answers
"message": "Call to a member function canNot() on null", "exception": "Symfony\\Component\\Debug\\Exception\\FatalThrowableError",
PHP Symfony
0 vote214 views1 answer
Merge two objects php laravel
PHP
1 vote220 views2 answers
Laravel return response view
PHP Laravel