cvs: pear /MDB2/MDB2 Extended.php
| From: | Lukas Smith | Date: | Sat, 20 May 2006 10:32:17 +0000 |
| Subject: | cvs: pear /MDB2/MDB2 Extended.php | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-40222@lists.php.net to get a copy of this message | ||
lsmith Sat May 20 10:32:17 2006 UTC
Modified files:
/pear/MDB2/MDB2 Extended.php
Log:
- added support for identifier quoting (Request #7671)
http://cvs.php.net/viewcvs.cgi/pear/MDB2/MDB2/Extended.php?r1=1.40&r2=1.41&diff_format=u
Index: pear/MDB2/MDB2/Extended.php
diff -u pear/MDB2/MDB2/Extended.php:1.40 pear/MDB2/MDB2/Extended.php:1.41
--- pear/MDB2/MDB2/Extended.php:1.40 Fri May 5 14:43:18 2006
+++ pear/MDB2/MDB2/Extended.php Sat May 20 10:32:16 2006
@@ -42,7 +42,7 @@
// | Author: Lukas Smith <smith@pooteeweet.org> |
// +----------------------------------------------------------------------+
//
-// $Id: Extended.php,v 1.40 2006/05/05 14:43:18 lsmith Exp $
+// $Id: Extended.php,v 1.41 2006/05/20 10:32:16 lsmith Exp $
/**
* @package MDB2
@@ -153,13 +153,20 @@
return $db;
}
- if (count($table_fields) == 0) {
+ $count = count($table_fields);
+ if ($count == 0) {
return $db->raiseError(MDB2_ERROR_NEED_MORE_DATA);
}
+ if ($db->options['quote_identifier']) {
+ $table_fields = array_values($table_fields);
+ for ($i = 0; $i < $count; ++$i) {
+ $table_fields[$i] = $db->quoteIdentifier($table_fields[$i]);
+ }
+ }
switch ($mode) {
case MDB2_AUTOQUERY_INSERT:
$cols = implode(', ', $table_fields);
- $values = '?'.str_repeat(', ?', count($table_fields)-1);
+ $values = '?'.str_repeat(', ?', $count-1);
return 'INSERT INTO '.$table.' ('.$cols.') VALUES
('.$values.')';
break;
case MDB2_AUTOQUERY_UPDATE: