| Bastien Koert 2005-12-07, 6:56 pm |
| try
if (!$pgsql_conn = pg_connect($cnxString, PGSQL_CONNECT_FORCE_NEW))
{
print "Connexion réussie à : " . pg_host($pgsql_conn) . "<br/>\n";
} else {
echo pg_last_notice($pgsql_conn);
exit;
}
bastien
>From: David BOUCHE <willou@willou.net>
>To: php-db@lists.php.net
>Subject: [PHP-DB] Error's management : php-pgsql.
>Date: Wed, 07 Dec 2005 20:46:34 +0100
>
>Hello,
>
>My goal : obtain the error message if the connection fail.
>
>## my code :
>
><?php
>
>$cnxString = "host=localhost port=5432 dbname=toto user=atlante
>password=aiThoo3g";
>
>$pgsql_conn = pg_connect($cnxString, PGSQL_CONNECT_FORCE_NEW);
>
>if ($pgsql_conn) {
> print "Connexion réussie à : " . pg_host($pgsql_conn) . "<br/>\n";
>} else {
> echo pg_last_notice($pgsql_conn);
> exit;
>}
>?>
>
>## if «php_value display_errors 1» the screen result is this one :
>
>Warning: pg_connect() [function.pg-connect]: Unable to connect to
>PostgreSQL server: FATAL: la base de données «toto» n'existe pas in
>/home/willou/public_html/atlanpolis/wwws/tools/checkdb.php on line 5
>
>Warning: pg_last_notice() expects parameter 1 to be resource, boolean
>given in /home/willou/public_html/atlanpolis/wwws/tools/checkdb.php on
>line 10
>
>## If not, i haven't got any result. The message just appears in my logs
>
>The return of pg_connect not seems to be an connection resource when the
>connection fails.
>
>Thanks to help me to find the problem,
>David.
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
|