Re: PHP-Postgres link - Mailing list pgsql-general

From Serj MD
Subject Re: PHP-Postgres link
Date
Msg-id 00041207335203.11384@ocher
Whole thread Raw
In response to Re: PHP-Postgres link  ("omid omoomi" <oomoomi@hotmail.com>)
List pgsql-general
Hello,
I don't speak english, I'm sorry
My example:

$connection = pg_connect("", "", "", "users");
$query = pg_exec($connection, "INSERT INTO login VALUES ( '$userindex', '$uname', '$password', '1')");
$result = pg_exec ($connection, "select * from login");
$num = pgNumRows($result);
for($i = 0; $i < $num; $i++)
{
echo pg_result($result, $i, "userindex") . " | " . pg_result($result, $i, "username") . " | " .  pg_result($result, $i,
"password"). " | " .pg_result($result, $i, "field  4???") . " <BR> " .   
}


???????????????????????????????

Best regards,
Serj MD

> Hi,
> Do you still have your problem? Have you try this :
> $query = "INSERT INTO login('$userindex' , '$uname','$passwrd1', '1')";
>
> Also "LOGIN" might be a reserved word, it would be better if you put another
> name for your table.
>
>
> Regards
> Omid Omoomi
>
> >From: "Ramses v. Pinxteren" <ram6@euronet.nl>
> >To: pgsql-general@postgresql.org
> >Subject: [GENERAL] PHP-Postgres link
> >Date: Sun, 9 Apr 2000 16:53:25 +0200
> >
> >Hi,
> >
> >I am running PHP under APache with a link to a postgres database. It gives
> >me a headache because it is not working.
> >
> >I am running Apache as nobody, and I have made a Postgres user also named
> >nobody.
> >
> >I made a postgres database users (as nobody: createdb users) and with psql
> >a
> >database login (field 1: userindex, field 2 username, field 3 password,
> >field 4 security level)
> >
> >with psql i can do everything I want with this table. adding tuples,
> >deleting them etc. etc.
> >
> >Now what do i need: I need a script that adds a new user to this database.
> >so I created this:
> ><?
> >         $connection = pg_connect("", "", "", "users");
> >         echo ("$connection");
> >         $query = "INSERT INTO users.login VALUES ( '$userindex', '$uname',
> >'$passwrd1', '1')";
> >         echo ("$query");
> >         $result = pg_exec ($connection, "select *");
> >         print (pg_cmdtuples($result));
> >         pg_close($connection);
> >?>
> >
> >This generates an error at the HTML output:
> >
> >1INSERT INTO login VALUES ( '1', 'test', 'test', '1');
> >Warning: PostgresSQL query failed: ERROR: login: Table does not exist. in
> >/usr/local/apache/htdocs/isis.cx/database_update.php3 on line 6
> >
> >Warning: 0 is not a PostgresSQL result index in
> >/usr/local/apache/htdocs/isis.cx/database_update.php3 on line 7
> >
> >
> >in the logffiles is specifies:
> >FindExec: found "/usr/local/postgres/bin/postgres" using argv[0]
> >started: host=localhost user=nobody database=users
> >InitPostgres
> >StartTransactionCommand
> >ERROR:  login: Table does not exist.
> >AbortCurrentTransaction
> >proc_exit(0) [#0]
> >shmem_exit(0) [#0]
> >exit(0)
> >/usr/local/postgres/bin/postmaster: reaping dead processes...
> >/usr/local/postgres/bin/postmaster: CleanupProc: pid 19113 exited with
> >status 0
> >
> >
> >I am a complete newby, so please go easy on me!
> >
> >Tnx!
> >Ramses
> >
> >
> >
> >
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: Can't load plpgsql.so error
Next
From: Andrzej Mazurkiewicz
Date:
Subject: FW: FOREIGN KEY syntax