Php insert array into mysql

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 insert array into mysql table

$matstring=implode("','",$matrix[1]);
mysql_query('INSERT INTO Australia (Price, Company, Days, Weight) VALUES ('$matstring')');

Source: stackoverflow.com

Php insert array into mysql

if(is_array($records)){
    foreach ($records as $row) {
        $fieldVal1 = mysqli_real_escape_string($conn, $row[0]);
        $fieldVal2 = mysqli_real_escape_string($conn, $row[1]);
        $fieldVal3 = mysqli_real_escape_string($conn, $row[2]);
 
        $query ="INSERT INTO programming_lang (field1, field2, field3) VALUES ( '". $fieldVal1."','".$fieldVal2."','".$fieldVal3."' )";
        mysqli_query($conn, $query);
    }
}

Source: phpflow.com

Similar codes

0 vote246 views1 answer
Push key and value in laravel
PHP Laravel
0 vote250 views1 answer
Tinyinteger laravel +size
PHP Laravel
1 vote227 views1 answer
Laravel task scheduling command
PHP
12 votes332 views4 answers
Wordpress get post thumbnail
PHP Wordpress
18 votes190 views5 answers
Create model, controller and migration in single command laravel
PHP
0 vote205 views1 answer
Phpfiddle
PHP
58 votes183 views6 answers
In_array php
PHP
4 votes195 views2 answers
Delete all rows in table laravel
PHP
16 votes189 views2 answers
Php get first character of each word
PHP
0 vote227 views1 answer
Laravel run seeder enter timestamps
PHP