Req #52384 [Com]: PDOStatement::debugDumpParams does not emit the bind parameter value

From: Date: Mon, 23 May 2016 16:33:00 +0000
Subject: Req #52384 [Com]: PDOStatement::debugDumpParams does not emit the bind parameter value
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-201243@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=52384&edit=1

 ID:                 52384
 Comment by:         aaron at acwpd dot com
 Reported by:        jonah dot harris at gmail dot com
 Summary:            PDOStatement::debugDumpParams does not emit the bind
                     parameter value
 Status:             Open
 Type:               Feature/Change Request
 Package:            PDO related
 PHP Version:        Irrelevant
 Block user comment: N
 Private report:     N

 New Comment:

Confirming this is still present on PHP 7.0.6-8+donate.sury.org~trusty+1 on Ubuntu  ubuntu1404-x64
(via vagrant box puphpet/ubuntu1404-x64)


Previous Comments:
------------------------------------------------------------------------
[2015-12-07 18:07:17] cjromb at gmail dot com

It's still an issue in 5.6.16

Input:  

    $stmt = $dbh->prepare("SELECT * FROM clients WHERE name LIKE :name");

    $name = "%Boy%";

    $stmt->bindParam(':name',$name, PDO::PARAM_STR);

    if($stmt->execute()):
        echo "It executed.  Here's what it executed";
        $stmt->debugDumpParams();
     endif;  // shortened for this comment

OUTPUT


It executed.  Here's what it executedSQL: [43] SELECT * FROM clients WHERE name LIKE :name
Params:  1
Key: Name: [5] :name
paramno=-1
name=[5] ":name"
is_param=1
param_type=2

^^ Note no param value!

------------------------------------------------------------------------
[2015-10-31 22:17:12] knl at bitflop dot com

The problem still exist in PHP 5.6.14 on Debian Jessie.

Could we please get this fixes ASAP!

------------------------------------------------------------------------
[2015-06-06 02:00:02] felipsmartins at gmail dot com

I run into the same issue. At 2015-06-05

------------------------------------------------------------------------
[2014-02-02 10:12:53] bugs dot php dot net at dotancohen dot com

I can confirm this issue on Ubuntu Server 12.04 with PHP 5.3.10. The output of debugDumpParams()
does not display the value of bound parameters.

------------------------------------------------------------------------
[2013-05-29 07:41:06] cedric dot bethencourt at gmail dot com

same problem with PHP 5.3.3 on Linux Debian

------------------------------------------------------------------------


The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at

    https://bugs.php.net/bug.php?id=52384


--
Edit this bug report at https://bugs.php.net/bug.php?id=52384&edit=1


Thread (15 messages)

« previous php.bugs (#201243) next »