Q:

iPhone - Accessing MySql Server?

I am basically trying to retrieve some data from a MySql server, and display them on my iphone
Let's say i have a table named "car" and i need to send 10 rows of my table to my iphone.
1- Is there any possible way to send an actual array of objects "cars" to my iphone. Or does it have to be a string.
2- If it has to be a string, what is the best format to use? XML or JSON, or any other format?
3- Is SOAP the same as a web Services? if not what's the difference?
4- What is the best language to use, to handle the data transfer between iPhone and database? is it a good idea to use php?

A:

1 - yes, you should serialize the array of objects on the server side and send it to iphone. Then deserialize it and use it.
2 - JSON or XML, both have good and bd things. Just use JSON for now. Any server language supports it (php, ruby, python) and you can use Apple or 3rd party JSON parser on iPhone
3 - SOAP is a way to serialize messages. Those messages are exchanged between client and server. The exposing of server functionality is called "Web Service"
4 - PHP, Ruby on Rails, Python (Django)...

