Received: from www.wgcr.org (IDENT:root@www.wgcr.org [206.74.232.194]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA53589 for ; Mon, 17 Apr 2000 10:51:54 -0400 (EDT) (envelope-from lamar.owen@wgcr.org) Received: from wgcr.org ([206.74.232.197]) by www.wgcr.org (8.9.3/8.9.3/WGCR) with ESMTP id KAA09794; Mon, 17 Apr 2000 10:51:52 -0400 Message-ID: <38FB249D.3AC5AC35@wgcr.org> Date: Mon, 17 Apr 2000 10:50:05 -0400 From: Lamar Owen X-Mailer: Mozilla 4.61 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: "J.Post" CC: pgsql-interfaces@postgresql.org Subject: Re: Connecting website with SQL-database..... References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/97 "J.Post" 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??? For a very easy to use way of doing this, check out AOLserver -- while it does replace your existing webserver, it is fast and easy to use for PostgreSQL. If you are stuck with another webserver, you can probably use PHP, which is also easy to use, but not as scalable or fast as the AOLserver solution. And, you can always use a Perl CGI with either the Perl interface module distributed with the PostgreSQL distribution, or you can use the DBI/DBD modules, also from perl. If you've not written CGI scripts before, expect to speed more than 2 hours getting it to work. If you are comfortable with CGI scripts (or other web scripting), it shouldn't take very long to get the information you need from the PostgreSQL documentation and the PostgreSQL applications listing -- which I can't seem to locate at the moment. There is a users gallery on www.pgsql.com, but that's not the listing I remember.... -- Lamar Owen WGCR Internet Radio 1 Peter 4:11