Breaking News: Grepper is joining You.com. Read the official announcement!

php bulk insert mysql

Jannat answered on March 11, 2020 Popularity 9/10 Helpfulness 4/10

answer php bulk insert mysql

related how to bulk insert array into sql php

php bulk insert mysql

Comment

$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));

Popularity 9/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: bulk insert mysql php

Link to this answer
Share Copy Link

Contributed on Oct 24 2020

Jannat

0 Answers Avg Quality 2/10

Closely Related Answers

how to bulk insert array into sql php

Comment

$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));

Popularity 9/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: bulk

Link to this answer
Share Copy Link

Contributed on Mar 11 2020

Mobile Star

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

php bulk insert mysql

Contents

More Related Answers

php bulk insert mysql

Closely Related Answers

how to bulk insert array into sql php

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.