To do this, we will write a simple PhP script. The next step in learning how to connect an iOS app to a MySQL database is actually pulling our data. Now our database has some data we can pull! Configuring the Web API Here we can see that we added three rows to our table. Add as many rows as you would like, all of which will be displayed in our iOS app. We will leave the id field blank, and make up a name and a price. Now click into the database, and you will be able to navigate into the table that was created as well. Then we will add two more fields, one for name and one for price.Ĭlick create, and the database will appear under the list of databases. We will include an id field, which is the primary key and auto-increments. Name your database and table whatever you like, then move on to the fields. Here we are presented with a fresh database to configure.įor the sake of this tutorial, we are going to keep our database very simple. We are going to want to create a new database, so go ahead and click ‘Create a New Database’ on the top module. After logging in, navigate to the top toolbar -> servers -> MySQL Database Server. Once the VPS is ready to go, navigate to the IP address and view the control panel.Ĭlick into Webadmin, and log in with the username ‘root’, and the password that you set when deploying the VPS.
Since we will be using both MySQL and PhP, the LAMP stack template offered by SkySilk is perfect for us! For this tutorial, we will be using a PhP script for our API. This simple script will take the request, process it, and respond to the app.
Our app won’t connect directly to the database, instead, it will need to send requests to an API that we will write. We will need a MySQL server of course, but we will also need a simple API.
The first step in learning how to connect an iOS app to a MySQL database is configuring the backend. How to Connect an iOS App to a MySQL Database: Setting up a MySQL Server
0 kommentar(er)
