pass postgres connection to multiple functions

Question

I want to create a function that connects to my psql DB "function connectDB(){ }" using pg_pconnect() , and i have multiple functions that do select/ update queries, I am sending the connection as parameter =in these functions to decrease creating multiple connections:

function connectDB() {
    $conStr = "host=" . DB_HOST . " dbname=" . DB_NAME . " user=" . DB_USER . "    password=" . DB_PASS;
     $connection = pg_pconnect($conStr);
     return $connection;
}

function selectDB($connection) {
    $ids = '2,34,56,5,555';
    .
    .
    .
    ....
    $query = "SELECT from users where id IN ($ids)";
    $result = pg_query($connection, $query);

}

am getting this error: invalid connection resource id#14 I think the connection is closed before the query is executed

DJ' · Accepted Answer · 2014-09-15 10:21:42Z

1

Perhaps you should consider how to make a data access layer in your code. Something like this

class dal{

private $connection;

function connectDB() {
    $conStr = "host=" . DB_HOST . " dbname=" . DB_NAME . " user=" . DB_USER . "    password=" . DB_PASS;
     $this->connection = pg_pconnect($conStr);
}

function selectDB($ids) {
    .
    .
    .
    ....
    $query = "SELECT from users where id IN ($ids)";
    $result = pg_query($this->connection, $query);
    return $result;
}

}

now use an instance of this dalin your code. Use the industry standards to make your life easier.

edited Sep 15, 2014 at 10:21

answered Sep 15, 2014 at 9:55

DJ'

1,7781 gold badge13 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

pass postgres connection to multiple functions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related