How to Connect an iOS App to a MySQL Database (Step by Step) - Part 3

In this video series, I'll show you how to connect an iPhone app to MySQL. We'll go through it step by step starting from the beginning.

You'll learn how to:
- Sign up for web hosting
- Create a new MySQL database
- Set up a MySQL database user
- Set access permission for that user
- Create a PHP web service to access the data
- Create an iOS app with a tableview, multiple screens and a map
- Access the PHP web service via the app to download the data from your MySQL database.

This is a video version of the tutorial here:

For more tutorials on how to build iPhone apps, make sure you subscribe and visit my site where you'll find a community of like minded learners! Learning something new is always more fun with other people!

Get a customized roadmap for your app and start building it in 7 days:

CodeWithChris is dedicated to teaching beginners and non-programmers all about building iOS apps. On the site, you'll find a ton of free resources and tutorials to aid you on your journey to learn iOS development. Many people have successfully picked up Swift 3, Xcode 8 and app building from my course and materials!

Intro & Outro music

[richardmcqueen]

Hello Chris. I followed this series and I used MAMP (macOS apache mysql and php) and it is very easy to set. Hope it is useful. bye for now

[YannisStarwalker]

Hello Chris and Thank you so much for these wonderful tutorials, much appreciated!!!
Just one small tip for database tables, it would be very useful and handy to have an ID column, which should be PRIMERY KEY and AUTO INCREMENT. Think how handy it is the "IndexAtRow" when working with arrays in Swift. A databse table can be considered as a multidimensional array and each of its rows as a simple array. The ID od the row will be helpful for picking data from specific column (field) of specific row if needed.
Once again, Thank you so much and I would dare to ask if you could tell us how to store data fetched from the database to the app, so the app can work even when there is no internet connection available.
Looking toward the next videos
Yannis

[douwedevries]

Hey Chris! If you want to create a clean database, take a look at database normalization. It says for example that you always need an id for each row. This will make it easier for later on in your projects.

[dylanwestphal]

Does connecting through the database with app allow me to send commands to a terminal? Like on a raspberry pi so i can control the GPIO pins

[GaboDev]

Great Video Chris ! ready for the next

[mohaimenhassan]

hello Chris.
can I use my local phpmyadmin instead of bluehost ?, because I already have local server.
thx for this tutorials..

[ad]

Hey can you do video how to put iAd SpriteKit on game scene

[mistermilch]

For free hosting i would recommend 000webhost and if you have tons of useres/data switch to 1&1 webhosting

[JD-eure]

skip to this video if you actually want to accomplish anything