How to insert array result into mysql using prepared statement in PHP

Question

I use to insert records into mysql using prepared statement,for non-array value the below code is fine but for the array types posted it gives me the error:

Array to string conversion

index.php

<input type="text" name="test[]" /> 
<input type="text" name="test1[]" />

OUT PUT

 [test] => Array ( [0] => 1 ) [test1] => Array ( [0] => 2 )

PHP insert ( the posted data is in array )

$test=array_map('trim',$_POST["test"]);
$test1=array_map('trim',$_POST["test1"]);

$stmt = $conn->prepare("INSERT INTO test(v1,v2) VALUES (?,?)");
stmt->bind_param("ss",$test,$test1)
stmt->execute();

Now,please help how to insert array data posted html forms using prepared statement into mysql. later I need to record multiple rows using prepared statement. thanks

Possible duplicate of [insert multiple rows via a php array into mysql](https://stackoverflow.com/questions/779986/insert-multiple-rows-via-a-php-array-into-mysql) — Oleg Nurutdinov, Nov 28 '18 at 11:54
Leg Nurutdinov, I search alot but could not find the exact solution for my case, please put your answer if possible. thanks — Zaker Husien Yusofi, Nov 28 '18 at 11:57
Can you provide us with an output of `$test` and `$test1` arrays? — pr1nc3, Nov 28 '18 at 12:16
Your `` is called `test2[]` but in your PHP code you use `$_POST['test1']`? — Cobra_Fast, Nov 28 '18 at 14:16

score 1 · Accepted Answer · answered Nov 28 '18 at 15:45

1

Try this:

$test=array_map('trim',$_POST["test"]);
$test1=array_map('trim',$_POST["test1"]);

$stmt = $conn->prepare("INSERT INTO test(v1,v2) VALUES (?,?)");
$error=false;
foreach($test AS $key=>$value){
    if(! stmt->execute([$value,$test1[$key]])){
       $error=true;  
       break;
    }
}
if($error) // handle error

Running queries in loops like this is what prepared statements are for.

answered Nov 28 '18 at 15:45

AntG

1,291
2
19
29

Thanks antG, its exactly what I need. – Zaker Husien Yusofi Dec 01 '18 at 04:45

How to insert array result into mysql using prepared statement in PHP

1 Answers1