Received: from cooee.cybersydney.com.au (cooee.cybersydney.com.au [203.25.173.1]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5E0OIE75812 for ; Wed, 13 Jun 2001 20:24:19 -0400 (EDT) (envelope-from csmith@squiz.net) Received: from area51.cybersydney.com.au (area51.cybersydney.com.au [203.25.173.163]) by cooee.cybersydney.com.au (8.8.7/8.8.7) with ESMTP id KAA13285; Thu, 14 Jun 2001 10:28:15 +1000 Message-Id: <4.3.2.7.2.20010614101703.02215160@cooee.cybersydney.com.au> X-Sender: csmith@cooee.cybersydney.com.au X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Thu, 14 Jun 2001 10:22:43 +1000 To: Chadwick Rolfs , From: Chris Smith Subject: Re: Test (fwd) In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200106/19 X-Sequence-Number: 416 Write your own function. function compileinsertquery($table,$formfieldarray,$formfieldvalues) { $insertquery = "INSERT INTO $table ("; foreach ($formfieldarray as $id => $val) { $insertquery .= $val.","; } $insertquery = substr($insertquery,0,-1); # remove last , $insertquery .= ") VALUES ("; foreach ($formfieldvalues as $id => $val) { $insertquery .= "'".$val."',"; } $insertquery = substr($insertquery,0,-1); # remove last , $insertquery .= ")"; echo "your insert query is ".$insertquery; } obviously check it's working ok (this is a 10sec job) before using it. all done. And yes, the pg_exec function is the only way to actually manipulate the database in any way. If you've read the docs, you'd know this. >To reword. > >I am an open source programmer just learning the ropes. I am about >halfway through the php documentation at zend.com, and can't seem to post >to the php.lists.net. So I am asking someone here... >I need to take the entries from several web forms, and put their contents >into a postresql database. The php function pg_exec is the only way I've >seen to actually use INSERT. >Here is my idea: -using arrays > >$query = "insert into ($names_of_form_fields) > values > ($values_of_form_fields); > >so there you have it. >I have been to php.net >I read documentation religiously >i'm simply asking for help >anyone? > > >---------- Forwarded message ---------- >Date: Wed, 13 Jun 2001 15:11:08 -0400 (EDT) >From: Chadwick Rolfs >To: pgsql-php@postgresql.org >Subject: 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. ---------------------- Chris Smith http://www.squiz.net/