Advertise Mobile SDKs Books Events Forum News Social Networking Support Us
Follow @iphonedevsdk on Twitter

Interface 2, Advanced iOS
Mockup & Code Gen
($9.99)

Make your own iPhone apps
and run them live!
(free)

Pic Frame Dynamo: Photo Editing
($0.99)

Abiliator
($1.99)

Want your application or service advertised on iPhone Dev SDK?

Go Back   iPhone Dev SDK Forum > iPhone SDK Development Forums > iPhone SDK Development

Reply
 
LinkBack Thread Tools Display Modes
Old 11-05-2011, 12:08 PM   #1 (permalink)
Registered Member
 
Join Date: May 2011
Location: Salisbury, UK
Posts: 5
RabbitFactoryUK is on a distinguished road
Red face External Data

Hi All

Ok so I'm pretty new to this iPhone development thing and I have a couple of questions relating to external data.

Ok, So, say for example I have a website listing, erm say, Websites. The data on the Website is stored in a SQL database and uses PHP to grab this information and display it on the webpage.

What I would like to do is basically if the user on the iPhone has internet access, check query the external database to check if there is any new/edited or deleted records. If there has been then update the information stored within the iPhone app.

What would be the best storage method to use?
How would I be able to essentially sync the database with the iPhone?

If any of you know of any good detailed tutorials to help me along, that would be great.

Thanks in Advance

Chris
RabbitFactoryUK is offline   Reply With Quote
Old 11-05-2011, 12:33 PM   #2 (permalink)
Knows SQL
 
iisword's Avatar
 
Join Date: Oct 2009
Location: Somewhere the streets are on fire, the sewers are flooded, and the cats are high on catnip
Posts: 529
iisword is on a distinguished road
Default

well, you could do SQLite. I would suggest you get the Date the website was added/edit to the external database, and then just compare the websites gotten from the external with the ones on the phone using the last sync date from the phone.
__________________
iisword is offline   Reply With Quote
Reply

Bookmarks

Tags
database, external data, iphone database, json, xml

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



» Advertisements
» Online Users: 409
17 members and 392 guests
7twenty7, Alex-alex, Apptronics RBC, baja_yu, dre, FrankWeller, gwelmarten, ipodphone, jeroenkeij, jleannex55, matador1978, n00b, pbart, reficul, Retouchable, Sami Gh, usernametaken
Most users ever online was 1,387, 04-10-2012 at 04:21 AM.
» Stats
Members: 175,676
Threads: 94,125
Posts: 402,910
Top Poster: BrianSlick (7,990)
Welcome to our newest member, jleannex55
Powered by vBadvanced CMPS v3.1.0

All times are GMT -5. The time now is 06:19 AM.
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0