communicating with mysql5 stored procedures

[cieletmer]

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!

[Justin Koivisto]

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 - ju****@koivi.com
http://koivi.com

[cieletmer]

Thanks, Justin!

Ciao,

Ciel&Mer

[Kevin Newman]

Justin Koivisto wrote:

You need to use the "MySQL Improved Extension" for features of mysql 4.1
and above...

http://us3.php.net/mysqli

Or PDO?

http://us3.php.net/pdo

Kevin N.

[Justin Koivisto]

Kevin Newman wrote:

Justin Koivisto wrote:

You need to use the "MySQL Improved Extension" for features of mysql
4.1 and above...

http://us3.php.net/mysqli

Or PDO?

http://us3.php.net/pdo

Which is a pear library & uses mysqli - IINM

--
Justin Koivisto, ZCE - ju****@koivi.com
http://koivi.com