Populating a TableView with data from MySQL Database using PHP

Question

I will admit, I don't know much about PHP and have google'd around for an answer but haven't had much luck in finding anything to suit my needs. I have however managed to create a simple connection script and login/authentication script to my server for my iOS app. I have a table in the MySQL database which holds a list of events and was wondering what would be the best way to populate cells using the values from this table.

I already have the UITableView set up, and have managed to get it loading data from a local array all to the right places on the custom cell.

I am able to @echo the results of all of the table back, but what would be the best way to go about populating each cell with one row of the table?

Thanks!

AlexeyVMP · Accepted Answer · 2012-01-07 21:49:03Z

1

It's good idea to use JSON to transfer data. PHP should have JSON support as well.

This is library for iPhone: https://github.com/stig/json-framework/

You need:

Using PHP get data from the database
Produce JSON-encoded array in PHP script
Read this data using NSURLConnection on iOS device
Parse received data from JSON to Obj-C objects (using the library above)

This is not so easy to learn fast, but there is a lot of examples in the Internet and this is good practice for sure. Learned once - helps forever.

answered Jan 7, 2012 at 21:49

AlexeyVMP

2,4263 gold badges26 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alex Over a year ago

Thanks, I have JSON, I'll try and find some tutorials and see where I can get to. Thanks.

Collectives™ on Stack Overflow

Populating a TableView with data from MySQL Database using PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related