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

3 votes138 views1 answer
Carbon parse subday
PHP
0 vote162 views1 answer
Laravel cmd add to column
PHP Laravel
0 vote131 views1 answer
Wordpress custom post type disable add new
PHP
0 vote130 views1 answer
Laravel restrict route methods
PHP
0 vote169 views1 answer
Wp plugins action link
PHP Wordpress
2 votes176 views2 answers
Laravel migration column type json
PHP Laravel
0 vote177 views1 answer
Deleting all files inside a directory laravel 8
PHP Laravel
3 votes128 views1 answer
Php define strict types
PHP
0 vote127 views1 answer
Cant upload file to directory php
PHP
0 vote129 views1 answer
Laravel project htaccess redirect to public path
PHP