[Resolved] PostgreSQL expertise...

n00854180t

I have a script which uses an INNER JOIN query on a PostgreSQL database. Now I have identified that if I try to use this query on the database, no code is executed below the line of the pg_query function. I am not getting any errors however.

Is there something wrong with my query?

function testfunct()
{
echo "This is executed and echoed";
$cartpsql = "SELECT * FROM cart INNER JOIN " . $_SESSION['table'] . " on cart.itemid = " . $_SESSION['table'] . ".itemid WHERE cart.cookieid = '" . GetCartId() . "' ORDER BY " . $_SESSION['table'] . ".itemid ASC";

$result = pg_query($conn, $cartpsql) or die(pg_last_error());
echo "This is never executed and does not get echoed to the browser.";
}

n00854180t

Can anyone help me out?

nightowl

next line is not executed because script died. Obvious.
pg_last_error() doesn't output anything, you have to use echo before it. See manual,
echo the query string and past it to command line interface of PG - see what that gives if you still haven't found anything.

n00854180t

I found the problem! After a weeks worth of work I finally found it. The offending line was this:

$result = pg_query($conn, $cartpsql) or die(pg_last_error());

pg_query($conn, $cartpsql) works when I change it to pg_query($cartpsql).

Yes!! Thank you!

Sxooter

Wow, so PHP must have started supporting explicit connect strings when I wasn't paying attention (and I tested it and yes, they really did... 🙂

The problem was likely that pg_query can use an implicit connect inside a function, but without globalling the connection string, it can't use an explicit one. I.e. These two work:

$conn = pg_connect(...
function a (b){
  global $conn;
  $res = pg_query($conn,"select * from test");
}

OR

$conn = pg_connect(...
function a (b){
  $res = pg_query("select * from test");
}

But this won't:

$conn = pg_connect(...
function a (b){
  $res = pg_query($conn,"select * from test");
}

n00854180t

Yeah that was a nightmare trying to figure out. No errors or anything >_< hehe