/** * Bind a value of the column or field table * @access public * @param string $column * @param mixed $param * @param string $type * @return void */ public function bindColumn($column, &$param, $type = null) { if ($type === null) { $this->_statement->bindColumn($column, $param); } else { $this->_statement->bindColumn($column, $param, $type); } }
/** * @covers Fabfuel\Prophiler\Decorator\PDO\PDOStatement::bindColumn * @uses Fabfuel\Prophiler\Decorator\PDO\PDOStatement */ public function testBindColumn() { $column = 'foo'; $param = 'bar'; $type = \PDO::PARAM_STR; $maxlen = 15; $driverdata = 'lorem ipsum'; $this->pdoStatement->expects($this->once())->method('bindColumn')->with($column, $param, $type, $maxlen, $driverdata)->willReturn(true); $this->assertTrue($this->decorator->bindColumn($column, $param, $type, $maxlen, $driverdata)); }
/** * Bind a column of the statement result set to a PHP variable. * * @param string $column Name the column in the result set, either by * position or by name. * @param mixed $param Reference to the PHP variable containing the value. * @param mixed $type OPTIONAL * @return bool * @throws Zend_Db_Statement_Exception */ public function bindColumn($column, &$param, $type = null) { try { if (is_null($type)) { return $this->_stmt->bindColumn($column, $param); } else { return $this->_stmt->bindColumn($column, $param, $type); } } catch (PDOException $e) { require_once 'Zend/Db/Statement/Exception.php'; throw new Zend_Db_Statement_Exception($e->getMessage()); } }
protected function bindColumns() { if (!$this->columnsBound) { $this->columnsBound = true; $this->actRow = array(); $this->actRowIndex = array(); $count = $this->pdoStmt->columnCount(); for ($i = 0; $i < $count; $i++) { $meta = $this->pdoStmt->getColumnMeta($i); if (array_key_exists('native_type', $meta) && $meta['native_type'] == 'BLOB') { $this->pdoStmt->bindColumn($i + 1, $this->actRow[$meta['name']], \PDO::PARAM_LOB); } else { $this->pdoStmt->bindColumn($i + 1, $this->actRow[$meta['name']]); } $this->actRowIndex[$i] =& $this->actRow[$meta['name']]; } } }
/** * Bind a column of the statement result set to a PHP variable. * Note: This method exists because pass-by-reference won't work with * call_user_func_array(); * * @param string $column Name the column in the result set, either by position * or by name. Note: if by name must match case. * @param mixed $variable Reference to the PHP variable containing the value. * @param mixed $type OPTIONAL: PDO::PARAM_* Type hint. * @return bool TRUE on success, FALSE on failure */ public function bindColumn($column, &$variable, $type = null) { try { if (is_null($type)) { return $this->_stmt->bindColumn($column, $variable); } else { return $this->_stmt->bindColumn($column, $variable, $type); } } catch (PDOException $e) { throw new DBALite_Exception("Error binding column '{$column}' to PHP variable", $e); } }
public function bindColumn($column, &$param, $type = null, $maxlen = null, $driverdata = null) { switch ($type) { case PDO::PARAM_JSON: case PDO::PARAM_DATETIME: case PDO::PARAM_DATE: case PDO::PARAM_ARRAY: $this->setColumnType($column, $type); $this->_columnsVars[$column] =& $param; break; default: return $this->_statement->bindColumn($column, $param, $type, $maxlen, $driverdata); } return true; }
public function bind(PDOStatement $stmt, YokazeDb_Vo $vo) { $columnCount = $stmt->columnCount(); $columnTypes = array(); $columnNames = array(); $VoNames = array(); for ($i = 0; $i < $columnCount; $i++){ $meta = $stmt->getColumnMeta($i); if (!$meta) break; //if (isset($meta['pdo_type'])) $columnTypes[$i] = $meta['pdo_type']; $columnNames[$i] = $meta['name']; $name = implode('', array_map('ucfirst', explode('_', $meta['name']))); $name[0] = strtolower($name[0]); $voNames[$i] = $name; } for($i = 0; $i < $columnCount; $i++){ $name = $voNames[$i]; $vo->$name = null; $stmt->bindColumn($columnNames[$i], $vo->$name, $columnTypes[$i]); } }
/** * {@inheritdoc} */ public function bindColumn($column, &$param, $type = null, $maxlen = null, $driverdata = null) { return $this->statement->bindColumn($column, $param, $type, $maxlen, $driverdata); }
/** * @param \PDOStatement $stmt * @param $AppID * @param $ComponentID * @param $URL * @param $MenuID */ public function bindMenuValues($stmt, $AppID, $ComponentID, $URL, &$MenuID) { $stmt->bindValue(':AppID', $AppID, PDO::PARAM_STR); $stmt->bindValue(':ComponentID', $ComponentID, PDO::PARAM_STR); $stmt->bindValue(':URL', "%{$URL}", PDO::PARAM_STR); $stmt->bindColumn('MenuID', $MenuID, PDO::PARAM_INT); }
private function bind(\PDOStatement $statement, $values) { $count = 1; foreach ($values as $value) { $statement->bindColumn($count, $value, \PDO::PARAM_STR, strlen($value)); } return $statement; }
/** * @param $column * @param $param * @param null $type * @param null $maxlen * @param null $driverdata * @return bool */ public function bindColumn($column, &$param, $type = null, $maxlen = null, $driverdata = null) { $archLog = array('method' => 'PDOStatement::bindColumn', 'input' => array('column' => $column, 'param' => $param, 'type' => $type, 'maxlen' => $maxlen, 'driverdata' => $driverdata), 'output' => $this->PDOStatement->bindColumn($column, $param, $type, $maxlen, $driverdata), 'pointer' => $this->assignPointerString()); return self::setLogReturnOutput($archLog); }
/** * @inheritdoc */ public function bindColumn($column, &$param, $type = null, $maxlen = null, $driverdata = null) { $this->params[$column] = $param; return parent::bindColumn($column, $param, $type, $maxlen, $driverdata); }