CODEWITHSUNDEEP
mysqliosdatabase-connection
user3142046
user3142046

Reputation: 31

How to access server MySQL database from iOS app

I'm trying to write an iOS app using Xcode.

A simple login prompting username and password.

I have no idea how to open a database connection to validate the username and password.

The database I use is mysql.

I tried using this link http://macbug.org/macosxsample/mysql#.Ur8AYBbtGPF

but I get an error when I tried to add libmysqlclient.a to the frameworks and library.

Upvotes: 3

Views: 6607

Answers (2)

Rob
Rob

Reputation: 437552

If your database is on a server somewhere, then you would generally not have your iOS app interact directly with the database server, but rather you would write a web service that the app would interact with (via NSURLConnection, NSURLSession or something like AFNetworking), and the web service would interact with the MySQL database.

In terms of how to write a web service, often, when people are writing their first web service, they'll use some simple technology like PHP. Do you know what options you have on your server? If PHP is an option, then you can check out Ray Wenderlich's How to Write a Simple PHP/MySQL Web Service. Then check out How to Write an iOS App that Uses a Web Service.

Upvotes: 1

karthikPrabhu Alagu
karthikPrabhu Alagu

Reputation: 3401

You should use SQLite instead of MySQL for iOS application. You are referring MacOSX application tutorial. try this http://www.raywenderlich.com/913/sqlite-tutorial-for-ios-making-our-app

Upvotes: 0

Related Questions