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@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
