/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 vote233 views1 answer
Wp_query first post
PHP
0 vote213 views1 answer
What does defined do in php
PHP
0 vote192 views1 answer
Php check session status
PHP
1 vote261 views1 answer
How to add an custom error to validater error in laravel
PHP
51 votes275 views2 answers
Display errors in codeigniter
PHP CodeIgniter
0 vote357 views2 answers
Laravel collection remove duplicates
PHP
0 vote233 views1 answer
How to Limit Excerpt Length in WordPress
PHP
0 vote253 views1 answer
Syntax error, unexpected variable "$result" in D:\wordpress\xampp\htdocs\templete\user_delete.php on line 13
PHP Wordpress
3 votes238 views2 answers
Order number generate laravel
PHP Laravel
0 vote222 views2 answers
Gate and policy in laravel
PHP