Re: [PHP-DB] PHP and MySQL 5.0 stored procedures

2005-03-11 Thread mohamed naazir
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
[EMAIL PROTECTED] 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
 
 [EMAIL PROTECTED]
 
 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


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



[PHP-DB] PHP and MySQL 5.0 stored procedures

2005-03-10 Thread Guy Harrison
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

[EMAIL PROTECTED]

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