RE: Error's management : php-pgsql.

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

 



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@xxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject:  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


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