Received: from mail1.panix.com (mail1.panix.com [166.84.0.212]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA17922 for ; Tue, 18 Apr 2000 08:55:08 -0400 (EDT) (envelope-from tomg@admin.nrnet.org) Received: from mailhost.nrnet.org (mailhost.nrnet.org [166.84.192.39]) by mail1.panix.com (Postfix) with ESMTP id 9C26830EC8; Tue, 18 Apr 2000 08:55:05 -0400 (EDT) Received: from admin.nrnet.org (uucp@localhost) by mailhost.nrnet.org (8.8.7/8.8.4) with UUCP id IAA17958; Tue, 18 Apr 2000 08:39:32 -0400 Received: from localhost (tomg@localhost) by admin.nrnet.org (8.9.1/8.9.1) with ESMTP id HAA30123; Tue, 18 Apr 2000 07:42:25 -0400 Date: Tue, 18 Apr 2000 07:42:25 -0400 (EDT) From: Thomas Good To: Manuel Lemos Cc: PostgreSQL General List Subject: Re: Connecting website with SQL-database..... In-Reply-To: <20000417171748.B27200@cns.caltech.edu> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200004/390 On Mon, 17 Apr 2000, Titus Brown wrote: > -> >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??? There is more than one way to do it! > -> 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. So is perl...for example, or Zope... > For a good discussion of some of the alternatives (centered around but > not limited to AOLserver) you can visit photo.net/wtr/, the Web/db > bulletin board. > > Not that I recommend anything in particular for your specific situation, > but it's always a good idea to get an idea of what's out there. > > cheers, > --titus Right! My 2 cents: I use Perl DBI::DBD with the "singing, dancing" CGI module. I'm happy with it. If you'd like, visit my site: www.opensystems.org and the links will assist you in downloading the various perl modules. There are samples there too. (DBI and CGI). A DBI mailing list exists as well: http://www.isc.org/dbi-lists.html If you want to skip using the CGI module and code HTML directly into a perl-DBI script, but need some examples: download SQL Ledger from Dieter Simader's page: www.simtax.ca/acc This is a small but robust accounting package that uses Perl and Apache. Lots of luck! Tom --------------------------------------------------------------------------- North Richmond Community Mental Health Center --------------------------------------------------------------------------- Thomas Good, MIS Coordinator tomg@ { admin | q8 } .nrnet.org Phone: 718-354-5528 Fax: 718-354-5056 --------------------------------------------------------------------------- North Richmond Systems PostgreSQL s l a c k w a r e Are Powered By: RDBMS |---------- linux ---------------------------------------------------------------------------