PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)
| From: | Ian Porter | Date: | Mon, 07 Feb 2005 20:55:39 +0000 |
| Subject: | PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-208198@lists.php.net to get a copy of this message | ||
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