I need a script that gathers all relevant information from a website. The information consists of a date, two titles (original, translated) and a company name. The information is provided as a HTML table. A bit tricky might be that the information is spread out over several pages (with pager). The newest information is on the last page.
The script also has to fetch historical data once.
Please send me a PM for the site´s url.
The fetched data has to be saved in a relational database. The script has to be written that the type of database can be freely chosen / exchanged! I will provide a schema with name of fields for the database. The schema has to be used in the script.
The script has to be able to find the newest entries on a new run and detect changes in the title (translated) and date.