how to bulk insert array into sql php

Solutions on MaxInterview for how to bulk insert array into sql php by the best coders in the world

Search
showing results for - "how to bulk insert array into sql php"
Roberta
23 Jan 2017
1$sql = array(); 
2foreach( $data as $row ) {
3    $sql[] = '("'.mysql_real_escape_string($row['text']).'", '.$row['category_id'].')';
4}
5mysql_query('INSERT INTO table (text, category) VALUES '.implode(',', $sql));
6
Jana
08 Jan 2020
1$values = array(); 
2foreach($data as $row ) {
3    $values[] = '('.$row['id'].', "'.mysql_real_escape_string($row['name']).'")';
4}
5mysql_query('INSERT INTO table (id, name) VALUES '.implode(',', $sql));
similar questions
inserting multiple rows in a table using php form into the databasephp merge 2 arraysinsert php codephp insert in arrayphp array insert before keyhow to bulk insert array into sql cimerge array phphow to append one array to another array in phpphp array mergephp array merge for associative arraysphp merge array with same valuephp insert array into mysql tableadd values to array dynamically phpphp pdo random multiple insert queryphp combine values of two arraysmerge array in phpphp pdo multiple insertlaravel eloquent bulk insertarray merge in phpphp combine arraysunion of two arrays in phpphp array splice insert array in arrayhow to add two array in single array without repetation in php
queries leading to this page
php sqlsrv bulk insertinsert batch core phpinsert values batch in phpphp insert array into mysqlarray bulk phpphp sql server bulk updateinsert bulk data with count phpmultiple row data data insert in phpinsert bulk to mysql pdobulk data insert in database using phprun multiple inserts in a query phpphp code to insert multiple values in mysql table bulk insert mysqlphp bulk insert from arrayinsert multi data in arry to database with phphow to insert multiple rows in database using array in php with codephp multiple create rowbulk insert query in php 5cphp batch insert mysqlarray bulk data phpinsert boolean in mysql from node jsbulk create phpfunction for multiple array value insert into mysqlmysql insert multiple rows from arrayinsert into varchar array of string sqlautomatic bulk insertion in php using phpmysql bulk insertbulk insert phpone time two database insert value same time phpinsert batch mysql phphow to insert multiple rows in mysql using php forminsert encrypted data into sql tablemysql insert multiple records using assocative array phpquery string arry for bluk of data in phpphp mysql bulk insertbulk insert in sql phpmysql insert array into multiple rowsimplode bulk insert mysql phpphp bulk insert mysqlbulk insert in sql using phpbulk insert php mysqlinsert bulk data to db using php scriptbulk insert in php through apimysql bulk insert phpbulk insert into mysql database php examplebulk mysqlinsert bulk data in mysql using phpbulk insert from array in phphow to bulk insert array into sql phphow to batch add data to db with phpmysqli bulk insertphp mysql massive insertphp code to insert bulk data in one querybulk insert in mysql using phpbulk insert into mysql database phphow to bulk insert multiple array in mysql phpbulk update mysql phpinsert into multiple string in varchar sql array value bulk insert in phphow to make one query function for multiple insertion php mysql mass insertphp bulk insert sqlphp bulk inserthow to bulk insert array into sql php