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

6 votes357 views6 answers
Composer install laravel
PHP Laravel
0 vote300 views1 answer
Laravel response download video laravel medialibrary
PHP Laravel
1 vote418 views1 answer
Routing code in drupal 8
PHP Drupal
7 votes294 views1 answer
Php get version
PHP
2 votes296 views1 answer
File_put_contents php json file
PHP
0 vote387 views1 answer
Drupal 9 cache killer kill switch
PHP Drupal
8 votes304 views3 answers
Yesterday php
PHP
0 vote310 views1 answer
Laravel rule unique where
PHP
0 vote293 views2 answers
Php multi elseif statement ternary
PHP
1 vote344 views2 answers
Explode function in laravel
PHP Laravel