Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters
Until TUDBC is available under an accredited FOSS license, nobody in their right mind is going to use it in any project that may need to be ipr encumbrement free at a future date. Posting solutions that pertain to a proprietary technology on a list predominately dedicated to technologies that do meet that requirement is bordering on being classified as commercial spam. On 11 Oct 2008, at 01:52, Post-No-Reply TUDBC wrote: I kindly disagree. The original post asked How to use OUT or INOUT parameters of MySQL's stored procedures in PHP? by STF. To quote STF again in a later post Yes, I've already found that multi-step way before... I was just wondering if anything got better since with regard to this. Apparently not. If you're aware of what developers need to face when dealing with when trying to get an OUT parameter from a stored procedure, there are multi-step way workaround which is cumbersome. My reply is directly offering an alternate way in PHP to solve this problem faced by the original post. On 10/10/08, Fergus Gibson [EMAIL PROTECTED] wrote: 2008/10/10 Post-No-Reply TUDBC [EMAIL PROTECTED]: By using TUDBC (http://www.tudbc.org), you can call stored procedures easily. Your post was an excellent answer to the question, How do I call stored procedures easily with TUDBC? Unfortunately, that is not what the original poster asked. In fact, no one has ever asked that question on this list. Ever. Posting to the list from a generic no-reply address seems pretty rude. But setting aside the irrelevance of your post, the example does not seem EZ at all. In fact, it seems quite a bit more complicated than the comparable code for PDO or mysqli, not to mention both unnecessarily verbose and simultaneously cryptic. -- 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters
TUDBC has recently moved to open-source GPL, similar to how MySQL works. (You probably got the impression that it had proprietary license, maybe because some the obsolete webpages still referred to the old license, so I have corrected those obsolete web pages.) I am not familiar with FOSS, but my reading showed that GPL is the most used open-source license, which was why I chose GPL. On 10/11/08, Tim Hawkins [EMAIL PROTECTED] wrote: Until TUDBC is available under an accredited FOSS license, nobody in their right mind is going to use it in any project that may need to be ipr encumbrement free at a future date. Posting solutions that pertain to a proprietary technology on a list predominately dedicated to technologies that do meet that requirement is bordering on being classified as commercial spam. On 11 Oct 2008, at 01:52, Post-No-Reply TUDBC wrote: I kindly disagree. The original post asked How to use OUT or INOUT parameters of MySQL's stored procedures in PHP? by STF. To quote STF again in a later post Yes, I've already found that multi-step way before... I was just wondering if anything got better since with regard to this. Apparently not. If you're aware of what developers need to face when dealing with when trying to get an OUT parameter from a stored procedure, there are multi-step way workaround which is cumbersome. My reply is directly offering an alternate way in PHP to solve this problem faced by the original post. On 10/10/08, Fergus Gibson [EMAIL PROTECTED] wrote: 2008/10/10 Post-No-Reply TUDBC [EMAIL PROTECTED]: By using TUDBC (http://www.tudbc.org), you can call stored procedures easily. Your post was an excellent answer to the question, How do I call stored procedures easily with TUDBC? Unfortunately, that is not what the original poster asked. In fact, no one has ever asked that question on this list. Ever. Posting to the list from a generic no-reply address seems pretty rude. But setting aside the irrelevance of your post, the example does not seem EZ at all. In fact, it seems quite a bit more complicated than the comparable code for PDO or mysqli, not to mention both unnecessarily verbose and simultaneously cryptic. -- 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters
By using TUDBC (http://www.tudbc.org), you can call stored procedures easily. Better yet, it works on any flavors of PHP (original, Phalanger, or Quercus). Even better, you would use the same style of coding for any DBMSes or programming languages. Have fun! For an example in MySQL (just change the connection string for other DBMSes), TestSumOut(IN x int, IN y int, OUT total int) The PHP codes (using EZ Style) are $vault = new TUDBCConnectionVaultSingle(tudbc:mysqli://localhost//tudbcguest,helloworld/tudbcdemo); $conn = $vault-getConnection(); $ezsql = $conn-getSQL_EZ( call TestSumOut(*?int:x*, *?int:y*, *??int:total*), TestSumOutSprocSQL); $ezsql-getStatement()-parameterSetValues($x, $y); $result = $ezsql-getStatement()-executeUpdate(); $total = $ezsql-getStatement()-sprocGetOutputParameter(2)-getInt(); $ezsql-close(); $conn-close(); $vault-close(); You will find other examples in the demo codes on the website. TUDBC Below is the declaration of the example stored procedure DELIMITER $$ DROP PROCEDURE IF EXISTS TestSumOut` $$ CREATE PROCEDURE `TestSumOut`(x int, y int, OUT total int ) BEGIN set total = x + y; END $$ DELIMITER; On 9/19/08, Stanisław T. Findeisen [EMAIL PROTECTED] wrote: Thodoris wrote: I think that the manual is quite clear on this: http://dev.mysql.com/doc/refman/5.1/en/call.html You use a way to query the database like PDO or mysqli and you wite sql. Yes, I've already found that multi-step way before... I was just wondering if anything got better since with regard to this. Apparently not. STF === http://eisenbits.homelinux.net/~stf/ . My PGP key fingerprint is: 9D25 3D89 75F1 DF1D F434 25D7 E87F A1B9 B80F 8062 === -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters
2008/10/10 Post-No-Reply TUDBC [EMAIL PROTECTED]: By using TUDBC (http://www.tudbc.org), you can call stored procedures easily. Your post was an excellent answer to the question, How do I call stored procedures easily with TUDBC? Unfortunately, that is not what the original poster asked. In fact, no one has ever asked that question on this list. Ever. Posting to the list from a generic no-reply address seems pretty rude. But setting aside the irrelevance of your post, the example does not seem EZ at all. In fact, it seems quite a bit more complicated than the comparable code for PDO or mysqli, not to mention both unnecessarily verbose and simultaneously cryptic. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters
I kindly disagree. The original post asked How to use OUT or INOUT parameters of MySQL's stored procedures in PHP? by STF. To quote STF again in a later post Yes, I've already found that multi-step way before... I was just wondering if anything got better since with regard to this. Apparently not. If you're aware of what developers need to face when dealing with when trying to get an OUT parameter from a stored procedure, there are multi-step way workaround which is cumbersome. My reply is directly offering an alternate way in PHP to solve this problem faced by the original post. On 10/10/08, Fergus Gibson [EMAIL PROTECTED] wrote: 2008/10/10 Post-No-Reply TUDBC [EMAIL PROTECTED]: By using TUDBC (http://www.tudbc.org), you can call stored procedures easily. Your post was an excellent answer to the question, How do I call stored procedures easily with TUDBC? Unfortunately, that is not what the original poster asked. In fact, no one has ever asked that question on this list. Ever. Posting to the list from a generic no-reply address seems pretty rude. But setting aside the irrelevance of your post, the example does not seem EZ at all. In fact, it seems quite a bit more complicated than the comparable code for PDO or mysqli, not to mention both unnecessarily verbose and simultaneously cryptic. -- 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
Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters
: How to use OUT or INOUT parameters of MySQL's stored procedures in PHP? STF === http://eisenbits.homelinux.net/~stf/ . My PGP key fingerprint is: 9D25 3D89 75F1 DF1D F434 25D7 E87F A1B9 B80F 8062 === I think that the manual is quite clear on this: http://dev.mysql.com/doc/refman/5.1/en/call.html You use a way to query the database like PDO or mysqli and you wite sql. Is there something specific that you want to ask? -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters
Thodoris wrote: I think that the manual is quite clear on this: http://dev.mysql.com/doc/refman/5.1/en/call.html You use a way to query the database like PDO or mysqli and you wite sql. Yes, I've already found that multi-step way before... I was just wondering if anything got better since with regard to this. Apparently not. STF === http://eisenbits.homelinux.net/~stf/ . My PGP key fingerprint is: 9D25 3D89 75F1 DF1D F434 25D7 E87F A1B9 B80F 8062 === -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL stored procedures OUT or INOUT parameters
How to use OUT or INOUT parameters of MySQL's stored procedures in PHP? STF === http://eisenbits.homelinux.net/~stf/ . My PGP key fingerprint is: 9D25 3D89 75F1 DF1D F434 25D7 E87F A1B9 B80F 8062 === -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
