Bug #33886 [Com]: PDO Prepared Statement fails if binding id (:blah) is used more then once.

From: Date: Tue, 18 Mar 2014 15:54:37 +0000
Subject: Bug #33886 [Com]: PDO Prepared Statement fails if binding id (:blah) is used more then once.
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-184820@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=33886&edit=1

 ID:                 33886
 Comment by:         php at pineight dot com
 Reported by:        wb at pro-net dot co dot uk
 Summary:            PDO Prepared Statement fails if binding id (:blah)
                     is used more then once.
 Status:             Wont fix
 Type:               Bug
 Package:            PDO related
 Operating System:   FreeBSD 5.4-RELEASE-p2
 PHP Version:        5.0.4
 Block user comment: N
 Private report:     N

 New Comment:

Use of named placeholders is also not portable, as MySQL supports only positional placeholders, yet
PDO emulates it. Why does PDO emulate named placeholders on MySQL but not emulate repeated
placeholders? Otherwise, applications using PDO will end up littered with passive-aggressive
workarounds:

  $args[':skuid_bug33886'] = $args[':skuid'];
  $args[':supplierid_bug33886'] = $args[':supplierid'];


Previous Comments:
------------------------------------------------------------------------
[2005-07-27 16:20:41] wb at pro-net dot co dot uk

Fair enougth.

I will submit a note to the php manual about this.

Keep up the good work :)

------------------------------------------------------------------------
[2005-07-27 16:13:08] wez@php.net

It's not portable to rely on that.
You need to create three parameters and bind them separately.

------------------------------------------------------------------------
[2005-07-27 16:04:28] tony2001@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip



------------------------------------------------------------------------
[2005-07-27 16:00:07] wb at pro-net dot co dot uk

Using PDO-0.9 and PDO_PGSQL-0.9

------------------------------------------------------------------------
[2005-07-27 15:57:13] wb at pro-net dot co dot uk

Description:
------------
When using the same binding id in a query the PDOStatement::execute() method still requires you to
specify the same amount of parameters.

Reproduce code:
---------------
<?php
$pdo = new PDO('pgsql:host=localhost dbname=bats user=user password=pass');
$pdo->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_EXCEPTION);

$statement = $pdo->prepare("
            UPDATE groups
            SET
               lft = CASE WHEN lft > :right
                     THEN lft + 2
                     ELSE lft END,
               rgt = CASE WHEN rgt >= :right
                     THEN rgt + 2
                     ELSE rgt END
            WHERE
              rgt >= :right
            ");
$statement->execute(array(':right' => 5));

?>

Expected result:
----------------
Would expect the statement to execute without issue.

Actual result:
--------------
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[08P01]:
<<Unknown error>>: 7 ERROR:  bind message supplies 1 parameters, but prepared statement
"pdo_pgsql_stmt_08257c0c" requires 3' in
/usr/home/wb/bats/scripts/tests/pdoQuery.php:17
Stack trace:
#0 /usr/home/wb/bats/scripts/tests/pdoQuery.php(17): PDOStatement->execute(Array)
#1 {main}
  thrown in /usr/home/wb/bats/scripts/tests/pdoQuery.php on line 17



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



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

Thread (8 messages)

« previous php.bugs (#184820) next »