Subject | RE: [firebird-php] Selectable SP |
---|---|
Author | Alan McDonald |
Post date | 2005-06-13T06:21:35Z |
Hi,
How do I call a selectable stored proc? I have got a connection to a
database ($conn) but would appreciate a little sample code for calling a
selectable stored proc.
I am a complete PHP n00b so please forgive dumb questions :-)
Rgds
Si Carter
Depends on the abstraction layer (or none) that you use. I use ezSQL - it's
just a matter of SELECT FIELD1, FIELD2,... FROM MYSELSP(:PARAM) WHERE etc.
If you use the PHP functions, the results will be returned in an array. If
you use an abstraction layer, you will get other goodies along with the
call.
It's the same as calling a simple SELECT statement.
Alan
[Non-text portions of this message have been removed]
How do I call a selectable stored proc? I have got a connection to a
database ($conn) but would appreciate a little sample code for calling a
selectable stored proc.
I am a complete PHP n00b so please forgive dumb questions :-)
Rgds
Si Carter
Depends on the abstraction layer (or none) that you use. I use ezSQL - it's
just a matter of SELECT FIELD1, FIELD2,... FROM MYSELSP(:PARAM) WHERE etc.
If you use the PHP functions, the results will be returned in an array. If
you use an abstraction layer, you will get other goodies along with the
call.
It's the same as calling a simple SELECT statement.
Alan
[Non-text portions of this message have been removed]