Answers for "php code to insert multiple values in mysql table"

PHP

0

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

Posted by: Guest on October-24-2020

Code answers related to "php code to insert multiple values in mysql table"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#