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