/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 votes114 views1 answer
Install php 8.1 fpm and all modules on ubuntu
PHP
1 vote140 views1 answer
How validate data if is exist must not be empty in laravel
PHP
1 vote185 views1 answer
Insert into wp table
PHP
0 vote130 views2 answers
Export database to sql dump in php
PHP
18 votes141 views6 answers
Laravel carbon create date from string
PHP Laravel
3 votes116 views1 answer
Get information from another website
PHP
4 votes144 views2 answers
How to Get Last Executed Query in Laravel
PHP
0 vote135 views1 answer
How to set select option value dynamically in php
PHP
38 votes145 views6 answers
Create seed file laravel
PHP Laravel
13 votes165 views6 answers
How to create model in laravel
PHP Laravel