Calling postgresql stored procedures from PHP

[newbiepg]

How can I call a postgresql stored procedure from PHP?

 

[rycamor]

Same as any normal query:

$result = pg_query($dblink, "SELECT sp_name($arg1,$arg2,...);");

Now, whether you get the results you are expecting is another question. Remember, the procedure executes on the DB server-side, not in PHP. If the procedure returns results as a SET, then you should be able to loop through those results with pg_result() as if you had queried a table. If you are returning a single value as a result, you could just do something like

$value = pg_result(pg_query($dblink, "SELECT sp_name($arg1,$arg2,...);"),0,0);

Or, if you don't need a result, but just need to know if the procedure executed without error, then you could just do something like

pg_query($dblink, "SELECT sp_name($arg1,$arg2,...);")
   or die(pg_result_error);

Or

if(!pg_query($dblink, "SELECT sp_name($arg1,$arg2,...);"))
{
   //custom error handling
   my_error_handler(pg_result_error());
   //and, any other logic or output...
}
else
{
   //continue normal operations
}

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html

 

[newbiepg]

rycamor thanks
part of my problem is solved