Re: [PHP] PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)

[Ian Porter]

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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)

[Curt Zirzow]

* 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


Curt
-- 
Quoth the Raven, "Nevermore."

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)

[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);

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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php