foreach循环用于许多数组插入值

Question

hello all i have about 5 array having same no of elements and i want to insert them for each value of array into database like

 $array1 has 3 elements a1,a2,a3
 $array2 has 3 elements b1,b2,b3
 $array3 has 3 elements c1,c2,c3

now i want to insert data into database like field1=a1,field2=b1,field3=c1
 and similery for all the values saparete entry will be there

please help me achieve this i know this can be done by foreach loop of php

Answer 1

First count the items in an array.

As you mentioned that there are same number of elements in all the three arrays. Therefore we only need to count number of arrays in any one array. Lets take $array1 here. Use count($array1) to give element count. Suppose it gives 3 as the count.

Now loop 3 times like below.

for($i = 0; $i < count($array1); $i++){
    // QUERY HERE
    insert into sometable (field1, field2, field3) VALUES ($array1[$i], $array2[$i], $array3[$i]);
}