/PHP/How to bulk insert array into sql php

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 vote124 views2 answers
Close connection pdo
PHP
0 vote151 views1 answer
Wordpress function _() not working
PHP Wordpress
0 vote132 views1 answer
How to read laravel query string with dash
PHP
0 vote155 views1 answer
Eine Breadcrumb-Navigation ohne Plugin erstellen
PHP
0 vote130 views1 answer
Class PHPUnit_Util_Log_TeamCity does not exist
PHP
0 vote136 views1 answer
If session is empty laravel
PHP Laravel
42 votes173 views5 answers
Create controller laravel with model
PHP
9 votes126 views3 answers
Alias seeddb='php artisan db:seed'
PHP
1 vote121 views2 answers
Typo3 debug
PHP
3 votes136 views1 answer
Auth::loginUsingId
PHP