|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #56286 PDO::escapeString() method
Submitted: 2005-02-07 12:21 UTC Modified: 2005-02-09 01:45 UTC
From: Jared dot Williams1 at ntlworld dot com Assigned: wez (profile)
Status: Closed Package: PDO (PECL)
PHP Version: 5_1 CVS-2005-02-07 (dev) OS: Windows 2000/IIS
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
6 - 3 = ?
Subscribe to this entry?

 [2005-02-07 12:21 UTC] Jared dot Williams1 at ntlworld dot com
The bindParam() method works fine for using single string values into a query, but there is no method to use SQL features like 

$letters = array('a', 'b', ...);

to create SQL like

SELECT * FROM test WHERE letter IN ('a', 'b', ...);

with proper string escaping.

A method PDO::escapeString() is required so can build the SQL explicity.



Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2005-02-09 01:45 UTC]
This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on

In case this was a website problem, the change will show
up on the website in short time.
Thank you for the report, and for helping us make PECL better.

Fixed in CVS, release due tomorrow.
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon May 20 06:01:34 2024 UTC