Prepared SELECT statements with ODBC?

rtdev

Hi - I am using ODBC with PHP 5. I know how to prepare and execute a statement that does not need to return a result set. For instance an UPDATE statement. But I cannot figure out how to execute a prepared SELECT statement that I can then iterate through the results to get at all the rows.

For instance:
"SELECT foo from table where col1 = ?"

I can then use odbc_prepare, and odbc_execute and the statement runs without an error.

However odbc_execute only returns a boolean to indicate success or failure. I can't figure out how I am supposed to get a "resource' returned that I can then use in statements like odbc_fetch_into.

Am I missing something or is it not possible to use a prepared statement and odbc_execute to get at a result set of rows?

Any help is greatly appreciated. Thanks!!

Weedpacket

You've already got the resource: it's the same one that you got from odbc_prepare and passed in to odbc_execute.

rtdev

Weedpacket;10917573 wrote:
You've already got the resource: it's the same one that you got from odbc_prepare and passed in to odbc_execute.

Yes what I figured out recently is that odbc_execute actually updates the first parameter to contain the resource ID needed to query the results. I found this a bit odd because the parameter gets passed in as one type of object and then gets overwritten with another by the call.

Oddly there is very limited info on the web about using odbc_execute in conjunction with SELECT queries that return results sets - at least, with all the googling I did I didn't see much.

So anyway hopefully this will help someone else one day. Bottom line is that when you call odbc_execute, you use the var passed in for the first parameter in subsequent calls to get at the results.

Weedpacket

Not quite; odbc_execute() doesn't "overwrite" anything, it alters the existing resultset resource that odbc_prepare() returned.