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 vote231 views6 answers
The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/7.3.28 Server at localhost Port 80 error in laravel
PHP
7 votes251 views3 answers
Php artisan serve port
PHP
0 vote234 views1 answer
Php file date created older than
PHP
1 vote258 views1 answer
Docx file validation laravel 8
PHP
3 votes311 views3 answers
Laravel clear table
PHP Laravel
0 vote298 views1 answer
Array filter php get first object
PHP
0 vote240 views2 answers
Php send values in $_SESSION to other page
PHP
2 votes278 views1 answer
Laravel's collection pagination
PHP Laravel
14 votes280 views6 answers
Laravel create model and migration
PHP
1 vote220 views1 answer
Laravel pusher broadcasting/auth 403
PHP