You are here

public static function DatabaseUtils::BindValues in Drupal driver for SQL Server and SQL Azure 7.2

Same name and namespace in other branches
  1. 7.3 sqlsrv/utils.inc \DatabaseUtils::BindValues()

Binds a set of values to a PDO Statement, taking care of properly managing binary data.

Parameters

PDOStatement $stmt: PDOStatement to bind the values to

array $values: Values to bind. It's an array where the keys are column names and the values what is going to be inserted.

array $blobs: When sending binary data to the PDO driver, we need to keep track of the original references to data

array $ref_prefix: The $ref_holder might be shared between statements, use this prefix to prevent key colision.

mixed $placeholder_prefix: Prefix to use for generating the query placeholders.

mixed $max_placeholder: Placeholder count, if NULL will start with 0.

3 calls to DatabaseUtils::BindValues()
InsertQuery_sqlsrv::execute in sqlsrv/query.inc
Executes the insert query.
MergeQuery_sqlsrv::execute in sqlsrv/query.inc
Runs the query against the database.
UpdateQuery_sqlsrv::execute in sqlsrv/query.inc
Executes the UPDATE query.

File

sqlsrv/utils.inc, line 67

Class

DatabaseUtils

Code

public static function BindValues(\PDOStatement $stmt, array &$values, array &$blobs, $placeholder_prefix, $columnInformation, &$max_placeholder = NULL, $blob_suffix = NULL) {
  if (empty($max_placeholder)) {
    $max_placeholder = 0;
  }
  foreach ($values as $field_name => &$field_value) {
    $placeholder = $placeholder_prefix . $max_placeholder++;
    $blob_key = $placeholder . $blob_suffix;
    if (isset($columnInformation['blobs'][$field_name])) {
      $blobs[$blob_key] = fopen('php://memory', 'a');
      fwrite($blobs[$blob_key], $field_value);
      rewind($blobs[$blob_key]);
      $stmt
        ->bindParam($placeholder, $blobs[$blob_key], PDO::PARAM_LOB, 0, PDO::SQLSRV_ENCODING_BINARY);
    }
    else {

      // Even though not a blob, make sure we retain a copy of these values.
      $blobs[$blob_key] = $field_value;
      $stmt
        ->bindParam($placeholder, $blobs[$blob_key], PDO::PARAM_STR);
    }
  }
}