Re: PHP pg_connect

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Vince <vincej(at)gmail(dot)com>
Subject: Re: PHP pg_connect
Date: 2007-07-17 07:45:46
Message-ID: 469C73AA.2010802@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 17.07.2007 09:13, Vince wrote:
> When this fails, I get a useful error print:
>
> $dbconn = pg_connect($connection_str);
>
> Ouput:
>
> Warning: pg_connect() [function.pg-connect]: Unable to connect to
> PostgreSQL server: FATAL: password authentication failed for user
> "postgres1" in ...
>
> How do I capture this error and handle the printing myself? I want to
> be able to know why it failed... ie password in this case.

This is a PHP, not a PostgreSQL question.

if (!pg_connect()) {
if (preg_match('/authentication\sfailed/', pg_last_error())) {
echo "Oh dear, you lost your password?\n";
} else if (true) {
echo "OMG, something else went wrong!\n";
}
}

--
Regards,
Hannes Dorbath

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2007-07-17 07:52:27 Re: PHP pg_connect
Previous Message Vince 2007-07-17 07:13:08 PHP pg_connect