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