#44639 [Opn]: PDO quotes integers in prepared statement

From:	uw@php.net	Date:	Thu, 24 Sep 2009 09:03:58 +0000
Subject:	#44639 [Opn]: PDO quotes integers in prepared statement
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-142809@lists.php.net to get a copy of this message

 ID:               44639
 Updated by:       uw@php.net
 Reported By:      jgauld at blueyonder dot co dot uk
 Status:           Open
 Bug Type:         PDO related
-Operating System: WinXP
+Operating System: All
-PHP Version:      5.2.10
+PHP Version:      Any > 5.1.x
 New Comment:

Related reports: http://bugs.php.net/bug.php?id=49651 ,
http://bugs.php.net/49381


Previous Comments:
------------------------------------------------------------------------

[2009-09-22 21:18:23] sjoerd@php.net

The third parameter to bindValue defaults to PDO::PARAM_STR. This is
different than the original bug reporter said, so it must be changed in
the meantime. Because the datatype is PDO::PARAM_STR, the int is cast to
a string and quoted.

It would make sense to use the PHP type to determine the most logical
PDO::PARAM_* type. See also bug #44597, which is essentially the same
problem but with booleans and execute() instead of bindValue().

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

[2009-08-17 17:38:15] jani@php.net

But you didn't bother updating the version field. Done now..

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

[2009-07-21 00:30:49] whistl0r+php at googlemail dot com

Hi,

this bug is still present in the current PHP version.
Tested with PHP 5.2.10 stable and snapshot on Windows.

MySQL client api: 5.1.35

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

[2008-10-21 11:59:03] jgauld at blueyonder dot co dot uk

Tried windows snapshot as suggested (5.2.7RC2-dev), but no joy. Result
is same, ie:

select * from my_table where id>'13'

If it helps, phpinfo() reports:

PDO Driver for MySQL, client library version	5.0.51a

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

[2008-07-03 15:17:35] uw@php.net

This is not a driver issue. Its the PDO SQL driver messing up SQL
statements.

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

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
    http://bugs.php.net/44639

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



   

Thread (25 messages)

• jgauld at blueyonder dot co dot ukFri, 04 Apr 2008 15:16:33 +0000
  • dobamail at gmail dot comThu, 12 Jun 2008 13:42:36 +0000#44639 [Com]: PDO quotes integers in prepared statement
  • uw@php.netThu, 03 Jul 2008 15:17:35 +0000#44639 [Opn]: PDO quotes integers in prepared statement
  • jani@php.netTue, 21 Oct 2008 11:27:06 +0000#44639 [Opn->Fbk]: PDO quotes integers in prepared statement
  • jgauld at blueyonder dot co dot ukTue, 21 Oct 2008 11:59:04 +0000#44639 [Com]: PDO quotes integers in prepared statement
  • whistl0r+php at googlemail dot comTue, 21 Jul 2009 00:30:50 +0000#44639 [Com]: PDO quotes integers in prepared statement
  • jgauld at blueyonder dot co dot ukWed, 22 Jul 2009 20:39:31 +0000#44639 [NoF->Opn]: PDO quotes integers in prepared statement
  • jani@php.netMon, 17 Aug 2009 17:38:16 +0000#44639 [Opn]: PDO quotes integers in prepared statement
  • sjoerd@php.netTue, 22 Sep 2009 21:18:24 +0000#44639 [Opn]: PDO quotes integers in prepared statement
  • uw@php.netThu, 24 Sep 2009 09:03:58 +0000#44639 [Opn]: PDO quotes integers in prepared statement
  • mailmichael at yahoo dot comSun, 25 Oct 2009 19:29:29 +0000#44639 [Com]: PDO quotes integers in prepared statement
  • jani@php.netThu, 19 Nov 2009 22:04:22 +0000#44639 [Opn]: PDO quotes integers in prepared statement
  • nathan dot h at makemeheal dot comTue, 16 Feb 2010 00:05:45 +0000#44639 [Com]: PDO quotes integers in prepared statement
  • php at javierparra dot com dot mxFri, 19 Feb 2010 18:47:54 +0000#44639 [Com]: PDO quotes integers in prepared statement
  • stuart at tase dot co dot ukWed, 30 Jun 2010 20:05:44 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • riksoft at gmail dot comWed, 27 Apr 2011 18:24:09 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • stephen-d at rogers dot comTue, 13 Dec 2011 22:33:36 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • engin at e-php dot netFri, 13 Jan 2012 19:50:40 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • preludeinz at gmail dot comSat, 25 Feb 2012 06:28:34 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • alvaro at demogracia dot comMon, 12 Mar 2012 10:15:44 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • alek0585 at mail dot ruWed, 05 Dec 2012 04:02:03 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • mightyuhu@php.netSun, 26 Jan 2014 18:12:50 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • shankao at gmail dot comWed, 17 Jun 2015 02:42:59 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • chealer at gmail dot comThu, 23 Jul 2015 21:58:17 +0000Bug #44639 [Com]: PDO quotes integers in prepared statement
  • adambaratz@php.netMon, 10 Oct 2016 22:27:21 +0000Bug #44639 [Opn->Csd]: PDO quotes integers in prepared statement