Connection function

Anon

Instead of typing out the connection details everytime I want to access my database, I decided to make it a function and just call it when required (shown below).

function setconn() {
// create connection
$dbDatabase = "my db name";
$dbServer = "my server name";
$dbPort = "my port number";
$dbUserName = "my user name";
$dbPassword = "my password";
$connection = pg_connect ( "dbname=$dbDatabase host=$dbServer port=$dbPort user=$dbUserName password=$dbPassword" );
}

This goes okay on it's own but doesn't work when I try to run a query using it.

Would this function have to return $connection?

Anon

Either return the connection or make the connection a global. I think return is better.

chad

Anon

I've changed the function to:
function setconn() {
// create connection
$dbDatabase = "my db name";
$dbServer = "my server name";
$dbPort = "my port number";
$dbUserName = "my user name";
$dbPassword = "my password";
$connection = pg_connect ( "dbname=$dbDatabase host=$dbServer port=$dbPort user=$dbUserName password=$dbPassword" );
return $connection;
}

I now get the error ... Warning: 0 is not a PostgresSQL link index

Anon

Gordon Hope wrote:

I now get the error ... Warning: 0 is not a PostgresSQLlink index

I get that error when I try to fetch a row from a result when there are no results. What code is running when you get that error? Can you give an example of the lines calling the setconn() function and the lines using the result?

Chad

Anon

Invalid Link Index means his connection is failing. Check the dbname,
username, password. Also, if you're connecting remotely (and thus
via tcp/ip rather than unix sockets), make sure that postmaster is
being started with the '-i' option.

Anon

Here is an example of the code I am using:

<?php

include("functions.inc");

// Set the query
$query = "select id, title, author, date, description from article_info";

//Execute and get results
$query_result = pg_exec (setconn(), $query);

//Number of rows in result
$num_rows = pg_numrows($query_result);

//Output results by row
$counter = 0;
while ($counter < $num_rows) {
$result_array = pg_fetch_array($query_result, $counter);
$id = $result_array["id"];

echo ($id);
$counter++;

}

Anon

I ran your code on a local database and it worked for me. When searching through Google, it appears, as Kirk said, that there may be a connection problem first, and then trying to access the connection fails because there is no valid connection made.

Chad