Jump to content

PHP,MYSQL, XML


doob31

Recommended Posts

I have not built anything big with PHP yet, I am starting to plan an application right now.
My question is for long documents with multiple paragraphs (headings, lists and more) should I store them as xml documents on the server and have a link to that data in mySql and just change the XML file?

Or should I store all of the data in a mySQL database and turn process it as xml once the data is returned?


Or should I store the content as XML files in the database?

The content will be generated from a Control Panel so I will have to write the application to save the content the way I want. I am only in the planning stages now but I would like to go the best rought from the start. This Application will be Object Oriented as well.

Some things I have been weighing about this.
--------------------------------------------------------
If I create the application to save XML files on the Server I could have an issue with data integrity.
(is this true?), but I could create backups of the data to run as cron jobs. (And accessing the files would be much faster)

If I store the data in the database it could slow down my site, I do not think this would be that significant, but I really don't know cause I have never created, something like this from scratch.

Or is the best bet to save XML into the database and deliver and change it that way?


Does anyone have any suggestions on what I should do ?...

The application will be used to deliver the same content to both a flash based interface and an html based interface, and elements will need to be styled accordingly of course.

The content must be delivered via XML.


Any help will be greatly appreciated,

Thank You

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.