read school data from a web site

you are going to write a script that will read all information from the schools in this web site

[login to view URL]

this information are public, so is not illegal to collect them.

the script need to take as an optional parameter the field UF, so I will run this script for each Brasilian state to avoid taking to much time.

so the script will first filter the schools by states, then get into each school ( except status "Extinta" ) and collect the detail information of the tab Dados cadastrais and Ensino regular

the postive point is that you dont need to worry with special char, all are ASCII with out accents.

all data need to be save in mysql, in 2 tables, school and studens. Use the field "Código" of the school data as a PK.

the deliver work is the script, not the filled database. I will run the script by my self.

for pourpose testing you can filter the state "AC" that is the state with fewer schools.

attached are the images in the ordem will be show in the page with the fields you need to worry about, if you have any doubt about the database modeling or the pages, just ask me.

you will probably use curl with php and mysql

Dont want to spend more than US$ 50, should be a one day work.

AJAX HTML MySQL PHP

Project ID: #7753076

About the project