Acessing a wordpress database from an iPhone App

I’ve been asked to create an app that will get data back from a database where the CMS will be WordPress. I’ve never used a CMS so I’m trying to get a (overview)picture in my head of how it could all work and what each of the components would be. And what a CMS actually brings to the party.

Creating the app itself is pretty clear. I’ve done a few already. I’ve made a database before and shouldnt cause a problem.

Read More

But what is going to be in the middle between the app and the database?

Part A:
I’m guessing iphone apps typically would call some php file that’s hosted on the server? The php then would make a call to the database and return the data somehow, maybe as xml. But this is really basic and wouldnt require a CMS. Just a database and a phpfile, or am I wrong?

Part B:
If i wanted to run a check on the database every minute to see if any of the data in database was no longer valid and remove it if needed, that would require somekind of program running on the server. So that program would be WordPress, since it is managing the content, so a content management system is actually needed and is for these kind of taskes. Am i understanding the role of CMS?

Many Thanks,
-Code

Related posts

Leave a Reply

3 comments

  1. Part A: Yes, that’s definitely how it would normally work. Of course, you’re not accessing “a” database, you’re accessing the database WordPress creates, but otherwise, sure.

    Part B: The role of a CMS is to provide a structured, easily-edited way of presenting information. It abstracts both the database and the user interface stuff, allowing the CMS administrator to CRUD data via the use of simple forms.

    In your case, no, you wouldn’t (usually) ask the WordPress software to provide information because it’s not set up to provide data that’s programmatically requested. Instead it’s designed to display HTML pages with the data embedded. The WordPress software is specifically for humans to CRUD the data through a human-friendly interface. You’d write your own, as in Part A.

    This article shows some basic PHP for retrieving blog entries and user comments, likely most of what you’d want. The WordPress database format is well-documented: here’s an article that lays it out and provides more PHP examples for retrieving the information.