pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: mike <mike@partner2partner.com>
To: Chadwick Rolfs <c2304182@webdevel.urban.csuohio.edu>
Cc: pgsql-php@postgresql.org
Subject: Re: Test
Date: Wed, 13 Jun 2001 23:04:48 GMT
Message-ID: <20010613230448.17922.qmail@conan.partner2partner.org> (raw)
In-Reply-To: <Pine.LNX.4.33.0106131732150.13453-100000@webdevel.urban.csuohio.edu>
References: <Pine.LNX.4.33.0106131732150.13453-100000@webdevel.urban.csuohio.edu>

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@partner2partner.com  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@webdevel.urban.csuohio.edu>
>> To: <pgsql-php@postgresql.org>
>> 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
 



view thread (15+ messages)  latest in thread

Message-ID: <20010613230448.17922.qmail@conan.partner2partner.org>
Permalink:  ../20010613230448.17922.qmail@conan.partner2partner.org/
Also on:    postgresql.org/message-id/20010613230448.17922.qmail@conan.partner2partner.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: mike@partner2partner.com, c2304182@webdevel.urban.csuohio.edu
  Subject: Re: Test
  In-Reply-To: <20010613230448.17922.qmail@conan.partner2partner.org>
  References: <Pine.LNX.4.33.0106131732150.13453-100000@webdevel.urban.csuohio.edu> <20010613230448.17922.qmail@conan.partner2partner.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox