CODEWITHSUNDEEP
iphonesqlmysqlcocoa-touch
Md Nasir Uddin
Md Nasir Uddin

Reputation: 2200

How to connect to a MySQL database from an iPhone?

I am trying to connect to a remote mysql database from an iPhone. I have searched many web sites but I did not find any help. If anyone has worked with this please send a solution.

Upvotes: 14

Views: 29634

Answers (2)

samvermette
samvermette

Reputation: 40437

Assuming you have some experience with server-side programming (like PHP or Rails), you could just create an NSArray from the content of a URL where you establish a connection to the MySQL server and print the results you want in ASCII or XML format.

NSURL *myURL = [NSURL URLWithString:@"http://www.myserver.com/results.php"];
NSArray *sqlResults = [[NSArray alloc] initWithContentsOfURL:myURL];

Also useful to help you format the results printed by the server page: http://developer.apple.com/iphone/library/documentation/Cocoa/Conceptual/PropertyLists/Introduction/Introduction.html

Upvotes: 13

Oli
Oli

Reputation: 239978

A quick google will show you the way...

Upvotes: 2

Related Questions