Support for this function is limited. See the Feature Comparison Matrix
mixed updateBlobFile( string $tableName, string $columnName, string $fileName, string $whereStatement, optional string $type='BLOB' )
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.
The where statement must match a row, or set of rows in the table.
The only acceptable values for $type are BLOB
or CLOB
/* * Connection assumed */ $tableName = 'images'; $columnName = 'image_data'; $fileName = '/temp/image.jpg'; $db->updateBlob($tableName,$columnName,$fileName,"ID=140")