$line) { $record_cnt ++ ; $line = str_replace('","','"^"',$line) ; if ((rtrim($line) != "") && (substr($line,0,1) != "#")) { if ((($line_num / 10) == floor($line_num / 10)) or (($line_num > 8480) && ($line_num < 8490))) { echo "Line #{$line_num} : " . htmlspecialchars($line) . "
\n" ; } $fields = explode ("^",rtrim($line)) ; for ($i=0;$i 8480) && ($line_num < 8490))) { echo "Field #{$i} : " . htmlspecialchars($fields[$i]) . "
\n" ; } } $new_fields = "insert into iplocation set " ; $new_fields .= "ip_from=" . $fields[0] ; $new_fields .= ", ip_to=" . $fields[1] ; $new_fields .= ", registry='" . $fields[2] . "'" ; $new_fields .= ", assigned='" . $fields[3] . "'" ; $new_fields .= ", country2='" . $fields[4] . "'" ; $new_fields .= ", country3='" . $fields[5] . "'" ; $new_fields .= ", country='" . $fields[6] . "'" ; if (($line_num <= 120) or (($line_num > 8480) && ($line_num < 8490))) { echo "

" . $new_fields . "

\n" ; } if (mysql_query("$new_fields") or die("Insert IP Location Query failed for Line # " . $line_num)) { $new_row_cnt ++ ; } else { $error_cnt ++ ; echo "

An error occurred when trying to add record " . $line_num . " to the database: " . $mysql_error . "

" ; } } } // Connect to database mysql_close() ; echo "

Records read: " . $record_cnt . "

\n" ; echo "

Rows inserted: " . $new_row_cnt . "

\n" ; echo "

Errors: " . $error_cnt . "

\n" ; ?>