====== updateBlobFile ======
~~NOTOC~~
Support for this function is limited. See the [[v5:database:feature_comparison|Feature Comparison Matrix]]
== Syntax ==
mixed updateBlobFile(
string $tableName,
string $columnName,
string $fileName,
string $whereStatement,
optional string $type='BLOB'
)
===== Description =====
The function ''updateBlobFile()'' updates a column specified by ''$columnName'' in an row of a table, specified by ''$tableName'' directly from a file on disk with a path specified by ''$fileName''.
The physical file must be resident on the server from which the script is run, not the workstation.
===== $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';
$fileName = '/temp/image.jpg';
$db->updateBlob($tableName,$columnName,$fileName,"ID=140")