function UpdateBlob($table, $column, $val, $where, $blobtype = 'BLOB')
{
$type = $blobtype == 'TEXT' ? 1 : 0;
$blobid = ifx_create_blob($type, 0, $val);
return $this->Execute("UPDATE {$table} SET {$column}=(?) WHERE {$where}", array($blobid));
}
/**
* Execute an SQL query with blob fields processing
* @param String sql
* @param Array blobs
* @param Array blobTypes
* @return Boolean
*/
public function execWithBlobProcessing($sql, $blobs, $blobTypes = array())
{
if (!count($blobs)) {
$this->exec($sql);
return;
}
$blobidarray = array();
foreach ($blobs as $fname => $fvalue) {
if (IsTextType($blobTypes[$fname])) {
$blob_type = 1;
} else {
$blob_type = 0;
}
$blobidarray[] = ifx_create_blob($blob_type, 0, $fvalue);
}
return @ifx_query($sql, $this->conn, $blobidarray);
}
function GetLOBFieldValue($prepared_query, $parameter, $lob, &$value, $binary)
{
if (!$this->Connect(0)) {
return 0;
}
for ($blob_data = ""; !MetabaseEndOfLOB($lob);) {
if (MetabaseReadLOB($lob, $data, $this->lob_buffer_length) < 0) {
return $this->SetError("Get LOB field value", MetabaseLOBError($lob));
}
$blob_data .= $data;
}
if (!($blob = ifx_create_blob($binary ? 0 : 1, 0, $blob_data))) {
return $this->SetIFXError("Get LOB field value", "Could not create a blob");
}
if (!isset($this->query_parameters[$prepared_query])) {
$this->query_parameters[$prepared_query] = $this->query_parameter_values[$prepared_query] = array();
}
$query_parameter = count($this->query_parameters[$prepared_query]);
$this->query_parameter_values[$prepared_query][$parameter] = $query_parameter;
$this->query_parameters[$prepared_query][$query_parameter] = $blob;
$value = "?";
return 1;
}
function UpdateBlob($table, $column, $val, $where, $blobtype = 'BLOB')
{
$type = ($blobtype == 'TEXT') ? 1 : 0;
$blobid = ifx_create_blob($type,0,$val);
return $this->Execute("UPDATE $table SET $column=(?) WHERE $where",array($blobid));
}
