i need you prepare a script preferably in perl or java script or php which ever works for you.
but i need to execute this script every day and collect data and save it in mysql Database
requirements are in the attached file
after prepare the required script i will test the sample data
and if any changes required you need to accomodate it