on 5/20/02 7:18 AM, duncan.adams@xxxxxxxxxxxxxxxxx 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@xxxxxxxxx]
> Sent: Monday, May 20, 2002 2:04 PM
> To: angelo.rigo@xxxxxxxxx
> Cc: pgsql-php@xxxxxxxxxxxxxx
> Subject: Re: [PHP] unable to insert rows with php
>
>
> --- angelo.rigo@xxxxxxxxx wrote:
>> Can you show your code ?
>
> yes. it's written for test.
> ------
>
> <html><body>
> <?php
> $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<br>\n", $row[0]);
> printf ("First Name: %s<br>\n", $row[1]);
> printf ("Surname : %s<br>\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"<form action=\"pgsqltest0.php\"
> method=\"post\">";
> echo "First Name : <input type=\"text\"
> name=\"firstname\" size=\"40\" length=\"40\"
> value=\"FirstName\">";
> echo "<BR> Surname : <input type=\"text\"
> name=\"surname\" size=\"40\" length=\"40\"
> value=\"Surname\">";
> echo "<BR><input type=\"submit\" name=\"submit\"
> value=\"Submit\">";
> echo " <input type=\"reset\" name=\"reset\"
> value=\"Clear It\"></form> </body> </html>";
>
> ?>
>
>
>
>> -- 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@xxxxxxxxxxxxxx)
>>>
>>
>>
>>
>>
>> ________________________________________
>> 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@xxxxxxxxxxxxxx
>
> ---------------------------(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"
