rfc:pdov1

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
rfc:pdov1 [2008/05/07 18:20] lsmithrfc:pdov1 [2014/04/08 22:50] – Inactive levim
Line 3: Line 3:
   * Date: 2008-03-06   * Date: 2008-03-06
   * Author: Lukas Smith <smith@pooteeweet.org>   * Author: Lukas Smith <smith@pooteeweet.org>
-  * Status: In the works+  * Status: Draft (Inactive)
  
 This RFC aims to collect a set of ideas to improve PDO version 1. These ideas will hopefully end up in a set of concret feature requests and patches. This RFC aims to collect a set of ideas to improve PDO version 1. These ideas will hopefully end up in a set of concret feature requests and patches.
Line 18: Line 18:
  
 A lot in PDO can be fixed without a new major version. A lot in PDO can be fixed without a new major version.
- 
 ===== Proposal and Patch ===== ===== Proposal and Patch =====
  
Line 35: Line 34:
     * Add ability to bind short binary values     * Add ability to bind short binary values
     * Improve the prepared statement emulation parser to better deal with quoted strings that contain things that look like a placeholder     * Improve the prepared statement emulation parser to better deal with quoted strings that contain things that look like a placeholder
-    * Make it possible to disable parsing and rewriting of placeholders and require the use of the given native syntax+    * Make it possible to disable parsing and rewriting of placeholders and require the use of the given native syntax (:name, $name, ? etc.)
     * Fix the problems with ODBC prepared statements when executing procedures on all platforms.     * Fix the problems with ODBC prepared statements when executing procedures on all platforms.
     * Add support for PDO::PARAM_CLOB and generally work harder on making the LOB behavior more similar across the drivers (see [[http://pecl.php.net/bugs/bug.php?id=7943|Bug 7943]])     * Add support for PDO::PARAM_CLOB and generally work harder on making the LOB behavior more similar across the drivers (see [[http://pecl.php.net/bugs/bug.php?id=7943|Bug 7943]])
     * Add support for datatypes like float and datetime/timestamp     * Add support for datatypes like float and datetime/timestamp
     * Do not force the use of prepared statements internally for simple queries without any parameters     * Do not force the use of prepared statements internally for simple queries without any parameters
 +    * Optionally only use native prepared statement for SQL injection protection, but leverage the ability of some RDBMS to pass the [http://pooteeweet.org/blog/1233 statement and the values in a single call]
   * Improve documentation   * Improve documentation
   * Add support of multiple resultsets for mssql and odbc on all platforms.   * Add support of multiple resultsets for mssql and odbc on all platforms.
Line 50: Line 50:
     * Making quoting function aware of encoding in PDO (add quoting for identifier & value)     * Making quoting function aware of encoding in PDO (add quoting for identifier & value)
   * Improved error handling and debugging   * Improved error handling and debugging
-    * Add some better debugging hooks (like a way to get the last submitted statement, this is important especially when PDO does some rewriting like with prepared statements)+    * Add some better debugging hooks (like a [[bugid@44319|way to get the last submitted statement]], this is important especially when PDO does some rewriting like with prepared statements)
     * For consistency it would be good to clear errors on every call and provide facility to expose multiple notices/errors that have occurred within a transaction     * For consistency it would be good to clear errors on every call and provide facility to expose multiple notices/errors that have occurred within a transaction
     * Throw an exception if a fetch method is call on a statement that has not been executed at least once     * Throw an exception if a fetch method is call on a statement that has not been executed at least once
Line 63: Line 63:
 ==== More about PDO ==== ==== More about PDO ====
  
-  * http://php.net/pdo+  * http://php.net/pdo (userland manual) 
 +  * http://php.net/internals2.pdo (internals manual) 
 +  * http://wiki.php.net/rfc/pdonotices (rfc about database notices which can be handled by PDO)
  
 ==== References ==== ==== References ====
rfc/pdov1.txt · Last modified: 2017/09/22 13:28 by 127.0.0.1