Re: PostgreSQL error with PHP
| From: | Thomas Bonham | Date: | Mon, 27 Jun 2005 00:43:13 +0000 |
| Subject: | Re: PostgreSQL error with PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39785@lists.php.net to get a copy of this message | ||
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 –Eauth-bash-3.00$ createdb auth Thanks Helping