Posted by Ian Porter on 02/07/05 22:55

Hi,

I am just wondering how to obtain the result from a mysql procedure OUT
parameter within PHP e.g.

MYSQL
create procedure test_out(OUT testvar int)
BEGIN
select max_connections into testvar from mysql.user limit 1;
END

PHP

$query = 'call test_out('.$test_val.')';
$query_handle = mysql_query($query);

but there is nothing within the $test.val, after searching the web there
appears to be something like this for oracle connection with the bind, but I
cannot find the mysql version ?

Any advice ?

Cheers
Ian

• Next in thread: Re: [PHP] PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)
• Next in forum: Re: [PHP] help-regarding-file_get_contents
• Prev in forum: help-regarding-file_get_contents
• Thread view: PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)

[Reply to this message]