newsapi add entry to database cache via php

Job ID: 33332596

Budget: $10 – $30 USD

1. We have a table, we want to create a script that caches to database

https://newsapi.org/docs/endpoints/everything

2. we need to add all the entries to the database table

https://newsapi.org/v2/everything?q=amazon&apiKey=718315b0757d4dd2b29be42d29db7e42&pageSize=100

Example: In our database we would add the image, title, description, keyword, language, date, url (from the json results)

3. We want about 100 of these newsapi urls to add each day to the database

https://newsapi.org/v2/everything?q=amazon&apiKey=718315b0757d4dd2b29be42d29db7e42

https://newsapi.org/v2/everything?q=google&apiKey=718315b0757d4dd2b29be42d29db7e42

https://newsapi.org/v2/everything?q=microsoft&apiKey=718315b0757d4dd2b29be42d29db7e42

etc..
Related categories: PHP JavaScript XML Software Architecture MySQL