PHP and MySQL 5.0 stored procedures
| From: | Guy Harrison | Date: | Thu, 10 Mar 2005 09:37:02 +0000 |
| Subject: | PHP and MySQL 5.0 stored procedures | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38871@lists.php.net to get a copy of this message | ||
Hi all,
I'm new to PHP, but have been doing a lot of work with the MySQL 5.0 alphas
looking at the stored procedure implementation. I wanted to work with
stored procedures in the PHP mysqli interface, but it doesn't seem to be
ready for them yet.
The things I want to do with stored procedures that I can't seem to do yet
are:
* Create a prepared statement based on "call stored proc" (I get 'This
command is not supported in the prepared statement protocol yet')
* Retrieve the value of an OUT parameter from a stored procedure. Eg,
after I execute the stored procedure I should be able to look into a
variable bound to the stored procedure and see the value put in there by the
stored procedure.
* Retrieve multiple result sets from the stored procedure. Stored
procedures can return any number of result sets, so I'm looking for somthing
like the multi_query call to operate against a prepared statement.
I'm wondering if anyone knows if there is any activity around getting mysqli
ready for 5.0, and if there is any advanced info about how it might work.
Thanks,
Guy
guy.a.harrison@gmail.com