Web service advice for an iPhone app

I am currently working on an iPhone app that will have a user log in, enter a workorder or building, and the app will display workorder/building information. The user will then be able to edit some of the data and submit it to the server. The backend database is a MySQL server. What is the best web service to use for this situation? I've been reading about SOAP, JSON, etc. but I honestly haven't found a good description of the pros/cons of each and how well they work with an iPhone app. 开发者_如何学运维Any and all help (or links to useful reading) would be greatly appreciated!

Ruby On Rails or PHP is your best bet for the web services layer that goes between the phone and the MySQL and go for JSON as that is the most commonly IPhone Web service data format as it is the one that requires the least amount of data upload by the phone. Touch JSON is commonly used IPhone framework for this.The RoR or PHP web services layer serves up JSON data based on URL requests by the IPhone. There's loads of stuff on this if you google which I did when faced with a similar problem.