Re: Test (fwd)

Your insert idea won't work. SQL knows nothing (in regards to PHP) of
arrays. You actually have to break out the variables.

$query = "insert into <table_name> (field1, field2, field3) values ($text1,
$text2, text3);"

Plus, you have to make sure to check for apostrophes. That will break your
SQL statement if someone typed them into the text field.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Chadwick Rolfs" <c2304182(at)webdevel(dot)urban(dot)csuohio(dot)edu>
To: <pgsql-php(at)postgresql(dot)org>
Sent: Wednesday, June 13, 2001 7:44 PM
Subject: [PHP] Test (fwd)

> 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 <table_name> ($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 <c2304182(at)webdevel(dot)urban(dot)csuohio(dot)edu>
> To: pgsql-php(at)postgresql(dot)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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster