0

I have looked and tried but to no avail. I have a SP in MYSQL proc( par1 )

When I pass SQL string call proc(var1), the result is blank. I can call proc from MYSQL and get results but not from PHP page.

I have looked at so many ways and such but nothing works. does somebody have or can point me to example. simple. already have proc set and tested.

I can call SQL from PHP and get result sets just not from SP.

simple please

connect to DB
var = 2 ;
SQL = "call proc( $var ) "
call SQL/query with SQL
return result.  this particular sp only returns one row

the result is a recordset/rows of data.

thanks

Improve this question
6
  • possible duplicate of Stored Procedures, MySQL and PHP Commented May 5, 2015 at 14:06
  • I am thoroughly confused. I have been doing MSSQL & ASP.net/ASP for years. I can do that stuff blindfolded. As I look for examples to learn how to the PHP & MYSQL using Stored Procedure thing, it seems to be kind of vague. I can easily from PHP execute a SQL statement but doing Stored Proc doesn't seem to be an easy option. I see references to that one cannot trying with sqli and/or PDO . what am I missing??? Commented May 6, 2015 at 19:51
  • what did you try so far? Commented May 6, 2015 at 19:54
  • Alex, thanks for replying.... I can't find an example Commented May 7, 2015 at 11:52
  • here is code that I use to extract rows from db w/o error. however, if i set $SQL to call a SP and then try to output the rows i get NOTHING. Commented May 7, 2015 at 11:52
Related questions
0
Calling the stored procedure
2
call stored procedure using php
0
call mysql stored procedure in php
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.