|  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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Bug Type:
From: Jared dot Williams1 at ntlworld dot com
New email:
PHP Version: OS:


 [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 07:01:34 2024 UTC