iPhone SDK mySQL

Question

Hello everybody,

I'm starting on a new iPhone project, and this application mostly relies on mySQL. I have a mysql database running on my computer, and I need this application to send queries to the server to gain information. One example is creating and logging into an account. I have successfully done this on my windows vb.net application, but I know that objective c will be harder. This is basically getting text from the sql database and displaying it on the iPhone application. If someone could simply help me on that, I'll easily get started. So I hope that you guys help me out here :).

Thanks

Kevin

Answer 1

Usually, on a good day, you don't let your user's query the database directly. Instead, you have a dynamic web page that sits as middleware between the database and user. This way in the dynamic web page you can spit out XML (or something just as useful like CSV) and parse it on the user's end.