[PHP-CVS] cvs: php-src(PHP_5_1) /ext/pdo pdo_stmt.c /ext/pdo/tests pdo_028.phpt

[Wez Furlong]

wez             Sat Sep 10 11:32:05 2005 EDT

  Added files:                 (Branch: PHP_5_1)
    /php-src/ext/pdo/tests      pdo_028.phpt 

  Modified files:              
    /php-src/ext/pdo    pdo_stmt.c 
  Log:
  Add PDOStatement::bindValue(), which is similar to bindParam(), except that
  it binds the value of the zval at the time it is called, rather than keeping
  a reference to the zval and taking the value at execute() time.
  
  
  
http://cvs.php.net/diff.php/php-src/ext/pdo/pdo_stmt.c?r1=1.118.2.1&r2=1.118.2.2&ty=u
Index: php-src/ext/pdo/pdo_stmt.c
diff -u php-src/ext/pdo/pdo_stmt.c:1.118.2.1 
php-src/ext/pdo/pdo_stmt.c:1.118.2.2
--- php-src/ext/pdo/pdo_stmt.c:1.118.2.1        Thu Sep  1 10:44:11 2005
+++ php-src/ext/pdo/pdo_stmt.c  Sat Sep 10 11:32:04 2005
@@ -18,7 +18,7 @@
   +----------------------------------------------------------------------+
 */
 
-/* $Id: pdo_stmt.c,v 1.118.2.1 2005/09/01 14:44:11 gschlossnagle Exp $ */
+/* $Id: pdo_stmt.c,v 1.118.2.2 2005/09/10 15:32:04 wez Exp $ */
 
 /* The PDO Statement Handle Class */
 
@@ -1393,6 +1393,36 @@
        return really_register_bound_param(&param, stmt, is_param TSRMLS_CC);
 } /* }}} */
 
+/* {{{ proto bool PDOStatement::bindValue(mixed $paramno, mixed $param [, int 
$type ])
+   bind an input parameter to the value of a PHP variable.  $paramno is the 
1-based position of the placeholder in the SQL statement (but can be the 
parameter name for drivers that support named placeholders).  It should be 
called prior to execute(). */
+static PHP_METHOD(PDOStatement, bindValue)
+{
+       pdo_stmt_t *stmt = (pdo_stmt_t*)zend_object_store_get_object(getThis() 
TSRMLS_CC);
+       struct pdo_bound_param_data param = {0};
+
+       param.paramno = -1;
+       param.param_type = PDO_PARAM_STR;
+
+       if (FAILURE == zend_parse_parameters_ex(ZEND_PARSE_PARAMS_QUIET, 
ZEND_NUM_ARGS() TSRMLS_CC,
+                       "lz/|l", &param.paramno, &param.parameter, 
&param.param_type)) {
+               if (FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, 
"sz/|l", &param.name,
+                               &param.namelen, &param.parameter, 
&param.param_type)) {
+                       RETURN_FALSE;
+               }       
+       }
+
+       if (param.paramno > 0) {
+               --param.paramno; /* make it zero-based internally */
+       } else if (!param.name) {
+               pdo_raise_impl_error(stmt->dbh, stmt, "HY093", 
"Columns/Parameters are 1-based" TSRMLS_CC);
+               RETURN_FALSE;
+       }
+
+       RETURN_BOOL(really_register_bound_param(&param, stmt, TRUE TSRMLS_CC));
+}
+/* }}} */
+
+
 /* {{{ proto bool PDOStatement::bindParam(mixed $paramno, mixed &$param [, int 
$type [, int $maxlen [, mixed $driverdata]]])
    bind a parameter to a PHP variable.  $paramno is the 1-based position of 
the placeholder in the SQL statement (but can be the parameter name for drivers 
that support named placeholders).  This isn't supported by all drivers.  It 
should be called prior to execute(). */
 static PHP_METHOD(PDOStatement, bindParam)
@@ -1835,6 +1865,7 @@
        PHP_ME(PDOStatement, fetch,                     NULL,                   
                ZEND_ACC_PUBLIC)
        PHP_ME(PDOStatement, bindParam,         second_arg_force_ref,   
ZEND_ACC_PUBLIC)
        PHP_ME(PDOStatement, bindColumn,        second_arg_force_ref,   
ZEND_ACC_PUBLIC)
+       PHP_ME(PDOStatement, bindValue,         NULL,                           
        ZEND_ACC_PUBLIC)
        PHP_ME(PDOStatement, rowCount,          NULL,                           
        ZEND_ACC_PUBLIC)
        PHP_ME(PDOStatement, fetchColumn,       NULL,                           
        ZEND_ACC_PUBLIC)
        PHP_ME(PDOStatement, fetchAll,          NULL,                           
        ZEND_ACC_PUBLIC)

http://cvs.php.net/co.php/php-src/ext/pdo/tests/pdo_028.phpt?r=1.1&p=1
Index: php-src/ext/pdo/tests/pdo_028.phpt
+++ php-src/ext/pdo/tests/pdo_028.phpt

-- 
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php