The error is in your function pg_connect
pg_connect("name=auth user=auth");
I'm not a PostgreSQL user but your connection string should be enclosed into
by quotes. Documentation can be found at
http://us3.php.net/manual/en/function.pg-connect.php
Hope this helps,
Robbert
-----Original Message-----
From: Thomas Bonham [mailto:thomasbbonham@xxxxxxxxx]
Sent: Sunday, June 26, 2005 5:43 PM
To: php-db@xxxxxxxxxxxxx
Subject: Re: PostgreSQL error with PHP
I modafide the code some more and now with the following code I get this
error.
CODE:
<html><head><title>Login</title>
</head>
<body>
<?php
pg_connect(name="auth"); (user="auth");
?>
</body>
</html>
Parse error: parse error, unexpected '=' in
/var/www/html/thomas/cis166ae/database/secretdb.php on line 8
Thanks
Thomas Bonham wrote:
> Hello All,
> I'm trying to get php to connect to my PostgreSQL database.
> The code that I'm using is below.
>
>
> <html><head><title>Login</title>
>
> </head>
> <body>
> <?php
> $conn = "dbname=auth user=auth";
> $db = pg_connect ( $conn );
> ?>
> </body>
> </html>
>
> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL:
> IDENT authentication failed for user "auth" in
> /var/www/html/thomas/cis166ae/database/secretdb.php on line 8
>
> Below is how I set up my database.
>
> root@thomas # Su - postgres
>
> -bash-3.00$ createuser -D -A -E
> auth
> -bash-3.00$ createdb auth
>
> Thanks Helping
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
