Re: PHP and MySQL 5.0 stored procedures
| From: | mohamed naazir | Date: | Fri, 11 Mar 2005 10:57:08 +0000 |
| Subject: | Re: PHP and MySQL 5.0 stored procedures | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38872@lists.php.net to get a copy of this message | ||
plese don't ask qustion i am now start to do php and my sql don't sent
any mail please
On Thu, 10 Mar 2005 20:37:02 +1100, Guy Harrison
<guy.a.harrison@gmail.com> wrote:
> 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
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>