====== updateBlob ======
~~NOTOC~~
Support for this function is limited. See the [[v5:database:feature_comparison|Feature Comparison Matrix]]
== Syntax ==
mixed updateBlob(
string $tableName,
string $columnName,
string $blobValue,
string $whereStatement,
optional string $type='BLOB'
)
===== Description =====
The function ''updateBlob()'' updates a column specified by ''$columnName'' in an row of a table, specified by ''$tableName'' with a value specified by ''$blobValue''.
===== $where=====
The where statement must match a row, or set of rows in the table.
===== $type =====
The only acceptable values for $type are ''BLOB'' or ''CLOB''
-------------------------------
===== Usage =====
/*
* Connection assumed
*/
$tableName = 'images';
$columnName = 'image_data';
$fd = file_get_contents('/temp/test.jpg');
$blob = $db->blobEncode($fd);
$db->updateBlob($tableName,$columnName,$blob,"ID=140")