Re: PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)
| From: | Curt Zirzow | Date: | Tue, 08 Feb 2005 03:45:58 +0000 |
| Subject: | Re: PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-208232@lists.php.net to get a copy of this message | ||
* 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."