Load data from a MySQL database to an Objective C/XCode Project

Question

I have a simple question to XCode/iOS developers out there. I just want to know what are the most basic ways of fetching/inserting data into a MySQL database from an Objective C/XCode program. Basically, what I am planning to do is to create a mobile application version of the website I am currently developing. In short, the XCode program I'm planning to do is a way smaller version of a PHP web application. The XCode program will be able to modify, insert, and fetch data from the database of the website.

Can you guys give me a hint? A tutorial (or links)? I'm not even a new XCode developer, I'm only about to begin being one for the capstone project I am developing with my group (I'm in college, if this info is even necessary LOL).

samir · Accepted Answer · 2013-10-10 13:22:36Z

1

You should do :

Implement a sever API (Web Services) with your preferred language ( PHP,...) that can communicates with the Data base.
An objective C client ( iOS application) that communicates with the data base but using your API ( Web Services).

here are excellent tutorials that will show you how to do all the steps. Tutorial

answered Oct 10, 2013 at 13:22

samir

4,5317 gold badges52 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user529543 · Accepted Answer · 2013-10-10 13:24:30Z

I would use REST webservice:

Write a piece of code with XCode which do HTTP GET and HTTP Post to your server. Query data with GET and Insert Update delete with POST.

After this write your server side code in PHP , Java, whatever you know / like to receive those 4 operations, connect to database and send a result you.

This architecture is used in many mobile applications. Has some Pro and so Cons, like everthing.

The Pro: separated code connection to database, separated units => improved security. Probably you don't want everybody see your mysql root password... who can decompile the iPhone app. With separated client-server: it allowed multiple connections, caching.

The list is very long here.

The cons: Probably need to know 1 more developing language than Objective -C Need web hosting, not only database hosting

The list is a lot shorter here and less important.

Collectives™ on Stack Overflow

Load data from a MySQL database to an Objective C/XCode Project

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related