php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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 Developer Edit
 [2005-02-07 12:21 UTC] Jared dot Williams1 at ntlworld dot com 
Description:
------------
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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-02-09 01:45 UTC] wez@php.net 
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 pecl.php.net.

In case this was a pecl.php.net 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-2025 The PHP Group
All rights reserved. 		Last updated: Fri Oct 24 18:00:01 2025 UTC