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

Xcode Project Code:

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

[JohnYngson]

Maybe a little sample of login and registration IOS App and connected to MYSQL database.. Thank you! :)

[semilife]

Thanks Chris have completed the app functionality successfully. I managed to use a xampp configuration on my local machine to provide the data to test the app, so didn't in the end need to rely on an external web hosting. Many thanks for your expert instruction.

[JohnYngson]

Nice Tutorial... By the way.. is it the same procedure when you SELECT, INSERT and UPDATE database? Thanks

[vyankatraohighschoolichalk]

Thank You Sir,
can we connect our MySQL Database without the php service ?

[abhishekchaudhary]

Thank you Thank you Chris !!!! Your Videos are really helpful, I watch your every video and try to implement them.
Just asking if you can make a separate video on "Understanding Core Data and using its features." It would be really helpfull for ios developers.

[andreasfriedrich]

Hi Chris, very good job you did, I did your tutorial two times and in the end the map shows only my region in Europe. I can't see a pin when I manual move to US there's also no pin. What do I do wrong? Hope for help - thanks!

[GaboDev]

Great Tutorial Chris ! When the tutorial with Firebase?

[JohnYngson]

How about the session and cookies? is it possible to stored them in ios app? Thanks

[kenturnbull]

Do you have any plans to update this tutorial to show CRUD operations or do a new tutorial on the subject? Creating the service is not the problem...have it and the DB already. Would I need other Swift components for Crud?

[Manichov]

Hi Chris, Your tutorial is what I was looking for. But I need something. If I want the show the Map with my pins that the app collect form MySQL without show the table. The tutorial show first a table and you need to click in my of the location in the list to show it in the map. I want instead of that. just collect all the location and show it in the map, Jumping over the tableview. Thanks.

[einsteincreative]

Great I need to upload to mysql..Plus in the form upload images. I see this everywhere, great tutorial

[wynton]

Hey thank you for posting this video. I will be creating a data server with Node.JS, but my question to you is about ARKit.... I've built a few apps using ARKit and for the next one I create, I'd like to connect the app to a data server where the user can upload 3D models (DAE files) from the data server. From experience, DAE files are normally included in the build of the app and in the code you have to specify what DAE file you want to be rendered in AR. Is there a way to be able to create a function that selects the file from the server instead of the app?

[aliatighehchi]

i had added an image to the cel and i had the cell refresh with
cell.setNeedsLayout() //invalidate current layout
cell.layoutIfNeeded() //update immediately
and since i added
DispatchQueue.main.async {
locArray)
}
the images do not show until the cell is clicked. It dose not refresh anymore. where should i refresh the images

[satz.k]

can u tell how to upload image to php server using button

[sahilsandhuuu]

hello sir, i need xcode app please me a link for window 7

[ravishsharma]

how we can perform crud operation on it dynamically..?

[TarasKim]

With video code, i had an error which I couldn't fix, I believe this code is outdated, your link to the code is broken, content on the website is different with what you do in the video... I liked your first beginner's course, but this is terrible work

[jamiecarroll]

Change 'viewDidAppear' to 'viewWillAppear'. This will load the map coordinates before the map appears. So it won't show your country; then immediately load the coordinates.