[SOLVED] Insert array data into DB

[ainoy31]

Hello-

Either it is too late or I can not think straight.

 

I need help inserting data from an array into mysql DB. 

 

My table fields are:

part_id

catcode

year

make

model

submodel

engtype

liter

fuel

fueldel

asp

engvin

engdesg

dciptdescr

exppartno

expldescr

vqdescr

fndescr

 

my sample arrays are:

Array ( [0] => CRW [1] => 2007 [2] => CADILLAC [3] => ESCALADE [4] => [5] => V8 [6] => 6.2 [7] => GAS [8] => FI [9] => N [10] => 8 [11] => L92 [12] => Grille Insert [13] => 37012 [14] => Billet Aluminum Grille; CNC Machined; Marque-Mesh;No Cutting; Polished; [15] => [16] => )

 

Array ( [1] => CRW [1] => 2008 [2] => CADILLAC [3] => ESCALADE [4] => [5] => V8 [6] => 6.2 [7] => GAS [8] => FI [9] => N [10] => 8 [11] => L92 [12] => Grille Insert [13] => 37012 [14] => Billet Aluminum Grille; CNC Machined; Marque-Mesh;No Cutting; Polished; [15] => [16] => )

 

Should I use a foreach($array as $key => $value) or use a for loop and count the num of elements in my array and use it as a counter like:

$num = count($array);
for($x=0; $x<$num; $x++)
{
}

 

It just getting confusing to me.  Much appreciation.

 

[fenway]

Assuming you know the order of your array, you can simply used a multi-valued insert statement.