|
|
Posted by Justin Koivisto on 11/07/51 11:31
cieletmer wrote:
> 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_value1 AS cv1, v_computed_value2 AS CV2 ;
>
> When I try to call this from php with the lines:
>
> $sql = "CALL sp_get_values()" ;
> $query_result = mysql_query($sql, $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!
>
You need to use the "MySQL Improved Extension" for features of mysql 4.1
and above...
http://us3.php.net/mysqli
--
Justin Koivisto, ZCE - justin@koivi.com
http://koivi.com
Navigation:
[Reply to this message]
|