Re: I need advice on how to create thousands of articles with PHP or else

SM wrote:
Hello,
I have a index.php template (2 columns). The right columns contains a
bunch of links (interviews, poems, etc...) The left columns contains
the actual article.

So if I click on a link on the right menu, the article shows on the
left column.
The links have an url that look like this:
http://www.myweb/library/?doc=194uf7s39

So far, no problem. Everything works like it should.

Here's the question or needed advice. I have more then a thousand
articles (in diferent categories) and i want to know what is the best
way to create those articles. Should i create a PHP file for each one?
Should i create a text file in notepad for each article? Should create
a 'funny' html for each article?
Maybe create an XML file for each article. I can't use MYSQL in this
case for portability reasons.

Each articles contains mostly text, photos, links to other articles.
Most articles are from paper and thought needs to be digitalize in
some way.
Keep in mind that most articles contains special characters (á, é
í...)

I need advice on this issue. I want to use the right method before
starting importing all those articles. I want to get it right the
first time.

Any advice?

Thanks in advance
Marco


As Micha said - a database is the right tool for this.

This won't affect the article at all - it will still be 100% portable. Also, if you follow the SQL standards, your SQL code will be portable; you don't have to use mysql_xxx calls; you can use PDO instead so that everything except your connect string (which can be in a configuration file) is portable.

So, properly designed, the only change you would have to make is one line in one configuration file.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================

.

Relevant Pages