--- a/admin/importUNSPSC.php +++ b/admin/importUNSPSC.php @@ -1,1 +1,32 @@ +"; + flush(); + $row = 1; + $handle = fopen($path . $fname, "r"); + $headers; + + while (($data = fgetcsv($handle, 1000)) !== false) { + $num = count($data); + + if ($row == 3) { + $headers = $data; + } elseif ($row > 3) { +//print_r($data); +$query = "insert into UNSPSCcategories values(".$data[1].",'$data[2]');"; +//echo $query."
\n"; +mysql_query($query); + flush(); + + //echo "
\n"; + } + + $row++; + } + echo "
$success records successfully created"; + flush(); + fclose($handle); +?>