Iphone and Mysql

[jimmy]

is it possible to connect an Iphone Application with a Mysql database inorder to Authenticate a login? thanks ...

[dany_dev]

Originally Posted by jimmy

is it possible to connect an Iphone Application with a Mysql database inorder to Authenticate a login? thanks ...

why not use php to handle the connection and give values though xml in post?.


objective-c--->php---->mysql

[encryption]

Originally Posted by jimmy

is it possible to connect an Iphone Application with a Mysql database inorder to Authenticate a login? thanks ...

The short answer is yes. Although there is no connectMySQL method in the SDK, you could use network sockects to write a method that does just that. I doubt you want to go to that trouble though! Please send me the code if you do write it

You might think about using iPhone's NSURLConnection class to connect to a web server that authenticates for you. You would need to develop something on the server side to handle the authentication process. What language you choose is just personal choice. I wrote this into an app I developed and I used Perl on the server side. I have seen it done in PHP, ASP, etc so use whatever language you prefer on the server side.

Hope this helps!

NP

[iPhoneConnection]

Allowing your app to execute remote queries is asking for a whole bunch of trouble; SQL Injection being just one of them.

The neatest way would be to expose the behaviour with a set of web services. It also makes it easier to control your DB queries rather than worrying about app updates for bugs, etc.

If you want to use a SOAP web service, I'd recommend wsdl2objc. If you decide to use Rest, you'll need to do the POST/GET operations yourself.

[ronbowalker]

Here is a good tutorial that I used and found very good.

Kiksy, iPhone Login App using PHP MySQL Tutorial