Forum Moderators: open
I have written plenty of stuff that pulls db generated content into nice neat tables etc, but I have neve tried building a completely dynamic site with *all* my xhtml content in a db, so....
I am writing a site that will pull all content from a database (MySQL & PHP), articles, news, as well as products etc, and then use mod rewrite to transpose to static urls.
I wonder what special considerations there are that anyone might be able to enlighten me on.
For example should I attempt to split the xhtml content say into multiple "components" (Subject, Summary, Other, Content etc)? If there is an image in the content, should that image be statically linked or dynamically as well?
Obviously, somehow maintaining the integrity of the xml content is important for updating and logic etc.
Also, any suggestions on URL layouts etc.
To make matters worse I come from a jsp background, so this really is going to be entertaining ;-)
cheers,
asp
I'm used to using db's to store lots of little bits of information, rather than a small no. of big bits so....
In a long article, should I physically split the content from a db point of view (seems like a bad idea), or allow php to determine the maximum content on any one page? In which case is there a line to be drawn?
asp
Use PHP to break them up, if you need to. How big a chunk is reasonable depends on the bandwidth of your expected audience.
I would go ahead and agree that allowing php to deal with the text is better than breaking it up in the database. I am sure you can imagine all the reasons why.
