I agree with Adam that the annotated manuals at www.php.net are the
authoritative source for information on how to do what you want to do.
Unfortunately, you will have to do some homework to come up to speed on how
this process works. There is no function that does everything you want for
you in any language that I'm aware of. If you find one let me know!
We use the ADODB library (http://php.weblogs.com/ADODB) which provides
database abstraction for many databases including PostgreSQL. I recommend
it highly.
The data from the form is returned to PHP as a variable with the same name
as the name in the form. The value of this variable is the result returned
by the form. Therefore, your code example of "insert into <table_name>
($web_form_names) values ($web_form_values);" is indeed accurate.
I suggest you download an open source package and see how it is doing this
process. There are many of them available on either www.greatbridge.org or
www.sourceforge.net or www.freshmeat.net or ...
Michael J. Upchurch
Partner2Partner Communications mike@xxxxxxxxxxxxxxxxxxx 615.286.2199
Chadwick Rolfs writes:
Well, thank you very much. I hope that's not sarcasm I detect in this
effort to educate the newbies. I should mention that I am a newbie, I am
constantly reading the documentation, and that I KNOW WHERE TO START.
Here. I got to this list from postgresql.org, and the php lists are tough
to navigate (ie, i recieve, but can't seem to consistently post.)
Maybe, since you seem to be "in the know", you can point out one of the
pgsql/php functions you have mentioned instead of giving me useless
information. That would help...
If you look closely, you'll see that there is a problem, there is really
no function that takes web form contents (yes the name=value pairs, not
the html tags (w3.org can do that!)) and puts these into :
insert into <table_name> ($web_form_names) values ($web_form_values);
Is there anyoneELSE out there who can HELP me? or give me some sort of
constructive advice, instead of making me feel like I'm doing something
horribly wrong, like adam here....
Chadwick Rolfs
On Wed, 13 Jun 2001, Adam Lang wrote:
For starters, you need to clarify hat you mean by "parsing a web form". Do
you mean getting the information that has been inputted, or taking the form
and parsing the html in it?
If it is the former and you want to get the info and put it into a database,
you should start out by reading some documentation and/or getting a PHP
programming book.
This is pretty standard stuff for PHP and if you don't even know where to
start, you should do some reading first.
Your best friend will be www.php.net.
For postgresql connectivity, go there and search on pg_connect. It should
bring up the relevant functions.
Also make sure you have postgres support compiled into your PHP module.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Chadwick Rolfs" <c2304182@xxxxxxxxxxxxxxxxxxxxxxxxxx>
To: <pgsql-php@xxxxxxxxxxxxxx>
Sent: Wednesday, June 13, 2001 3:11 PM
Subject: [PHP] Test
> I can't seem to post to this list that I keep recieving e-mail from. I
> want to parse a web form through php and put it into a postgresql
> batabase. Who can help? or point me toward the right direction...
> thanks.
>
> Chadwick Rolfs
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
