inserting to database in one shot an array mysql

Question

hello all i am having a variable $document_ids=1,2,4,5,8,99,102 and i need to insert each of them individually to my database table like

$shaeredata=mysqli_query
($conn,"insert into docs (dcid,pid) values 
('$dcid','$pid'),('$dcid2','$pid'),('$dcid3','$pid'),('$dcid4','$pid')");
//dcid is each id from the variable $document_ids=1,1022,4,5,8,99,102  
//$dcid=1,dcid2=1022,$dcid3=4 ...... pid is same for all

the problem is that how do i put the values to database as i dont what document_id is going to be there it can be any seperated by coma.

$document_id=Array
(
[0] => 1
[1] => 4
[2] => 5
[3] => 999
[4] => 6
[5] => 7
[6] => 8
) // i have converted it to an array all of these are $dcid $pid=23 for all

Barmar · Accepted Answer · 2015-08-04 00:30:46Z

1

I assume you really mean that $documement_ids isarray(1,2,4,5,8,99,102). If it's a string, you can useexplode` to split it into an array.

You can create an array of all the value pairs, and then use implode to connect them with commas.

$values = implode(',', array_map(function($dcid) use ($pid) {
    return "('$dcid', '$pid')";
}, $document_ids);
$sql = "INSERT INTO docs (dcid, pid) VALUES $values";
mysqli_query($conn, $sql);

answered Aug 4, 2015 at 0:30

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

10 Comments

Rahul aman Over a year ago

is this possible to use more than two parameters in your function like if i want the $value to be like ('$dcid2','$pid','$something'),('$dcid3','$pid','$something') ???

Barmar Over a year ago

You can add more variables to the use() list. use($pid, $something).

Barmar Over a year ago

And if you have multiple arrays, you can add them to array_map(), and add more function parameters.

Barmar Over a year ago

Make it a unique key, and use INSERT IGNORE to skip the ones that are duplicates.

Barmar Over a year ago

Make a unique key on the list of columns that should be unique together. CREATE UNIQUE INDEX dcid_pid ON docs (dcid, pid);.

|

Collectives™ on Stack Overflow

inserting to database in one shot an array mysql

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related