Retrieve data from an API using PHP and CURL and store it in a MySQL table (and more)

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.


- 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.

Taidot: PHP, MySQL, cURL, Data Scraping, Tietojärjestelmäarkkitehtuuri

Tietoa asiakkaasta:
( 31 arvostelua ) Calgary, Canada

Projektin tunnus: #36279108

Myönnetty käyttäjälle:

(1268 Arvostelua)

114 freelanceria on tarjonnut keskimäärin $539 tähän työhön


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 Lisää

$500 USD 7 päivässä
(129 arvostelua)

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 Lisää

$448 USD 7 päivässä
(960 arvostelua)

Hello Good Day, I am writing to you in response to your project request for a developer to retrieve data from an API using PHP and CURL and store it in a MySQL table. I am confident that I am the best candidate for th Lisää

$750 USD 7 päivässä
(1309 arvostelua)

Hello there, we hope you're doing well. I am confident that I can develop the necessary tables and PHP files to meet your requirements. With my experience in database management and API integration, I can ensure that t Lisää

$500 USD 7 päivässä
(239 arvostelua)

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.

$450 USD 3 päivässä
(1326 arvostelua)

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, Lisää

$500 USD 7 päivässä
(559 arvostelua)

Hi, Hope you are well, We have best team in our company, We can give you good quality work on time Regards

$450 USD 5 päivässä
(290 arvostelua)

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 Lisää

$500 USD 7 päivässä
(409 arvostelua)

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

$650 USD 7 päivässä
(147 arvostelua)

Hi, Greetings! I am a good fit for this project due to my strong skills and experience to build custom php script to read API data and process the same to generate output ******Please send me a message so that we can Lisää

$250 USD 8 päivässä
(420 arvostelua)

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 Lisää

$500 USD 7 päivässä
(104 arvostelua)

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.

$750 USD 3 päivässä
(389 arvostelua)

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

$1000 USD 2 päivässä
(315 arvostelua)

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

$750 USD 3 päivässä
(479 arvostelua)

Hi, I am more than expert in calling the APIs and manipulating the database...I have understood the overall requirements ... lets discuss every step in detail....and also please share the standard text file that will b Lisää

$500 USD 5 päivässä
(184 arvostelua)

** 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 . Lisää

$500 USD 7 päivässä
(65 arvostelua)

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 Lisää

$750 USD 7 päivässä
(23 arvostelua)

Hello, I hope you are doing great. I have good experience with doing similar jobs. You can check my portfolio here: I can do this job because have great experience with Software Arch Lisää

$750 USD 11 päivässä
(44 arvostelua)

=======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 Lisää

$500 USD 7 päivässä
(44 arvostelua)

Hi there. I can do this job perfectly. We can discuss it in chat and start to do that. Alex

$400 USD 3 päivässä
(177 arvostelua)