Get Page Data

Create a PHP script will acquire the data from 6 website pages, and store the data in 5 separate mysql tables.

1 ) From this page ([login to view URL])

with the same columns, as displayed on the page.

Download the first 100 only if available. Only keep the latest request in the table. (Overwrite whatever is currently in the table with the new data)

Repeat this on a schedule, every 30 minutes.

This one will create a mysql table called "unusual_option_activity_stocks"

2) [login to view URL]

with the same columns, as displayed on the page.

Download the first 100 only if available. Only keep the latest request in the table. (Overwrite whatever is currently in the table with the new data)

Repeat this on a schedule, every 30 minutes. Only write to the table any NEW data currently not in the table.

This one will create a mysql table called "unusual_option_activity_etf"

3) [login to view URL]

with the same columns, as displayed on the page.

Download the first 100 only if available. Only keep the latest request in the table. (Overwrite whatever is currently in the table with the new data)

Repeat this on a schedule, every 30 minutes. Only write to the table any NEW data currently not in the table.

This one will create a mysql table called "unusual_option_activity_Index"

4) [login to view URL]

with the same columns, as displayed on the page.

Download the first 100 only if available. Only keep the latest request in the table. (Overwrite whatever is currently in the table with the new data)

Repeat this on a schedule, every 30 minutes. Only write to the table any NEW data currently not in the table.

This one will create a mysql table called "most_active_options_stock"

5) [login to view URL]

with the same columns, as displayed on the page.

Download the first 100 only if available. Only keep the latest request in the table. (Overwrite whatever is currently in the table with the new data)

Repeat this on a schedule, every 30 minutes. Only write to the table any NEW data currently not in the table.

This one will create a mysql table called "most_active_options_etf"

6) [login to view URL]

with the same columns, as displayed on the page.

Download the first 100 only if available. Only keep the latest request in the table. (Overwrite whatever is currently in the table with the new data)

Repeat this on a schedule, every 30 minutes. Only write to the table any NEW data currently not in the table.

This one will create a mysql table called "most_active_options_etf"

HTML JavaScript MySQL PHP Tietojärjestelmäarkkitehtuuri

Projektin tunnus: #18176152

Tietoa projektista