Retrieve data from an API using PHP and CURL and store it in a MySQL table (and more)
Budget $250-750 USD
Job Description:
Table #1:
- 8 columns
- Create and populate with some info from a standardized text file (only needs to be done once)
Table #2
- 13 columns
- With this table we generate a pattern of requests to be made to an API.
- The pattern is generated by a .php file, which is used to generate 5 different types of requests to the API.
The data used to form these requests is stored in this table.
Really, the requests are all pretty similar, with a few variables changing for each request.
The API requests will be made using CURL and the JSON stored in this table.
PHP File #1
- This php file is used to make the requests to an API, which are formed using the data in table #2 above.
- The response from these requests is stored in table #3.
- There are 5 rules that dismiss certain records based on the data in the response.
Table #3
- 15 columns
- Contains the responses from the API requests made in php file #1.
- About 8 of the columns require the data from the response to be manipulated or calculated in some way.
Table #4
- 47 columns.
8 of the columns are just a straight copy from table #3.
30 of the columns are just a straight copy from some other tables that will be provided.
9 of the columns require some data manipulation and calculation using functions that will need to be created.
Speed and rate control
- The php script has 4 simple variables to control the rate of the API requests.
They are stored in PHP File #2.
Maintenance
- The php script has 3 simple variables to delete rows from the tables above, based on age.
They are stored in PHP File #2.
PHP File #2 ([login to view URL])
- Stores about 8 variables used by PHP File #1.
Screen Output
- The PHP script offers some screen output while the functions are being performed.
There are about 17 different output messages, depending on which function is being performed.
The Real Project Plan
- The real project plan obviously contains detailed instructions of what will be performed each step of the way.
Awarded to:
114 freelancers are bidding on average $539 for this job
Hi there, Do you want to develop your own API or you want to integrate any API? Please share more detailed required features list and explain which PHP file you want to use? Kindly click on the chat button to discuss More
Hi sir, We are highly interested to work for you I helped 9 clients from Canada then i think you will be next one. Your satisfaction is more important than money then you only need to pay when your project is comple More
Hello, thank you for detailed explanation. Depends on request volume to API maybe better to use multi curl instead - I am good with curl & API. We can discuss more, thank you.
Good Morning, You are chatting with Raman. I can help you with retrieve data from an api using php and curl and store it in a mysql table (and more). Our team is expert at this work. We completed more than 20+ PHP, More
Hi, Hope you are well, We have best team in our company, We can give you good quality work on time Regards
Hi there! Did go through your job description and glad to share that I have experience in working with PHP and API's integration platform. I have more than ten years of industry experience and have been the part of d More
hi there, I am an highly experienced php developer with more than 10 years of dev experience, I can complete the 3 php files and corresponding db tables for you exactly as per your requirements
Hello, YES, .I am confident to do this task Retrieve data from an API using PHP and CURL and store it in a MySQL table (and more) I have experience of 7 years working as a PHP/Full stack developer with all latest Tech More
Hello Sir, Can i have API details? Also, please share text file for table 1 I am willing to start right away. Please check my profile for work and experience. Regards Hardeep.
yeah i got your task ready to start work now and i can do that job with in 1 to2 day max ready to start work form now
Hello, I have 10 years of experience in Mysql,PHP etc.. I can Retrieve data from an API using PHP and CURL and store it in a MySQL table Let's do a meeting first Regards, Vishnulal
** I am a Full Stack developer and available for quick discussion ** Hello Greetings of the Day!! Yes, I will surely retrieve data from an API using PHP and CURL I will perform the following tasks perfectly . More
Hi there, I have read the brief details of the project u posted and I believe i can help u as I have great experience doing projects with Software Architecture, Data Scraping, cURL, PHP and MySQL. Please send me msg t More
=======PHP Expert=========== Hi there, Here you can get a good partner. I always activate. I can show you demo. I have read your project description and it seems I can complete this project satisfying your requirement More
Hi there. I can do this job perfectly. We can discuss it in chat and start to do that. Alex
