calling a stored postgres function from php

Question

Just a little confused here...

I have a function in postgres, and when I'm at the pg prompt, I just do:

SELECT zp('zc',10,20,90);
FETCH ALL FROM zc;

I'm wondering how to do this from php?

I thought I could just do:

$q = pg_query("SELECT zp('zc',10,20,90)");

But, how do I "fetch" from that query?

Answer 1

Just send the FETCH-query to the database:

$result = pg_query("FETCH ALL FROM zc;");

You can now use a while-loop to fetch all the results in $result or just just pg_fetch_all() to fetch in PHP.