Code: Select all
$allrows[] = "('".$csv_line[0]."', '".$csv_line[1]."', '".$csv_line[2]."', '".$csv_line[3]."',
'".$csv_line[4]."', '".$csv_line[5]."', '".$csv_line[6]."', '".$csv_line[7]."', '".$csv_line[8]."',
'".$csv_line[9]."', '".$csv_line[10]."', '".$csv_line[11]."', '".$csv_line[12]."', '".$csv_line[13]."',
'".$csv_line[14]."', '".$csv_line[15]."','".$csv_line[16]."', '".$csv_line[17]."', '".$csv_line[18]."',
'".$csv_line[19]."', '".$csv_line[20]."', '".$csv_line[21]."', '".$csv_line[22]."',
'".$opv."' )";
If I try using foreach I can't see the way to get starting and ending brackets ( ) on each line for the correct query format.
Code: Select all
foreach($csv_line as $qvals)
$allrows[] = "'".$qvals."'";
$query = "INSERT INTO table (`all`, `my`,`fields` ) values ".implode(',', $allrows) ;
incubi