/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 vote188 views1 answer
Laravel datatable columnDefs
PHP Laravel
0 vote172 views1 answer
Yii app db createcommand join yii1
PHP
0 vote268 views1 answer
PHP Warning: Version warning: Imagick was compiled against Image Magick version 1654 but version 1650 is loaded.
PHP
0 vote189 views1 answer
Date format in wordpress post
PHP
0 vote152 views1 answer
Windows list registered applications
PHP
-1 vote229 views1 answer
Php foreach dict get key
PHP
0 vote188 views1 answer
Php 8 union types
PHP
1 vote168 views1 answer
Filemtime($current_file_name);
PHP
1 vote238 views2 answers
Select max laravel
PHP
0 vote167 views1 answer
Php get cosine sim
PHP