Tutorial Request: Connecting iPhone App to MYSQL using JSON or XML

[cobroke]

I've googled my fingers off and still haven't found either good sample code or how exactly to do this. I am looking for ALL of the code so I can understand how to do a select query on a mysql database using PHP & JSON or PHP & XML. I have JSON installed locally in my app but that is about as far as I was able to get.



Thanks!

[blmohr]

I have the same question. Does anyone have a response?

Originally Posted by cobroke

I've googled my fingers off and still haven't found either good sample code or how exactly to do this. I am looking for ALL of the code so I can understand how to do a select query on a mysql database using PHP & JSON or PHP & XML. I have JSON installed locally in my app but that is about as far as I was able to get.



Thanks!

[meowmix23F]

Simply put a PHP script on your server that takes arguments in the post:

example:

myscript.php?username=bob

if bob exists in the mysql table, print "YES" to the webpage.

Then use NSString's initWithContentsOfURL to get that value from the webpage. It's that simple.

[160740]

hiya, I'm new to iPhone app development, and I'm kinda jumping in at the deep end... sorry if this is a stupid question :S

can we use this to retrieve names and passages of text from mysql?

[russellharrower]

Anything you can do in PHP you could port over to the iPhone.

Well kinda, you could port over the data that the PHP document would return. Hope that helps you.

[russellharrower]

Just a quick question, How do I pass the Bob to the link that gets the result?
I have a search box in the view but i don't know how to take the text from that and add it to the end of the link?

Can anyone help

[nandhini]

I need to connect mysql database with my iphone application.once the user clicks button the value need to store in mysql database which is in another machine.

please send me the sample code for mysql database connectivity..