PHP调用存储过程MYSQL传递参数

Question

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