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

Re: 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: 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

Re: MySQL stored procedures OUT or INOUT parameters

QnkgdXNpbmcgVFVEQkMgKGh0dHA6Ly93d3cudHVkYmMub3JnKSwgeW91IGNh biBjYWxsIHN0b3Jl
ZCBwcm9jZWR1cmVzCmVhc2lseS4gQmV0dGVyIHlldCwgaXQgd29ya3Mgb24g YW55IGZsYXZvcnMg
b2YgUEhQIChvcmlnaW5hbCwKUGhhbGFuZ2VyLCBvciBRdWVyY3VzKS4gRXZl biBiZXR0ZXIsIHlv
dSB3b3VsZCB1c2UgdGhlIHNhbWUgc3R5bGUgb2YKY29kaW5nIGZvciBhbnkg REJNU2VzIG9yIHBy
b2dyYW1taW5nIGxhbmd1YWdlcy4gSGF2ZSBmdW4hCgpGb3IgYW4gZXhhbXBs ZSBpbiBNeVNRTCAo
anVzdCBjaGFuZ2UgdGhlIGNvbm5lY3Rpb24gc3RyaW5nIGZvciBvdGhlciBE Qk1TZXMpLAoKICAg
ICBUZXN0U3VtT3V0KElOIHggaW50LCBJTiB5IGludCwgT1VUIHRvdGFsIGlu dCkKClRoZSBQSFAg
Y29kZXMgKHVzaW5nIEVaIFN0eWxlKSBhcmUKCiR2YXVsdCA9IG5ldyBUVURC Q0Nvbm5lY3Rpb25W
YXVsdFNpbmdsZSgidHVkYmM6bXlzcWxpOi8vbG9jYWxob3N0Ly90dWRiY2d1 ZXN0LGhlbGxvd29y
bGQvdHVkYmNkZW1vIik7CiRjb25uID0gJHZhdWx0LT5nZXRDb25uZWN0aW9u KCk7CiRlenNxbCA9
ICRjb25uLT5nZXRTUUxfRVooCiAgICAiY2FsbCBUZXN0U3VtT3V0KDwqPD9p bnQ6eD4qPiwgPCo8
P2ludDp5Pio+LCA8Kjw/P2ludDp0b3RhbD4qPikiLAogICAgIlRlc3RTdW1P dXRTcHJvY1NRTCIp
OwokZXpzcWwtPmdldFN0YXRlbWVudCgpLT5wYXJhbWV0ZXJTZXRWYWx1ZXMo JHgsICR5KTsKJHJl
c3VsdCA9ICRlenNxbC0+Z2V0U3RhdGVtZW50KCktPmV4ZWN1dGVVcGRhdGUo KTsKJHRvdGFsID0g
JGV6c3FsLT5nZXRTdGF0ZW1lbnQoKS0+c3Byb2NHZXRPdXRwdXRQYXJhbWV0 ZXIoMiktPmdldElu
dCgpOwokZXpzcWwtPmNsb3NlKCk7CiRjb25uLT5jbG9zZSgpOwokdmF1bHQt PmNsb3NlKCk7CgpZ
b3Ugd2lsbCBmaW5kIG90aGVyIGV4YW1wbGVzIGluIHRoZSBkZW1vIGNvZGVz IG9uIHRoZSB3ZWJz
aXRlLgoKVFVEQkMKCgpCZWxvdyBpcyB0aGUgZGVjbGFyYXRpb24gb2YgdGhl IGV4YW1wbGUgc3Rv
cmVkIHByb2NlZHVyZQoKREVMSU1JVEVSICQkCkRST1AgUFJPQ0VEVVJFIElG IEVYSVNUUyBUZXN0
U3VtT3V0YCAkJApDUkVBVEUgUFJPQ0VEVVJFIGBUZXN0U3VtT3V0YCh4IGlu dCwgeSBpbnQsIE9V
VCB0b3RhbCBpbnQgKQpCRUdJTgoJc2V0IHRvdGFsID0geCArIHk7CkVORCAk JApERUxJTUlURVI7
CgoKT24gOS8xOS8wOCwgIlN0YW5pc7NhdyBULiBGaW5kZWlzZW4iIDxzdGZA ZWlzZW5iaXRzLmhv
bWVsaW51eC5uZXQ+IHdyb3RlOgo+IFRob2RvcmlzIHdyb3RlOgo+Cj4gPiBJ IHRoaW5rIHRoYXQg
dGhlIG1hbnVhbCBpcyBxdWl0ZSBjbGVhciBvbiB0aGlzOgo+ID4KPiA+IGh0 dHA6Ly9kZXYubXlz
cWwuY29tL2RvYy9yZWZtYW4vNS4xL2VuL2NhbGwuaHRtbAo+ID4KPiA+IFlv dSB1c2UgYSB3YXkg
dG8gcXVlcnkgdGhlIGRhdGFiYXNlIGxpa2UgUERPIG9yIG15c3FsaSBhbmQg eW91IHdpdGUgc3Fs
Lgo+ID4KPgo+ICBZZXMsIEkndmUgYWxyZWFkeSBmb3VuZCB0aGF0IG11bHRp LXN0ZXAgd2F5IGJl
Zm9yZS4uLiBJIHdhcyBqdXN0IHdvbmRlcmluZwo+IGlmIGFueXRoaW5nIGdv dCBiZXR0ZXIgc2lu
Y2Ugd2l0aCByZWdhcmQgdG8gdGhpcy4KPgo+ICBBcHBhcmVudGx5IG5vdC4K Pgo+ICBTVEYKPgo+
ID09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09
PT09PT09PT09PT09PT09Cj4gIGh0dHA6Ly9laXNlbmJpdHMuaG9tZWxpbnV4 Lm5ldC9+c3RmLyAu
IE15IFBHUCBrZXkKPiBmaW5nZXJwcmludCBpczoKPiAgOUQyNSAzRDg5IDc1 RjEgREYxRCBGNDM0
ICAyNUQ3IEU4N0YgQTFCOSBCODBGIDgwNjIKPiA9PT09PT09PT09PT09PT09 PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQo+ Cj4gIC0tCj4gIFBI
UCBEYXRhYmFzZSBNYWlsaW5nIExpc3QgKGh0dHA6Ly93d3cucGhwLm5ldC8p Cj4gIFRvIHVuc3Vi
c2NyaWJlLCB2aXNpdDogaHR0cDovL3d3dy5waHAubmV0L3Vuc3ViLnBocAo+ Cj4K

Re: MySQL stored procedures OUT or INOUT parameters

2008/10/10 Post-No-Reply TUDBC :
> 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: 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 wrote:
> 2008/10/10 Post-No-Reply TUDBC :
>
> > 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: 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 wrote:
>> 2008/10/10 Post-No-Reply TUDBC :
>>
>>> 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: 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 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 wrote:
> >
> > > 2008/10/10 Post-No-Reply TUDBC :
> > >
> > >
> > > > 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