Nusrat Nuriyev
asked on
Get the database of institutions(schools, and universities with faculties ) of azerbaijan cities from vk.com
Hello, there is a site vk.com which is actually social network, (but that's not very important in current context).
There is a people search link https://vk.com/search
where you may select(at the right side)
1. region
2. city
3.1 school
3.2 class
...
4.1 university and
4.2 faculty
4.3 department
4.4 attending year
....
The task: get the list of schools and universities with faculties and department (in proper hierrachical tree view which must be remapped into MySQL database.
How can we automatically grab that data and put that into mysql corresponding tables? Do we need to write some web-utility which will automatically get those data fields?
The structure of mysql tables are following (without country and city) attached
There is a people search link https://vk.com/search
where you may select(at the right side)
1. region
2. city
3.1 school
3.2 class
...
4.1 university and
4.2 faculty
4.3 department
4.4 attending year
....
The task: get the list of schools and universities with faculties and department (in proper hierrachical tree view which must be remapped into MySQL database.
How can we automatically grab that data and put that into mysql corresponding tables? Do we need to write some web-utility which will automatically get those data fields?
The structure of mysql tables are following (without country and city) attached
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, this is my homework, which I'm going to assign to my students.
ASKER