Building web sites using a database

Started by Jan Muraabout 19 years ago6 messagesgeneral
Jump to latest
#1Jan Mura
jan.mura@volny.cz

Hello,
I would like to ask if there is a genral concept of creating web pages using
a database and PHP or another scripting language.
What I mean is to store basic entities and relations between pages. Only the
certain texts or information regarding every site will differ. But indeex
page, search page, result page and so on for every site should look
similarly so the application select a structure of a page from DB and add
certain text.
I am not sure if I am clear.
The aim is to create sites quickly because a creator just insert into the
database text for every page.
And I am looking for some documentation or info how to do this and how to deal with such things.

Thanks
Jan Mura
jan.mura@volny.cz

#2Chad Wagner
chad.wagner@gmail.com
In reply to: Jan Mura (#1)
Re: Building web sites using a database

On 1/17/07, Jan Mura <jan.mura@volny.cz> wrote:

I would like to ask if there is a genral concept of creating web pages
using
a database and PHP or another scripting language.
What I mean is to store basic entities and relations between pages. Only
the
certain texts or information regarding every site will differ. But indeex
page, search page, result page and so on for every site should look
similarly so the application select a structure of a page from DB and add
certain text.

It sounds like you want a content management system, I would take a look at
the Joomla project. If I recall you can use PostgreSQL as a backend (if not
there is easily 50~60 different content management systems out there ranging
from open source to commercial). I certainly wouldn't write your own.

--
Chad
http://www.postgresqlforums.com/

#3Richard Huxton
dev@archonet.com
In reply to: Jan Mura (#1)
Re: Building web sites using a database

Jan Mura wrote:

Hello,
I would like to ask if there is a genral concept of creating web pages using
a database and PHP or another scripting language.

The term you'll want to search on is "Content Management System" or CMS.
There are plenty to choose from: Plone, Zope, Mambo etc.
Try here to start: http://www.opensourcecms.com/

Although they all provide a front-end to edit pages, they all have the
page text stored in a database (usually PostgreSQL or MySQL).

If that's more than you want, there are many templating systems for php,
perl, python, ruby etc.

--
Richard Huxton
Archonet Ltd

#4Tony Caduto
tony_caduto@amsoftwaredesign.com
In reply to: Jan Mura (#1)
Re: Building web sites using a database

Jan Mura wrote:

Hello,
I would like to ask if there is a genral concept of creating web pages
using
a database and PHP or another scripting language.
What I mean is to store basic entities and relations between pages.
Only the
certain texts or information regarding every site will differ. But indeex
page, search page, result page and so on for every site should look
similarly so the application select a structure of a page from DB and add
certain text.
I am not sure if I am clear.
The aim is to create sites quickly because a creator just insert into the
database text for every page.
And I am looking for some documentation or info how to do this and how
to deal with such things.

Thanks
Jan Mura
jan.mura@volny.cz <mailto:jan.mura@volny.cz>

Well, you could always start with something like Drupal:
http://www.drupal.com
You can create sites very quickly and everything is stored in a Postgresql
or MySQL database.

I recently converted my website to it and could not be more happy :-)

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration

#5shakahshakah@gmail.com
shakahshakah@gmail.com
In reply to: Tony Caduto (#4)
Re: Building web sites using a database

On Jan 17, 1:45 pm, tony_cad...@amsoftwaredesign.com (Tony Caduto)
wrote:

Well, you could always start with something like Drupal:http://www.drupal.com

Do you mean http://drupal.org/ ?

#6John D. Burger
john@mitre.org
In reply to: Tony Caduto (#4)
Re: Building web sites using a database

Well, you could always start with something like Drupal:
http://www.drupal.com

I get access denied, seems to be here, rather: drupal.org

- John Burger
MITRE