Re: PostgreSQL error with PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux