At 10:38 AM 3/31/05, SG Edwards wrote:
If I use the following code to connect to postgres using PHP:
<?php
echo "trying to connect to the database...";
$conn =pg_connect("host=localhost dbname=milker dbuser=s0460205
dbpass=password");
if (!$conn) {
echo "no connection";
}
?>
However, the connection is not made. If I try to run it from the command
line in
UNIX I get the following error:
PHP warning: pg_connect(): Unable to connect to PostgreSQL server: invalid
connection option "dbuser" in
/home/s0460205/public_html/first.php on
line 12
The username, database name and password are definately right and my
database is
on the same server as the script (thus I assume localhost for host?) so should
this not work?
READ THE ERROR MESSAGE!! It's telling you that 'dbuser' is not a valid
connection option - you won't find 'dbuser' mentioned anywhere on the man
page (perhaps you should read it more carefully too):
http://www.php.net/manual/en/function.pg-connect.php
