X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 3879B310A29 for ; Mon, 30 Jun 2003 17:24:51 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 30625-05 for ; Mon, 30 Jun 2003 14:24:41 -0300 (ADT) Received: from tomts13-srv.bellnexxia.net (tomts13.bellnexxia.net [209.226.175.34]) by svr1.postgresql.org (Postfix) with ESMTP id 03EF8310A2D for ; Mon, 30 Jun 2003 14:24:41 -0300 (ADT) Received: from acer.sympatico.ca ([65.95.23.252]) by tomts13-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030630172439.HMCP23042.tomts13-srv.bellnexxia.net@acer.sympatico.ca> for ; Mon, 30 Jun 2003 13:24:39 -0400 Message-Id: <5.2.1.1.0.20030630131653.00aa7df0@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Mon, 30 Jun 2003 13:23:17 -0400 To: pgsql-php@postgresql.org From: Frank Bax Subject: Re: PHP form Creates Blank DB entries In-Reply-To: <3EC8256A-AB16-11D7-8634-00039308EB2C@hwcn.org> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200306/39 X-Sequence-Number: 2103 At 12:16 PM 6/30/03, Michael Hanna wrote: >// error checks on form submission go here >// generate and execute a query >$query = "INSERT INTO addressbook VALUES (nextval('addressbook_id_seq'), >'$name', '$address', '$tel', '$email')"; >$result = pg_query($connection, $query) > or die("Error in query: $query. " . pg_last_error($connection)); >echo "Data successfully added."; >// close database connection >pg_close($connection); } ?> Probably because "register globals" is off (default changed since 4.2.0). http://ca3.php.net/register_globals Insert the following lines before "$query = ..." line: $name = $_POST[name]; $address = $_POST[address]; $tel = $_POST[tel]; $email = $_POST[email];