simple test php with postgresql database

Question

I am using this php to test if I am connected in a postgree database, works very well, but how can I insert a error Message and a Message showing the database is connected and not connected?

Example: like: You are connect to:database_name

or:

You could not connect to:database_name

That is my code:

<?php
    $connection = pg_connect ("host=localhost dbname=site user=postgres password=root");
    ?>

Jay Blanchard · Accepted Answer · 2015-09-21 17:20:44Z

14

Just test the truthiness of the connection:

<?php
    $connection = pg_connect ("host=localhost dbname=site user=postgres password=root");
    if($connection) {
       echo 'connected';
    } else {
        echo 'there has been an error connecting';
    } 
?>

answered Sep 21, 2015 at 17:20

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

klin · Accepted Answer · 2015-09-21 17:21:39Z

5

Return value of pg_connect() is

PostgreSQL connection resource on success, FALSE on failure.

so check this value:

if (!$connection = pg_connect ("host=localhost dbname=site user=postgres password=root")) {
    $error = error_get_last();
    echo "Connection failed. Error was: ". $error['message']. "\n";
} else {
    echo "Connection succesful.\n";
}

answered Sep 21, 2015 at 17:21

klin

123k15 gold badges240 silver badges262 bronze badges

Collectives™ on Stack Overflow

simple test php with postgresql database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related