MySQL Forums
Forum List  »  PHP

PHP call Stored Proc with parameters returning recordset
Posted by: steve pelts
Date: May 09, 2015 06:24AM

I have used mssql & ASP for years and can easily call a SP, pass parameters and return a recordset. However, I am now trying to learn to use PHP & MYSQL. I have searched and cannot get to work. I can from my PHP pages call a SQL statement and output the recordset no problem. However, if I set SQL = "call sp( param1, param2), i get no results. if I from SP from mysql I get a result set.

I have tried mysqli which I read is obsolete??? the PDO I can't find example for me. I see examples that call sp w/o parameters and so forth.

I never imagined to do this would be so challenging and maybe it is just me.

please somebody with example
thanks

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.