Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 185C247688C for ; Mon, 20 May 2002 12:34:37 -0400 (EDT) Received: from leo.pcisys.net (leo.pcisys.net [207.76.102.240]) by postgresql.org (Postfix) with ESMTP id 6E787476332 for ; Mon, 20 May 2002 12:26:29 -0400 (EDT) Received: from [208.202.106.22] (moe1.meg106-22.cos.pcisys.net [208.202.106.22]) by leo.pcisys.net (8.12.1/8.12.1) via ESMTP id g4KGQXj2029177 for ; Mon, 20 May 2002 10:26:33 -0600 (MDT) env-from (hierophant@pcisys.net) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Mon, 20 May 2002 10:27:08 -0600 Subject: Re: unable to insert rows with php From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <7DD34E6DF5CD1B4283DDAB96A855DCED2F334F@vodabemail1.vodacom.co.za> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200205/78 X-Sequence-Number: 1210 on 5/20/02 7:18 AM, duncan.adams@vcontractor.co.za purportedly said: > > $query3 = "INSERT INTO friends (id, firstname, > surname) values (nextval('friends_id_seq'), > '$firstname', '$surname')"; > > where do u get the values for $firstname and $surname > should that not be $row[1] > and row[2] Actually, this code has a submit form, which is where I would assume the variable values come from. Make sure that register_gloabls is on. Add phpinfo() to the end of the script to check the current value of register_globals. If it is off, which is preferable, then you need to use $_POST (PHP v4.1+) or $HTTP_POST_VARS. As of 4.2.0, register_globals if OFF by default. > > -----Original Message----- > From: ktt [mailto:kestutis98@yahoo.com] > Sent: Monday, May 20, 2002 2:04 PM > To: angelo.rigo@globo.com > Cc: pgsql-php@postgresql.org > Subject: Re: [PHP] unable to insert rows with php > > > --- angelo.rigo@globo.com wrote: >> Can you show your code ? > > yes. it's written for test. > ------ > > > $db = pg_connect("dbname=friends user=kes"); > $query1 = "SELECT * FROM friends"; > $result = pg_exec($db,$query1); > if (!$result) {printf ("ERROR"); > exit; > } > $row = pg_fetch_row ($result,0); > printf ("ID : %s
\n", $row[0]); > printf ("First Name: %s
\n", $row[1]); > printf ("Surname : %s
\n", $row[2]); > $query3 = "INSERT INTO friends (id, firstname, > surname) values (nextval('friends_id_seq'), > '$firstname', '$surname')"; > $result = pg_exec($db, $query3); > if (!$result) { printf ("ERROR"); > $errormessage = pg_errormessage($db); > echo $errormessage; > exit; > } > pg_close(); > printf ("These values were inserted into the database > - %s %s", $firstname, $surname); > > echo"
method=\"post\">"; > echo "First Name : name=\"firstname\" size=\"40\" length=\"40\" > value=\"FirstName\">"; > echo "
Surname : name=\"surname\" size=\"40\" length=\"40\" > value=\"Surname\">"; > echo "
value=\"Submit\">"; > echo " value=\"Clear It\">
"; > > ?> > > > >> -- Mensagem Original -- >> >>> >>> Hello, >>> >>> I'm trying to insert data in the table, using PHP >>> interface, but script creates an empty >>> row without data. >>> If you had similar problem, please, suggest >>> a solution. >>> I'm using Debian potato, PostgreSQL 7.2, >>> Apache 1.3.24. >>> >>> Thank you in advance, >>> >>> ktt >>> >>> >>> >>> >>> __________________________________________________ >>> Do You Yahoo!? >>> LAUNCH - Your Yahoo! Music Experience >>> http://launch.yahoo.com >>> >>> ---------------------------(end of >> broadcast)--------------------------- >>> TIP 2: you can get off all lists at once with the >> unregister command >>> (send "unregister YourEmailAddressHere" to >> majordomo@postgresql.org) >>> >> >> >> >> >> ________________________________________ >> A busca mais veloz e precisa da internet. Acesse >> agora: http://www.zoom.com.br. >> > > > __________________________________________________ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"