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 — Oleg Nurutdinov
– Oleg Nurutdinov, Commented Nov 28, 2018 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
– Zaker Husien Yusofi, Commented Nov 28, 2018 at 11:57

AntG · Accepted Answer · 2018-11-28 15:45:06Z

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, 2018 at 15:45

AntG

1,2962 gold badges20 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zaker Husien Yusofi Over a year ago

Thanks antG, its exactly what I need.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related