Thread: Calling a Stored Procedure using PHP

I've written a simple stored procedure in postgres and I'm trying to get PHP
to call the function and show the results.  My problem is I can't get PHP to
bring up my results.  I'm using the PHP functions for postgres, such as
pg_exec and pg_fetch_array, but nothing is working.  What do I need to do?
What am I missing?  Can someone help me?

Any help would be very much appreciated.

Wendy

> -----Original Message-----
> Subject: [GENERAL] Calling a Stored Procedure using PHP
>
>
> I've written a simple stored procedure in postgres and I'm trying
> to get PHP
> to call the function and show the results.  My problem is I can't
> get PHP to
> bring up my results.  I'm using the PHP functions for postgres, such as
> pg_exec and pg_fetch_array, but nothing is working.  What do I need to do?
> What am I missing?  Can someone help me?
>
> Any help would be very much appreciated.
>
> Wendy

Are you doing it like this?

$dbh = pg_connect ($connect_string);
$result = pg_exec ($dbh, "SELECT yourstoredprocedure()");

You can't call it directly; you call it as part of a SELECT query.
Then pull the results like you would for any SELECT query.
Hope this helps.

Jason Priebe
Mi-Co
http://www.mi-corporation.com/