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
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-DB] Win32 system administrator gpedit.msc
Hi everybody... i`m not a prof in english so please read and understand me.. Thank u. Using the win32 python module can we perform every tasks like *gpedit.msc?* i will like to automate tasks like enabling or disaple some of the windows functions. with my basic experince, you can perform important adminsitrative tasks using gpedit.msc. Like today, some virus hidded my start menu/program file and i have to use gpedit.msc to enable it. point me to some article that talk about this.
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(<**>, <**>, <**>)",
"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
>
>
