Posted by Ian Porter on 02/08/05 21:49

Curt Zirzow wrote:

> * Thus wrote Ian Porter:
>> 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);
>
> You should really be using the mysqli* interface to mysql. It
> provides better ways to execute things like that.
>
> http://php.net/mysqli

Thanks very much, that did the trick.

Cheers
Ian
>
>
> Curt

• Prev in thread: Re: [PHP] PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)
• Next in forum: Re: [PHP] updating php
• Prev in forum: Re: [PHP] Retrieving an URL paramter via fsockopen
• Thread view: PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)

[Reply to this message]