| <?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); | |
| ?> | |