Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Categories
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media
Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

Using external API with php/mySql:

- or -

Post a project like this
1269
$20
  • Posted: 4 years ago
  • Proposals: 7
  • Remote
  • #1679593
  • Awarded
Md R.
Md R.
Expertise in - PHP|CodeIgniter |Bootstrap |Angular |React Native | Ionic | Flutter|JOOMLA|WORDPRESS|Android| |ASP.NET
India Kolkata
Anuj O.
Anuj O.
Full Stack Developer(Angular 7 + React Js + PHP Programming Language)
Top Endorsed
India Chandigarh
Muhammad I.
Muhammad I.
PHP | Laravel | VueJS | Wordpress | API | Facebook | Responsive Design
Top Endorsed
Pakistan Karachi
Esthetic Soft
Esthetic Soft
Software Development | Web Application | Graphic Design | Mobile Apps Development
Bangladesh Dhaka
Firoz M.
Firoz M.
Backend developer. Go, PHP, Node.js, Python.
India Bangalore
Mohsin T.
Mohsin T.
Full Stack Developer & Designer
Top Endorsed
Pakistan Faisalabad
Akash S.
Akash S.
Web Developer, PHP Developer, Mysql, Hybrid App Developer, Angular JS Developer, Web Designer, IONIC Developer
India Chandigarh
32306617449752608361218154159202417265971791474
Md R.
Anuj O.
Muhammad I.Esthetic SoftFiroz M. + 2 others have already sent a proposal.
  • 2
  • 2

Description

Experience Level: Intermediate
General information for the website: getting info from API into sql-table(s)
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.
Fredrik P.
100% (32)
Projects Completed
54
Freelancers worked with
31
Projects awarded
23%
Last project
27 Jan 2019
Sweden

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • 17 Aug 2017Rusty L.

    Hi there. What API are you using and what method do you want to call? What variables does it take? Thanks

  • 17 Aug 2017Akash S.

    Hello fredrik,

    Can you send the complete details regarding your API?

  • 16 Aug 2017Muhammad A.

    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

483314483255483053
1269
$20

- or -

Post a project like this
Fredrik P.
Fredrik P.
100% (32)
Projects Completed
54
Freelancers worked with
31
Projects awarded
23%
Last project
27 Jan 2019
Sweden

Related project Searches


mysql application programming interface (API) PHP programming language web

Product

  • About
  • Team
  • Careers
  • Blog

Support

  • How it works
  • Trust & Safety
  • Help Centre

Discover

  • Plus Works
  • Academy

Resources

  • Customer Stories
  • Business Cost Calculator
  • Startup Cities

Browse

  • Freelance Services
  • Freelance Services By Country
  • Freelance Skills
  • Terms
  • Privacy
  • © 2021 People Per Hour Ltd
We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy