I have about 14,000 lines in a CSV file.
Each line is formatted like this:
Firstname Lastname,UUID
Firstname Lastname,UUID
I want to Post/CURL to a url like:
http://some.url/directory/file.php?name=Firstname%20Lastname&uuid=UUID
I have tried doing this a few ways, but I always run into an issue - what's a good way to do this, and I don't want to attack the URL by sending 14,000 requests at once.
I do not need any data back from each posting, I just need to send the data over to the PHP file so it can be analyzed.
NOTE: Each post means a mysql query will be analyzing the data, so I don't want to flood the server with 14,000 mysql requests at once either - more reason why I might want to throttle this.
I just have to do this one time ever.
Would something like pull data from csv file and submit each row to url with curl be a good place to start?