I need a DB with results from US and UK lotteries.
It must contain the following fields:
- country name
- state name - for US
- lottery game name
- the winning numbers
- the date and time of the result
Other fields are optional.
The database has to be updated by an automated PHP CRON script. The results should be parsed from [url removed, login to view] for the US results and [url removed, login to view] for the UK draws.
I also need a lottery results archive within the same database with the results from the past years available on the internet.
For this part, you can use the available results in CSV format for the UK lottery found at [url removed, login to view]
as for the Us results, they can be parsed from here [url removed, login to view]
Please take a note that the sites provided are the best ones for this kind of job, if you have other ideas for getting the lotto results, we can discuss about them.
Also, the PHP script running in CRON has to be suitable for any changes in the structure of the lottery results pages for both countries.