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
