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

go to bug id or search bugs for

Request #56296 PDO::quoteName() method
Submitted: 2005-02-12 06:59 UTC Modified: 2006-09-11 08:02 UTC
Votes:1
Avg. Score:3.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: Jared dot Williams1 at ntlworld dot com Assigned:
Status: Wont fix Package: PDO (PECL)
PHP Version: 5_0 CVS-2005-02-12 (dev) OS: Windows 2000/IIS
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: Jared dot Williams1 at ntlworld dot com
New email:
PHP Version: OS:

 

 [2005-02-12 06:59 UTC] Jared dot Williams1 at ntlworld dot com 
Description:
------------
Quotes database object names (tables, column, etc) for when they clash with reserved words.

mssql and sqlite uses [tablename], mysql `tablename` etc

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-02-12 12:04 UTC] wez@php.net 
While I can see the utility, PDO can't guarantee that it will know the correct quoting characters in all cases.
Aside from this, PDO leaves the writing of queries largely in your hands (who better to know their database schema?), or in the hands of a more heavy-weight abstraction layer.
There are no plans for this feature at this time.
 [2006-09-11 08:02 UTC] smith at pooteeweet dot org 
I think you misunderstood the request. The request was for a method similar to quote() just for identifier along the lines of MDB2's quoteIdentifier() method:
http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Driver_Common.html#methodquoteIdentifier

So it would place double quotes, brackets or backticks around the identifier.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Dec 27 00:01:30 2024 UTC