iOS Tutorial: JSON Part 4 - Loading data from an external database into an app

This is part 4 of a 4 part tutorial series that covers how you can use PHP + MySQL to load data in JSON format into your app.

We wrap up our app in this tutorial!

[barryjulien]

One of the best tutorials I've seen so far on implementing JSON in iOS.

[marty]

In case someone else runs into the same problem, I had no data showing up from my database, and I was able to fix it by simply renaming my php file. It was originally named "test2.php". I guess the number messed it up. I changed it to "json.php".

Anyway, these videos are a life saver. Thanks Vishal!

[bsventertainment]

Thank you for taking the time in doing these tutorials. You are helping a lot of people!

[fengson]

Amazing :) Worth to add maps to each detailed view!

[VishalKurup]

Javier - Thanks for jumping in and helping paraz!

[MathewAntony]

Such a helpful tutorial Vishal! You're the best.

[balestrapatrick]

Awesome tutorial! Keep up doing these tutorials! :)

[HoangIT]

Thanks you very much. it's very useful for me!.Nice tutorial. I hope you will create more more more video useful like this.

[rahulmahajan]

thanks soo much
this is really helpful for me.

[beauclark]

Thanks a lot for this, it really helped me out.  I am using MAMP for the sql and php server working on it locally.  I had a lot of issues connecting to the server and found out that the php code didn't like "localhost" as a host name.  If anyone has issues with this just use 127.0.0.1:8889 instead (or whatever you set your port number to).

[ThaKurmastersios]

Its really Awesome tutorial Dude: Keep it up: How to make a Database for music apps.

[VishalKurup]

Could be one of two issues:
1. Your JSON is malformed. An extra character could throw off the Objective-C code.
2. Something wrong with your code in the project - You may want to try adding NSLog statements/breakpoints and see what the various values are at various stages of the program.

[VishalKurup]

Tim and qwerty - Try and do an NSLog on the didSelectRowAtIndexPath method and see which row you are actually passing to the detail view controller.

[MiroMarkarian]

Dat "Deutschland" tho! I liked your German accent :p

[giuseppefigliolia]

Thank you very much... if I want to implement search?

[EXRaidLeader]

Can you please make a detailed video going over how you created your database? I have mySQL and Aptana Studio 3 for my php but I don't know if I have done it correctly at all. I really need some help. Thank you so much for your in depth videos, they are very helpful.

[markbirkett]

I have to say i find your Tutorials very very useful and the best i have seen, nice to see up to date tutorials. My app is working great apart from that im using storyboards, ive worked out how to pass data, clicking the first item in the tableview works fine, but when i click on any other item/cell, the app crashes. Im guessing its something to do with reading the correct row but i was hoping you could give me a point in the correct direction.
Thanks in advance
Mark (UK)

[manaspathak]

@vishal kurup:-if the data is not hosted  in oracle and  mysql  server but,  data is howted on web server(through some link) then how can we parse that data using json parsing?

[jonprasetyo]

Well explained tutorial, Thank you !

Also I was wondering if you have CRUD tutorial on sqlite 3? I couldn't find it in your uploads.

If you have time, can you please make a tutorial on that? Your explanations are very clear and easy to understand. Thanks again.

[dudesome]

Thanks soo much for being so generous with the knowledge! I had a few ideas but was not sure how to make an app interact with a hosted database. By any chance do you know if Apple have any special req for hosted database?