when to use a database

Hi,

When developing a website in general when should I choose to put
content in a database. For menu options, settings, and listings like
products it seems to be clear for me to put them in. But the main
content (article for example) should I put that in a page or in the
database. More in general, when would it benefit to use a database and
when not. Does anyone know a good tutorial or do you have advice
concerning this.

Kind regards,

Roderik

>  Hi,
>
> When developing a website in general when should I choose to put
> content in a database. For menu options, settings, and listings like
> products it seems to be clear for me to put them in. But the main
> content (article for example) should I put that in a page or in the
> database. More in general, when would it benefit to use a database
and
> when not. Does anyone know a good tutorial or do you have advice
> concerning this.
>
> Kind regards,
>
> Roderik
>
>
That's really up to you. If you want to have administration panels
where you can insert, update or delete your news articles, links,
etc. then you may decide to use a database. Also, databases are
useful for storing user comments, tracking & logging and much
more.

Typically, we store any data that may need to be altered in the
database. The reasoning for this is we store the plain text into the
DB and if we want to alter how it appears, we simply modifiy the
script that displays it to the browser. This may be very useful for
you if you are running a large site and you want to format everything
easily (other than just using style sheets wisely).

I hope this helps.


Eric 'phpfreak' Rosebrock

Got LAMP?
http://www.Linuxforum.com
http://www.Apachefreaks.com
http://www.Mysqlfreaks.com
http://www.Phpfreaks.com
http://www.thewebfreaks.com


[b]Fatal error: Call to undefined function: brain() in ./self.php on
line 1[/b]

------------------------------------------
The post originated from PHPFreaks.com:
------------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums

That's a good question :)
"Roderik" <ng@nl100.cjb.net> wrote in message
 news:uer8609gjht4fujd08u4npk85f7mt2mf0r@
4ax.com...
> Hi,
>
> When developing a website in general when should I choose to put
> content in a database. For menu options, settings, and listings like
> products it seems to be clear for me to put them in. But the main
> content (article for example) should I put that in a page or in the
> database. More in general, when would it benefit to use a database and
> when not. Does anyone know a good tutorial or do you have advice
> concerning this.
>
> Kind regards,
>
> Roderik

When the data of a dynamic nature rather than static?

www.lohyugee.com
"Roderik" <ng@nl100.cjb.net> wrote in message
 news:uer8609gjht4fujd08u4npk85f7mt2mf0r@
4ax.com...
> When developing a website in general when should I choose to put
> content in a database. For menu options, settings, and listings like
> products it seems to be clear for me to put them in. But the main
> content (article for example) should I put that in a page or in the
> database. More in general, when would it benefit to use a database and
> when not. Does anyone know a good tutorial or do you have advice
> concerning this.