Cant get Mysql stored procedure to work.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I've had no success trying to execute any stored procedure from php.
I'm just trying to follow the example for multi-query in the php manual, and have tried an example from Artfulsoftware.com. I have one input and one output parameter. I've simplified the stored procedure to always output one value from one record, regardless of the value passed in.
The SP works in Mysql. Just cant run it from php. It returns False.
I look at the query log in mysql and it calls the stored procedure, and shows the input value and output variable. No further information. I'm not familiar with that log so I don't know what it should look like. The only thing I see looks like a brief reference to UTC8 - but I don't think I am (intentionally) using that anywhere. I get no other error back or logged. I'm using root as the user, which is the only defined user. Should this work, or are stored procedures not working well?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux