====== 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")