/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

11 votes183 views4 answers
How to check php version in php
PHP
0 vote157 views2 answers
Count with condition laravel
PHP Laravel
0 vote177 views1 answer
Woocommerce php reset password length
PHP
0 vote136 views1 answer
Errno: 150 foreign key constraint is incorrectly formed laravel 8
PHP
0 vote154 views1 answer
How to save the variable from query in mysql with php
PHP
4 votes127 views1 answer
Disable register laravel
PHP
4 votes171 views2 answers
Php read file line by line
PHP
0 vote140 views1 answer
Laravel model uploaded file name
PHP
0 vote135 views2 answers
Sort names alphabetically php
PHP
14 votes171 views5 answers
Laravel model tablename
PHP Laravel