Thread: Re: Need more help on data bases over a intranet

Re: Need more help on data bases over a intranet

From
Date:
You currently have pages writing to a text file.  What are those pages
written in.  That is, what programming language is supplying the
functionality of writing to these text files?

David Boerwinkle
-----Original Message-----
From: ghaverla@freenet.edmonton.ab.ca <ghaverla@freenet.edmonton.ab.ca>
To: Fernando M. Maresca <fmaresca@netverk.com.ar>
Cc: pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
Date: Thursday, October 12, 2000 7:36 PM
Subject: Re: [NOVICE] Need more help on data bases over a intranet


>
>On Thu, 12 Oct 2000, Fernando M. Maresca wrote:
>
>>
>> Thanks for your help.
>> Ok, my problem is how send to the DB server  the data entered trough the
>> browser when the user fills the forms, and how can I retrieve the data
>> from the server when is needed to display it in the web page over the
>> intranet.
>> There are no problems to import the text mode data bases.
>> May be you can tell me how I can rewrite the web pages, because now those
appends lines
>> to a text file, and I'm trying to append records to a data base in the
>> server.
>
>[ I need to watch for me making spelling mistakes  :-)  ]
>
>It sounds like you know how to write HTML forms, you now
>want to get this information into a database.
>
>There are LOTS of ways to do this, I have no idea which is
>going to work out best for you.  I am going to suggest that
>you use PHP.  PHP knows how to talk to many databases, including
>PostgreSQL.  Most of the examples you will find are for
>PHP talking to MySQL, but it is not too hard to convert these
>manually to PostgreSQL, and there is one program registered
>at freshmeat.net which can do this automatically.
>
>Basically, instead of ... action="page.html" or
>action="page.cgi", you end up writing action="page.php".
>Then you write a file, (page.php) which has a beginning
>and end (preamble and epilogue) that are html and a center
>part which is PHP.  The PHP language has commands for
>connecting to databases, SELECTing records, INSERTing
>data, and all the other things you might do with SQL.
>
>I can't say I know exactly what to write, I am still learning
>this myself.  There are books out there on PHP.  One place
>to look on the Internet is http://www.php.net/
>
>Hopefully others will be able to help, but if not, I can
>type in a couple of examples from the book I am reading.
>
>Other ways to do this, embed perl in HTML, embed HTML
>in perl, Mason, ASP, ....  Too much variety.  But PHP
>at least has lots of followers.
>
>Gord
>
>Matter Realisations     http://www.materialisations.com/
>Gordon Haverland, B.Sc. M.Eng. President
>101  9504 182 St. NW    Edmonton, AB, CA  T5T 3A7
>780/481-8019            ghaverla @ freenet.edmonton.ab.ca
>780/993-1274 (cell)
>
>