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

1 vote320 views5 answers
What is PHP
PHP
31 votes347 views3 answers
Carbon laravel use
PHP
8 votes366 views2 answers
How to debug php
PHP
20 votes332 views6 answers
Array random php
PHP
0 vote318 views1 answer
Menyimpan get di laravel
PHP
0 vote351 views1 answer
Laravel 8 Factory - One To Many (Polymorphic) Relationship
PHP
1 vote352 views3 answers
Insert key-value pair into array php
PHP
42 votes362 views6 answers
Laravel cache remember
PHP Laravel
0 vote370 views1 answer
Laravel httaccess for apache
PHP Laravel
1 vote350 views1 answer
Php namespace class
PHP