unable to insert rows with php

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)

Re: 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"

Re: unable to insert rows with php

$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]


-----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"

Re: unable to insert rows with php

ktt writes:
> 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')";

You are not copying the values into the fields you are using in the INSERT
statement:

$firstname = $row[1];
$surname = $row[2];

Or

$query3 = "INSERT INTO friends (id, firstname, surname) values
(nextval('friends_id_seq'), '" . $row[1] . "', '" . $row[2] . "')";

Michael J. Upchurch
Partner2Partner Communications mike@partner2partner.com 615.286.2199


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: unable to insert rows with php

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"