pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adam Lang <aalang@rutgersinsurance.com>
To: pgsql-php@postgresql.org
Subject: Re: Test (fwd)
Date: Thu, 14 Jun 2001 10:04:49 -0400
Message-ID: <009301c0f4da$f9a71b20$330a0a0a@rutgersinsurance.com> (raw)
References: <Pine.LNX.4.33.0106131937010.13453-100000@webdevel.urban.csuohio.edu>

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




view thread (3+ messages)

Message-ID: <009301c0f4da$f9a71b20$330a0a0a@rutgersinsurance.com>
Permalink:  ../009301c0f4da$f9a71b20$330a0a0a@rutgersinsurance.com/
Also on:    postgresql.org/message-id/009301c0f4da$f9a71b20$330a0a0a@rutgersinsurance.com

 · 

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: aalang@rutgersinsurance.com
  Subject: Re: Test (fwd)
  In-Reply-To: <009301c0f4da$f9a71b20$330a0a0a@rutgersinsurance.com>
  References: <Pine.LNX.4.33.0106131937010.13453-100000@webdevel.urban.csuohio.edu> <009301c0f4da$f9a71b20$330a0a0a@rutgersinsurance.com>

* 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