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

On Oct 2, 8:03 am, Jerry Stuckle <jstuck...@xxxxxxxxxxxxx> wrote:
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.
jstuck...@xxxxxxxxxxxxx
==================

Thanks for all the advice.
The reason why MySQL is not an option is because some servers were the
articles will reside don't support MySQL. A part from my MYSQL, any
ideas? I've tried using PHP, txt, XML and they all seem to work ok,
except for the special characters. But, i can probably find a
workaround for that one.

Thanks again
Marco

.

Relevant Pages

  • Re: MySQL Question WHERE MATCH
    ... An example from MySQL.com documentation using a FULLTEXT index and MATCH ... id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, ... INSERT INTO articles VALUES ... ('How To Use MySQL Well','After you went through a ...'), ...
    (php.general)
  • Re: File DB instead of real database?
    ... I donot want to use a real DB like MySQL ... ... save about more than 1000 articles. ... The syntax is intuitive for Python programmers (list comprehensions); ...
    (comp.lang.python)
  • Re: I need advice on how to create thousands of articles with PHP or else
    ... way to create those articles. ... case for portability reasons. ... Also, if you follow the SQL standards, your SQL code will be portable; ... The reason why MySQL is not an option is because some servers were the ...
    (comp.lang.php)
  • Re: I need advice on how to create thousands of articles with PHP or else
    ... Here's the question or needed advice. ... way to create those articles. ... case for portability reasons. ... 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. ...
    (comp.lang.php)
  • Re: I need advice on how to create thousands of articles with PHP or else
    ... way to create those articles. ... Also, if you follow the SQL standards, your SQL code will be portable; ... The reason why MySQL is not an option is because some servers were the ... PHP uses SQLite as a way of providing database functionality on hosts ...
    (comp.lang.php)