Re: Re: PostgreSQL error with PHP

Thanks for the help. The code now looks like this. CODE: <html><head><title>Login</title> </head> <body> <?php $conn = pg_connect("user=auth dbname=auth password=redhat") or die ("Could not connect") ; echo "Connectd Successfully"; pg_close($conn); ?> </body> </html> And now the error I get is the following. 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 Could not connect Thomas Robbert van Andel wrote:

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@gmail.com] Sent: Sunday, June 26, 2005 5:43 PM To: php-db@lists.php.net Subject: [PHP-DB] 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