|
<?php |
|
include_once("../lib/common.inc.php"); |
|
$success = 0; |
|
$fname = "UNSPSC_ECCMA_V13.2_UNDP_V7.csv"; |
|
echo " ============== $fname ============== <br>"; |
|
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."<br>\n"; |
|
mysql_query($query); |
|
flush(); |
|
|
|
//echo "<hr>\n"; |
|
} |
|
|
|
$row++; |
|
} |
|
echo "<br> $success records successfully created"; |
|
flush(); |
|
fclose($handle); |
|
?> |
|
|