Greetings!
Does anyone have examples on how to interact with mysql5 stored
procedures from php?
I have a stored procedure sp_get_values() with last line
SELECT v_computed_valu e1 AS cv1, v_computed_valu e2 AS CV2 ;
When I try to call this from php with the lines:
$sql = "CALL sp_get_values() " ;
$query_result = mysql_query($sq l, $connection) ;
the return value of mysql_query is FALSE and I can't do anything with
the mysql_fetch_* functions.
The SQL-Statement
CALL sp_get_values()
works fine with mysql directly and returns the expected 1 row with 2
columns cv1 and cv2.
While we're on the topic, examples of accessing mysql's OUT parameters
from PHP would also be great.
Many thanks!
Does anyone have examples on how to interact with mysql5 stored
procedures from php?
I have a stored procedure sp_get_values() with last line
SELECT v_computed_valu e1 AS cv1, v_computed_valu e2 AS CV2 ;
When I try to call this from php with the lines:
$sql = "CALL sp_get_values() " ;
$query_result = mysql_query($sq l, $connection) ;
the return value of mysql_query is FALSE and I can't do anything with
the mysql_fetch_* functions.
The SQL-Statement
CALL sp_get_values()
works fine with mysql directly and returns the expected 1 row with 2
columns cv1 and cv2.
While we're on the topic, examples of accessing mysql's OUT parameters
from PHP would also be great.
Many thanks!
Comment