472,993 Members | 1,852 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,993 software developers and data experts.

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

SM
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
Oct 2 '08 #1
7 2008
I'm not an expert but I would think that if you need portability XML
would be a good method. Are the articles currently formatted
consistently (so you could make a parser to convert them)? Or are you
going to have to go through each one and convert it by hand?

On Oct 1, 10:39*pm, SM <servandomont...@gmail.comwrote:
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
Oct 2 '08 #2
..oO(SM)
>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.
Where's the problem? A database would be the right tool. You as the
developer decide if your SQL will be portable or not.

Micha
Oct 2 '08 #3
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.
js*******@attglobal.net
==================

Oct 2 '08 #4
SM
On Oct 2, 8:03*am, Jerry Stuckle <jstuck...@attglobal.netwrote:
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...@attglobal.net
==================
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

Oct 2 '08 #5
On Oct 2, 12:32*pm, SM <servandomont...@gmail.comwrote:
On Oct 2, 8:03*am, Jerry Stuckle <jstuck...@attglobal.netwrote:
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...@attglobal.net
==================

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
Why not try looking into SQLite?

SQLite is a software library that implements a self-contained,
serverless, zero-configuration, transactional SQL database engine.

http://sqlite.org/
Oct 2 '08 #6
SM wrote:
On Oct 2, 8:03 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
>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...@attglobal.net
==================

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

If they don't support a database (MySQL, PostGres, SQL Server, Oracle,
DB2, whatever), then I wouldn't put a site on them anyway.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Oct 2 '08 #7
On Oct 2, 5:32*pm, SM <servandomont...@gmail.comwrote:
On Oct 2, 8:03*am, Jerry Stuckle <jstuck...@attglobal.netwrote:
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...@attglobal.net
==================

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
PHP uses SQLite as a way of providing database functionality on hosts
with no dedicated SQL server. There's a PDO driver for SQLite as well
as more traditional SQLite functions.
Oct 3 '08 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: lkrubner | last post by:
I have a webserver through Rackspace. I create a domain. I create an FTP user. I upload some files. I create a database called testOfSetupScript and then I create a database user named setup. I...
5
by: nmac | last post by:
Hi all, hopefully someone can offer some sagely advice regarding Production use of Jakarta's Tomcat. First, some brief background. My company have a servlet application that connects to a MySQL...
7
by: Joe | last post by:
Hi, I’m new to asp.net. I want to create an asp.net page that allows user to edit the data. I have pasted my code below. I am able to display the data in a datagrid. At the bottom of the page...
2
by: Keith Kowalski | last post by:
I anm opening up a text file reading the lines of the file that refer to a tif image in that file, If the tif image does not exist I need it to send an email stating that the file doesn't exist...
15
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
17
by: IanIpp | last post by:
We have a 3 month old quad processor/dual core server running SQL Server 2005 and already it is getting close to hitting the CPU wall. An 8 way CPU box is prohibitively expensive and out of the...
20
by: mike | last post by:
I help manage a large web site, one that has over 600 html pages... It's a reference site for ham radio folks and as an example, one page indexes over 1.8 gb of on-line PDF documents. The site...
3
by: RgeeK | last post by:
A project I'm thinking about, could use some advice from those who understand the dimensional limits of an SQL-like DB. Imagine, for example, a database containing detailed data for many cities...
1
by: GLEberts | last post by:
I would like to ask some initial advice on the best way to transition my datatbase to be able to store OLE objects. I have spent days researching and it seems like all the articles I have read -...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.