PHP and MySQL 5.0 stored procedures

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux