Skip site navigation (1) Skip section navigation (2)

Re: Connecting website with SQL-database.....

From: "Manuel Lemos" <mlemos(at)acm(dot)org>
To: J(dot)Post(at)dtx(dot)nl
Cc: pgsql-general(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-questions(at)postgresql(dot)org
Subject: Re: Connecting website with SQL-database.....
Date: 2000-04-17 14:56:26
Message-ID: 2275.142T1344T7764865mlemos@acm.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-sql
Hello J.Post,

On 17-Apr-00 12:26:41, you wrote:

>I've been looking on the internet for 2 hours for information how to connect
>my SQL database to my website. I didn't find what I was looking for, this is
>my problem............
>I have got a form on my site, that can be filled in by visitors. I want the
>results automatically being written in my sql database, does anybody know
>how to do this???

Whatever platform you use, PHP is the solution for your problem.  It is one
of the most powerful Web programming languages that is able to interface
natively with dozens of types databases including PostgreSQL. The good part
is that it is not tied to any Web server and it is Open Source.

http://www.php.net/

If you want to use a DBMS independent interface with database try Metabase
for PHP.  Metabase not only provides database independence in the access
but also in the installation of your database schemas (tables, fields,
indexes, sequences).

With a Metabase schema description language defined in a custom XML format,
you are able to install your schemas portably without having to wonder
exactly how.

The neat part is that if you want later to change your database schema by
adding/removing/changing/renaming tables/fields/indexes/sequences, all you
need to do is to make the changes in your database schema description file.

Then you only need to ask Metabase to upgrade it and it will issue the
necessary SQL commands to alter your database accordingly without affecting
any data that was stored after the database was installed for the first
time or upgraded for the last time.

Here you may find all the source code for Metabase with all the classes,
for the schema parser, database manager, driver classes for different DBMS
including PostgreSQL, example schemas and installation scripts, user manual
and tutorial documents.

http://phpclasses.UpperDesign.com/browse.html/package/20


Enjoy,
Manuel Lemos

Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos(at)acm(dot)org
--
E-mail: mlemos(at)acm(dot)org
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--


In response to

Responses

pgsql-sql by date

Next:From: Kenn ThompsonDate: 2000-04-17 15:28:47
Subject: Stupid Monday Problem
Previous:From: Lamar OwenDate: 2000-04-17 14:50:05
Subject: Re: Connecting website with SQL-database.....

pgsql-interfaces by date

Next:From: Peter MountDate: 2000-04-17 15:20:21
Subject: RE: JDBC : CallableStatement returns always same Exception
Previous:From: Lamar OwenDate: 2000-04-17 14:50:05
Subject: Re: Connecting website with SQL-database.....

pgsql-general by date

Next:From: Andrew SnowDate: 2000-04-17 14:58:58
Subject: RE: safety of vacuum verbose analyze on active tables
Previous:From: Lamar OwenDate: 2000-04-17 14:50:05
Subject: Re: Connecting website with SQL-database.....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group