Using external API with php/mySql:
- or -
Post a project like this- Posted:
- Proposals: 5
- Remote
- #1679593
- Awarded
Description
Num. of web pages/modules: 1
Description of requirements/features: Hi,
I have a very small project that is almost complete. The project is meant to extract weather information from an external API, and store it. I need 2 things to wrap it up:
1. I have 3 sql-tables: user, cities, citydata. Every user in the user-table has a city-ID. This city id represents an ID in the city-table (for example, London has ID 1, so if the city-id of the user is 1, this means he lives in London). I need the code to fetch the data associacated with the user's city id from the other 2 tables (cities+citydata) and store them in strings/variables.
2. Call the method that calls the API, passing strings/variables for city name and countrycode. I have the method done, and the drop down list for choosing city as well. What I need you to do is store the data returned from the API into the correct columns in the table city-data. Also, the new city selected should replace the old one of the user-table too (if user has London when logging in, but select to check weather of Tokyo, Tokyo will be his new city)
These tasks should be very easy for you to do, if you're experienced in php/mySQL.
IMPORTANT: I want you to just make the above happen. I don't want you to "improve" any of my existing code unless it is absolutely needed to make it work. Don't overdo it, keep it simple.
Extra notes:
Fredrik P.
100% (53)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi there. What API are you using and what method do you want to call? What variables does it take? Thanks
-
Hello fredrik,
Can you send the complete details regarding your API? -
Hello I am web developer. I have 2 years experience of web development. I have sound skills of php , mysql , javascript , jquery , html , css and bootstrap. I have also grip on laravel and angularjs. I will do it in professional way. Login system will totally secure and notes will be shown wit optimized queries. There are some reference sites:
https://www.romebysegway.com/
https://www.ecoarttravel.com/en
http://profitsmall.com/
If you define me the technology which is used and full requirement then I can submit my proposal with clear and perform better.
Thank you
Regards:
Muhammad Aamir Zia